ByteScout Premium Suite – C# – Generate barcodes from excel with barcode sdk

Home
/
Articles
/
ByteScout Premium Suite – C# – Generate barcodes from excel with barcode sdk

printable version:
ByteScout-Premium-Suite-C-sharp-Generate-barcodes-from-excel-with-barcode-sdk.pdf

How to generate barcodes from excel with barcode sdk in C# with ByteScout Premium Suite

Learn to generate barcodes from excel with barcode sdk in C#

The code displayed below will guide you to install an C# app to generate barcodes from excel with barcode sdk. Want to generate barcodes from excel with barcode sdk in your C# app? ByteScout Premium Suite is designed for it. ByteScout Premium Suite is the bundle that includes twelve SDK products from ByteScout including tools and components for PDF, barcodes, spreadsheets, screen video recording.

This prolific sample source code in C# for ByteScout Premium Suite contains various functions and other necessary options you should do calling the API to generate barcodes from excel with barcode sdk. Follow the instructions from scratch to work and copy the C# code. Enjoy writing a code with ready-to-use sample C# codes.

Our website gives trial version of ByteScout Premium Suite for free. It also includes documentation and source code samples.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Program.cs

      using System;
using System.Data.OleDb;
using Bytescout.BarCode;

namespace GenerateFromDatabase
{
	class Program
	{
		static void Main(string[] args)
		{
			// Create Barcode generator instance 
			using (Barcode barcode = new Barcode())
			{
				// Set barcode type to QR Code
				barcode.Symbology = SymbologyType.Code128;

				// Create database connection
				using (OleDbConnection connection =
					new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Book1.xlsx;Extended Properties='Excel 8.0;HDR=Yes'"))
				{
					connection.Open();

					// Create SQL query
					using (OleDbCommand command = connection.CreateCommand())
					{
						command.CommandText = "SELECT * FROM [Sheet1$]";

						OleDbDataReader dataReader = command.ExecuteReader();

						// Iterate values and generate barcode images 
						int i = 0;
						while (dataReader.Read())
						{
							barcode.Value = Convert.ToString(dataReader.GetValue(0));
							barcode.SaveImage(barcode.Value + ".png");
							i++;
						}
					}
				}
			}
		}
	}
}