Spreadsheet SDK

These C# and Visual Basic .NET code samples show how to export data from Excel document to list and display the result array with Bytescout Spreadsheet SDK. C#

This example will help you in exporting data from XLS spreadsheet to jagged array in C# and Visual Basic .NET using Bytescout Spreadsheet SDK. C#

This source code sample will show how to export data from XLS spreadsheet to dataset in C# and Visual Basic .NET using Bytescout Spreadsheet SDK. C#

This example demonstrates how to get data from XLS spreadsheet and export them to data table in C# and Visual Basic .NET using Bytescout Spreadsheet SDK. C#

This sample shows how to get data from XLS spreadsheet and export them to two-dimensional (2D) arrays in C# and Visual Basic .NET using Bytescout Spreadsheet SDK. C#

Your download will begin in a moment. If it doesn't, click here to try again. Still having trouble? Use instant download links below: direct download (EXE installer)   direct download (ZIP)

How to read data from CSV files using Bytescout Spreadsheet SDK in .NET applicationThe source code sample shows how to read data from CSV (comma separated values file) using Bytescout Spreadsheet SDK.Download example source code: bytescoutxls_read_csv.zip (4 KB)Source CSV file:using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet;namespace HelloWorld { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new Spreadsheet("Hello_world.csv");// Get first worksheet Worksheet worksheet = document.Workbook.Worksheets[0];// Read cell [...]

How to validate person ages in existing XLS spreadsheet document and mark persons with non-teenager age with red colorThis source code sample demonstrates how to use Bytescout Spreadsheet SDK to open existing Excel (XLS) document and check the column with person ages: check if age is accepted (age should be teenager age from 10 to 19) and if age is not a teeneger age (less than 10 or greater than 19) so this person should [...]

Add new worksheets into Excel document, access existing worksheets and their data using Bytescout Spreadsheet SDKThis sample provides source code example to show how to add worksheets in XLS Excel document, how to access existing worksheet using worksheet name, how to access cells in worksheet using Bytescout Spreadsheet SDK for .NETDownload example source code: bytescoutxls_working_with_worksheets.zip (5 KB)using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet; namespace Worksheets { class Program { static void Main(string[] args) { [...]

How to convert XLS to SQL Server data via CSV BULK INSERT using Bytescout Spreadsheet SDK for .NETThese samples shows how to export XLS to SQL Server data via CSV BULK INSERT method in VB and C#. You can also check out How to convert XLS to SQL Server data tutorial.Input XLS file:Output - CSV data exported to SQL Server:Visual Basic .NET Visual C#