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