diff --git a/BarcodeXlsx/BarcodeXlsx.csproj b/BarcodeXlsx/BarcodeXlsx.csproj index 3230d64..65548c0 100644 --- a/BarcodeXlsx/BarcodeXlsx.csproj +++ b/BarcodeXlsx/BarcodeXlsx.csproj @@ -5,11 +5,13 @@ netcoreapp2.2 + + diff --git a/BarcodeXlsx/DecodeArgumentParamaters.cs b/BarcodeXlsx/DecodeArgumentParamaters.cs index 2ebd917..a967e94 100644 --- a/BarcodeXlsx/DecodeArgumentParamaters.cs +++ b/BarcodeXlsx/DecodeArgumentParamaters.cs @@ -13,6 +13,7 @@ public bool enabledVerbose = false; public bool enabledProgress = false; public bool enabledLabel = false; + public bool enabledRemoveTag = false; public int imageWidht = 256; public int imageHeight = 64; @@ -60,6 +61,10 @@ { enabledLabel = true; } + else if (arg == "-removetag") + { + enabledRemoveTag = true; + } else if (arg == "-progress") { enabledProgress = true; diff --git a/BarcodeXlsx/Program.cs b/BarcodeXlsx/Program.cs index e3b1214..8e2e1ee 100644 --- a/BarcodeXlsx/Program.cs +++ b/BarcodeXlsx/Program.cs @@ -10,6 +10,8 @@ using ClosedXML.Excel; using ClosedXML.Excel.Drawings; +using ImageMagick; + namespace BarcodeXlsx { class Program @@ -65,13 +67,25 @@ barcode.ImageFormat = ImageFormat.Bmp; barcode.Encode(DecodeBarcodeStyle(barcodeType), barcodeValue); - MemoryStream tempStream = new MemoryStream(); - barcode.EncodedImage.Save(tempStream, ImageFormat.Png); - var picture = sheet.AddPicture(tempStream); + MemoryStream tempStream1 = new MemoryStream(); + barcode.EncodedImage.Save(tempStream1, ImageFormat.Png); + + tempStream1.Position = 0; + MagickImage image = new MagickImage(tempStream1); + image.Transparent(MagickColors.White); + MemoryStream tempStream2 = new MemoryStream(); + image.Write(tempStream2, MagickFormat.Png); + + var picture = sheet.AddPicture(tempStream2); picture.MoveTo(cell); picture.Scale(0.5, true); picture.Height = (int)(cell.WorksheetRow().Height / 0.75); picture.Width = (int)(cell.WorksheetColumn().Width / 0.118); + + if (param.enabledRemoveTag) + { + cell.SetValue(""); + } } catch (Exception exp) { diff --git a/BarcodeXlsx/Properties/launchSettings.json b/BarcodeXlsx/Properties/launchSettings.json index bd35be1..b1dc9a4 100644 --- a/BarcodeXlsx/Properties/launchSettings.json +++ b/BarcodeXlsx/Properties/launchSettings.json @@ -2,7 +2,7 @@ "profiles": { "BarcodeXlsx": { "commandName": "Project", - "commandLineArgs": "-source C:\\Users\\mikah\\Desktop\\Book1.xlsx -verbose" + "commandLineArgs": "-source C:\\Users\\07121\\Desktop\\Book1.xlsx -verbose -removetag" } } } \ No newline at end of file