Spreadsheet SDK

ByteScout Spreadsheet SDK - C# - Special Cells Program.cs using System; using System.Collections.Generic; using System.Text; using System.Diagnostics; using System.IO; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Charts; using Bytescout.Spreadsheet.Constants; using System.Drawing; namespace CSharp { class Program { static void Main(string[] args) { try { // create new Spreadsheet object Spreadsheet spreadsheet = new Spreadsheet(); // add new worksheet Worksheet sheet = spreadsheet.Workbook.Worksheets.Add("Sample"); // add a constants for (int i = 1; i < 8; i++) { sheet[i, 1].Value = [...]

ByteScout Spreadsheet SDK - C# - ShrinkToFit for Cells Program.cs   Click here to get your Free Trial version of the SDK

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

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

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

ByteScout Spreadsheet SDK - C# - Number Format In Cells Program.cs using System; using System.Collections.Generic; using System.Text; using System.Diagnostics; using Bytescout.Spreadsheet; using System.IO; namespace HelloWorld { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new Spreadsheet(); // Get worksheet by name Worksheet worksheet = document.Workbook.Worksheets.Add("Sample"); // Set header worksheet.Cell(0, 0).Value = "Value (Number)"; worksheet.Cell(0, 1).Value = "Formatting String"; // Set variables double plan = 3000; double result = [...]

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

ByteScout Spreadsheet SDK - C# - Date Formatting in Cells Program.cs using System; using System.Collections.Generic; using System.Text; using System.Diagnostics; using Bytescout.Spreadsheet; using System.IO; namespace HelloWorld { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new Spreadsheet(); // Get worksheet by name Worksheet worksheet = document.Workbook.Worksheets.Add("Sample"); // Set captions worksheet.Cell(0, 0).Value = "#"; worksheet.Cell(0, 1).Value = "Date"; for (int i = 1; i < 8; i++) { // Set [...]

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

ByteScout Spreadsheet SDK - C# - CSV To XLS Program.cs   Click here to get your Free Trial version of the SDK