Hepl Create Qr code and Export to excel file in c# winform

Question

I need create bulk qr code in database and export file excel. help me please!

Marvin Reid · Answer

You can use the BarcodeEngine class in the LEADTOOLS SDK to allow you to create QR codes in bulk. You can then export the changes into an Excel file using the RasterCodecs Save method. You can try building on the following code: static BarcodeEngine barcodeEngine = new BarcodeEngine(); static void Main( string [] args) { using (RasterImage image = RasterImage.Create(800, 800, 24, 300, RasterColor.White)) { WriteQRBarcode(image); SaveImage(image, @ "C:	emp\WriteQRCodes.xlsx" ); } } static void WriteQRBarcode(RasterImage image) { QRBarcodeData data = new QRBarcodeData { SymbolModel = QRBarcodeSymbolModel.Model1AutoSize, Symbology = BarcodeSymbology.QR, Value = "QR Data Value" , Bounds = new LeadRect(10, 250, image.ImageWidth, image.ImageHeight) }; QRBarcodeWriteOptions options = new QRBarcodeWriteOptions { GroupNumber = 0, GroupTotal = 0, XModule = 30, ECCLevel = QRBarcodeECCLevel.LevelL, HorizontalAlignment = BarcodeAlignment.Near, VerticalAlignment = BarcodeAlignment.Near }; barcodeEngine.Writer.WriteBarcode(image, data, options); } static void SaveImage(RasterImage image, string outputFilename) { using (RasterCodecs codecs = new RasterCodecs()) codecs.Save(image, outputFilename, RasterImageFormat.Xlsx, 0); Console.WriteLine( string .Format( "The barcodes have been written and saved to {0}" , outputFilename)); } https://www.leadtools.com/help/sdk/v21/tutorials/barcode/cross-platform/dotnet-core/write-1d-and-2d-barcodes-to-an-image.html https://www.leadtools.com/help/sdk/v21/dh/co/rastercodecs-save.html

Leon D · Answer

You can use free spire.barcode library to create qr code. https://www.e-iceblue.com/Tutorials/Spire.Barcode/Spire.Barcode-Program-Guide/Create-a-QR-Code-in-C.html And then use free spire.xls library to insert the qr code image into excel: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/NET-Excel-Image-Insert-Image-in-Excel-with-C-VB.NET.html

Amit Mohanty · Answer

Hey check the below link https://github.com/codebude/QRCoder

Hepl Create Qr code and Export to excel file in c# winform

Answers (3)