Resolved Extracting data from Excel with C# Form and printing barcodes

[gceylandag]

There are products in our company's warehouse. Products have barcodes and item numbers. Saved in Excel.
For example, when the product code is written on the form, we want a label to be written on the Argox Brand label machine.
How can we do this?

 

[Skydiver]

Nothing what you need to accomplish is WinForms specific. You could equally do the same with some other UI framework.

You would use some kind of library from read from the Excel file if you don't want to use the OLEDB ACE drivers to read from Excel. Alternatively, if you know that the Excel file will be from Office 2007 and later, you could go through the learning curve of the OpenXML SDK to read the file directly. Or if you know that Excel is installed on the machine, and this is a desktop app, you could use the Office Automation interop libraries to have Excel open the file and then you can read the cell values using the same automation objects.

For printing, you would generate the barcode using a bar code library and render to an image, and then send the image to the printer. How you send to the printer may depend on your choice of UI frameworks because some of them make it relatively easy to print.

 

[cjard]

There also exists barcode fonts, and printing a label with a barcode on would be the same process as printing any other kind of text, just with a different font set. Find out what barcode standard you need to print as a first step and look into how you will generate them eg via a font (if it's simplistic like 139) or via a dedicated library (if it's complex like a QR)