Spreadsheet SDK

Add the functionality to read and write data from/to Excel XLS, XLSX, CSV documents to your desktop and web applications Benefits Why ByteScout? Features Solutions Gallery Spreadsheet SDK key benefits Excel is not required (the library uses its own custom engine to efficiently read, write and calculate spreadsheets. In addition Microsoft does not currently recommend, and does not support automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, [...]

How to convert XLS to SQL Server data using Bytescout Spreadsheet SDK for .NETThese samples shows how to export XLS to SQL Server data in VB and C# using Bytescout Spreadsheet SDK. You can also check out How to convert XLS to SQL Server data via CSV BULK INSERT tutorial.Input XLS file:Output - XLS data exported to SQL Server:Visual Basic .NET Visual C# using System; using System.IO; using Bytescout.Spreadsheet; using System.Data.SqlClient; namespace ExportToSQLServer { class [...]

How to convert TXT file to SQL Server data using Bytescout Spreadsheet SDKThese source code samples shows how to import text to SQL Server data from TXT file in VB or C# using Bytescout Spreadsheet component for .NET.Input TXT file:Output - TXT data exported to SQL Server:Visual Basic .NET Visual C# using System; using Bytescout.Spreadsheet; using System.Data.SqlClient; namespace ExportToSQLServer { class Program { static void Main(string[] args) { try { // MODIFY THE CONNECTION STRING [...]

How to convert CSV to SQL Server data using Bytescout Spreadsheet SDK for .NETThese source code samples export CSV to SQL Server data using Bytescout Spreadsheet library for C# and VB developers.Input CSV file:Output - CSV data exported to SQL Server:Visual Basic .NET Visual C# 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 = [...]

This command line sample shows how to convert all files from Input Files folder to files of XLS format in Output Files folder. See the full list of supported command line switches for Bytescout.Spreadsheet.Console.exe

Convert spreadsheet files from command line using Spreadsheet SDK Console version! Console version (Bytescout.Spreadsheet.Console.exe) is included with the latest versions of Bytescout Spreadsheet SDK to let you convert spreadsheet files directly from command line or .bat command files. Bytescout Spreadsheet SDK license allows you to distibute Bytescout.Spreadsheet.Console.exe and Bytescout.Spreadsheet.dll along with your end-user product/application royalty-free. You can find copies of Bytescout.Spreadsheet.Console.exe and Bytescout.Spreadsheet.dll for redistribution in /Redistributable/net2.00/ folder (in full version only). See the full [...]

How to write a formula into a cell in the Excel spreadsheet generated by Bytescout Spreadsheet SDK This source code sample demonstrates how to write formula into a cell in a new excel spreadsheet made with Bytescout Spreadsheet SDK for .NETDownload example source code: bytescoutxls_write_formula_into_cell.zip (2 KB)using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet; using System.Diagnostics;namespace HelloWorld { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new Spreadsheet();// [...]

How to validate data in existing Excel XLS spreadsheet and mark incorrect values with color using Bytescout Spreadsheet SDKThis source code sample demonstrates how to open existing Excel document (XLS) and check cell values if cells contains correct values or not. Then mark incorrect values with red color and save spreadsheet fileDownload example source code: bytescoutxls_validate_cells_mark_wrong_with_color.zip (8 KB)Validated document screenshot (incorrect value is now marked with red color background):using System; using System.Collections.Generic; using System.Text; using [...]

How to load and check if spreadsheet contains correct dates for persons (if person is a teenager and so his/here current age is from 10 to 19) and mark incorrect birth dates with red color using Bytescout Spreadsheet SDK for .NETThis source code sample "checking if person is teenager or not" demonstrates how to use Bytescout Spreadsheet SDK to open existing Excel (.XLS) document and verify birth dates of persons. If current age of a [...]

How to enable Shrink To Fit property for cells so Excel will automatically fit text for the cell according to changed cell width in spreadsheet XLS document made with Bytescout Spreadsheet SDKThis source code sample demonstrates how to use Shrink To Fit property for cell in spreadsheet generated with Bytescout Spreadsheet SDK so generated XLS document will automatically fit text in the cell when opened in Excel 2003 or 2007Download example source code: bytescoutxls_using_shrink_to_fit_for_cells.zip (10 [...]