ByteScout Barcode Suite – C# – Convert xlsx to sql server with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Convert xlsx to sql server with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Convert-xlsx-to-sql-server-with-spreadsheet-sdk.pdf

How to convert xlsx to sql server with spreadsheet sdk in C# with ByteScout Barcode Suite

Learn to code in C# to convert xlsx to sql server with spreadsheet sdk with this step-by-step tutorial

The code displayed below will guide you to install an C# app to convert xlsx to sql server with spreadsheet sdk. Want to convert xlsx to sql server with spreadsheet sdk in your C# app? ByteScout Barcode Suite is designed for it. ByteScout Barcode Suite is the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK.

Want to save time? You will save a lot of time on writing and testing code as you may just take the C# code from ByteScout Barcode Suite for convert xlsx to sql server with spreadsheet sdk below and use it in your application. Just copy and paste the code into your C# application’s code and follow the instructions. Enjoy writing a code with ready-to-use sample C# codes.

If you want to try other source code samples then the free trial version of ByteScout Barcode Suite is available for download from our website. Just try other source code samples for C#.

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 Bytescout.Spreadsheet;
using System.Data.SqlClient;

namespace ExportToSQLServer
{
	class Program
	{
		static void Main(string[] args)
		{
			try
			{
				// MODIFY THE CONNECTION STRING WITH YOUR CREDENTIALS!!!
				string connectionString = "Data Source=localhost;Initial Catalog=master;Integrated Security=true;";

				using (SqlConnection connection = new SqlConnection(connectionString))
				{
					connection.Open();

					// Drop test database if exists
					ExecuteQueryWithoutResult(connection,
											  "IF DB_ID ('XlsxTests') IS NOT NULL DROP DATABASE XlsxTests");
					// Create empty database
					ExecuteQueryWithoutResult(connection, "CREATE DATABASE XlsxTests");
					// Switch to created database
					ExecuteQueryWithoutResult(connection, "USE XlsxTests");
					// Create a table for XLSX data
					ExecuteQueryWithoutResult(connection,
											  "CREATE TABLE XlsxTest (Name VARCHAR(40), FullName VARCHAR(255))");

					// Load XLSX document
					using (Spreadsheet document = new Spreadsheet())
					{
						document.LoadFromFile("Hello_world.xlsx");
						Worksheet worksheet = document.Workbook.Worksheets[0];

						for (int row = 0; row <= worksheet.UsedRangeRowMax; row++)
						{
							String insertCommand = string.Format("INSERT XlsxTest VALUES('{0}','{1}')",
								worksheet.Cell(row, 0).Value, worksheet.Cell(row, 1).Value);
							ExecuteQueryWithoutResult(connection, insertCommand);
						}
					}
					
					// Check the data successfully exported
					using (SqlCommand command = new SqlCommand("SELECT * from XlsxTest", connection))
					{
						SqlDataReader reader = command.ExecuteReader();

						if (reader != null)
						{
							Console.WriteLine();
							Console.WriteLine("Exported XLSX data:");
							Console.WriteLine();

							while (reader.Read())
							{
								Console.WriteLine(String.Format("{0}  |  {1}", reader[0], reader[1]));
							}
						}
					}

					Console.WriteLine();
					Console.WriteLine("Press any key.");
					Console.ReadKey();
				}
			}
			catch(Exception ex)
			{
				Console.WriteLine("Error: " + ex.Message);
				Console.ReadKey();
			}
		}

		static void ExecuteQueryWithoutResult(SqlConnection connection, string query)
		{
			using (SqlCommand command = new SqlCommand(query, connection))
			{
				command.ExecuteNonQuery();
			}
		}
	}
}