Spreadsheet SDK

ByteScout Spreadsheet SDK - C# - CSV to SQL Server 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 ('CsvTests') IS NOT NULL DROP DATABASE CsvTests"); // Create empty database ExecuteQueryWithoutResult(connection, "CREATE [...]

ByteScout Spreadsheet SDK - C# - Cell Alignment Program.cs   Click here to get your Free Trial version of the SDK

ByteScout Spreadsheet SDK - C# - Add Images Program.cs   Click here to get your Free Trial version of the SDK

ByteScout Spreadsheet SDK - C# - Add Image Program.cs   Click here to get your Free Trial version of the SDK

ByteScout Spreadsheet SDK - C# - Add Header and Footer Program.cs   Click here to get your Free Trial version of the SDK

ByteScout Spreadsheet SDK - C# - Add Chart XYScatter Program.cs using System; using System.Diagnostics; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Charts; namespace CSharp { class Program { static void Main(string[] args) { // Create new Spreadsheet object Spreadsheet spreadsheet = new Spreadsheet(); spreadsheet.RegistrationName = "demo"; spreadsheet.RegistrationKey = "demo"; // Add new worksheet Worksheet sheet = spreadsheet.Workbook.Worksheets.Add("Sample"); // Add few random numbers int length = 10; Random rnd = new Random(); for (int i = 0; i < length; [...]

ByteScout Spreadsheet SDK - C# - Add Chart Surface Program.cs using System; using System.Diagnostics; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Charts; namespace CSharp { class Program { static void Main(string[] args) { // Create new Spreadsheet object Spreadsheet spreadsheet = new Spreadsheet(); spreadsheet.RegistrationName = "demo"; spreadsheet.RegistrationKey = "demo"; // Add new worksheet Worksheet sheet = spreadsheet.Workbook.Worksheets.Add("Sample"); // Add a data for Surface chart int count = 10; double step = 2 * Math.PI / (count - 1); for [...]

ByteScout Spreadsheet SDK - C# - Add Chart Stock Program.cs using System.Diagnostics; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Charts; namespace CSharp { class Program { static void Main(string[] args) { // Create new Spreadsheet object Spreadsheet spreadsheet = new Spreadsheet(); spreadsheet.RegistrationName = "demo"; spreadsheet.RegistrationKey = "demo"; // Add new worksheet Worksheet sheet = spreadsheet.Workbook.Worksheets.Add("Sample"); // Add few random numbers for (int i = 1; i < 6; i++) { sheet[i, 0].Value = 39082 + i; sheet[i, 0].ValueDataTypeByNumberFormatString = [...]

ByteScout Spreadsheet SDK - C# - Add Chart Radar Program.cs using System; using System.Diagnostics; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Charts; namespace CSharp { class Program { static void Main(string[] args) { // Create new Spreadsheet object Spreadsheet spreadsheet = new Spreadsheet(); spreadsheet.RegistrationName = "demo"; spreadsheet.RegistrationKey = "demo"; // Add new worksheet Worksheet sheet = spreadsheet.Workbook.Worksheets.Add("Sample"); // Add few random numbers int length = 10; Random rnd = new Random(); for (int i = 0; i < length; [...]

ByteScout Spreadsheet SDK - C# - Add Chart Pie Program.cs using System; using System.Diagnostics; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Charts; namespace CSharp { class Program { static void Main(string[] args) { // Create new Spreadsheet object Spreadsheet spreadsheet = new Spreadsheet(); spreadsheet.RegistrationName = "demo"; spreadsheet.RegistrationKey = "demo"; // Add new worksheet Worksheet sheet = spreadsheet.Workbook.Worksheets.Add("Sample"); // Add few random numbers int length = 10; Random rnd = new Random(); for (int i = 0; i < length; [...]