Spreadsheet SDK

How to read cell values from Open Office Calc spreadsheet document (ODS file extension) using Bytescout Spreadsheet SDKThis sample provides source code example demonstrating how to use use Bytescout Spreadsheet SDK to read cell values from Open Office Calc spreadsheet document (.ODS)Download example source code: bytescoutxls_read_ods_open_office_calc_spreadsheet.zip (8 KB)Source ODS Open Office Calc spreadsheet document screenshot:using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet;namespace HelloWorld { class Program { static void Main(string[] args) { // Create new [...]

How to use Bytescout Spreadsheet to read date (datetime) values cells in existing XLS spreadsheet documentThis source code sample demonstrates how to read datetime date values from cells in existing Excel spreadsheet (XLS) file with Bytescout Spreadsheet SDK for .NETDownload example source code: bytescoutxls_read_date_time_from_cell.zip (8 KB)Screenshot of console output while reading datetime values from cells from existing XLS spreadsheet:using System; using System.Collections.Generic; using System.Text; using System.Diagnostics; using Bytescout.Spreadsheet;namespace HelloWorld { class Program { static void [...]

How to read data from existing .XLS (Excel) document into dataset in C# using Bytescout Spreadsheet SDKThis source code sample demonstrates how to read data from existing Excel and write this data into dataset using Bytescout Spreadsheet SDK in C#Download example source code: bytescoutxls_reading_data_from_xls_into_dataset.zip (8 KB)using System; using System.Collections.Generic; using System.Data; using System.Text; using Bytescout.Spreadsheet; namespace Reading_data_from_XLS_into_dataset { class Program { static void Main(string[] args) { // Open Spreadsheet Spreadsheet document = new Spreadsheet("AdvancedReport.xls"); DataSet [...]

How to add rows to an existing Excel (XLS) document using Bytescout Spreadsheet SDKThis source code sample teaching how to add rows with data to an existing XLS document using Bytescout Spreadsheet libDownload example source code: bytescoutxls_adding_rows_into_existing_xls.zip (5 KB)Source Excel document:New row was inserted and document saved as new document file:using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet; namespace Adding_rows_to_existing_XLS { class Program { static void Main(string[] args) { // Open Spreadsheet Spreadsheet document = [...]

Adding new columns with data to an existing Excel document using Bytescout Spreadsheet SDKThis short sample demonstrates how to take an existing document and add new columns with data to this document and then save as new documentDownload example source code: bytescoutxls_adding_columns_into_existing_xls.zip (5 KB)Source Excel document:Modified document (new column was added):using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet; namespace Adding_columns_into_existing_XLS { class Program { static void Main(string[] args) { // Open Spreadsheet Spreadsheet document = [...]

Generating XLS documents from ASP.NET code using Bytescout.XLS for .NETThis sample source code is designed to show how to generate Excel (XLS) document from ASP.NET using Bytescout.XLS library and then write produced document into browser using Response object (implementing on-the-fly output)Download example source code: bytescoutxls_asp_net.zip (2 KB)To run Bytescout.XLS on a ASP.NET project just do the following:1) Run Visual Studio 2005 2) Create new "Web-Site" project using Project Wizard 3) Click "Website" menu and then [...]

Writing data to Excel XLS file in Visual Basic.NET using Bytescout Spreadsheet SDK for .NET This example contains source code example for Visual Basic.NET and Bytescout Spreadsheet SDK. Writing "Hello, World!" simple XLS document in VB.NET. Dim document As New Spreadsheet() Dim worksheet As Worksheet = document.Workbook.Worksheets.Add("HelloWorld") worksheet.Cell(0, 0).Value = "Hello, World!" document.SaveAs("HelloWorld.xls") Download example source code: bytescoutxls_visual_basic_net.zip (9 KB)

Writing XLS document from C# application using Bytescout Spreadsheet SDK for .NETThis example contains source code example for Visual C# demonstrating how to write a simple XLS document from C# using Bytescout Spreadsheet libDownload example source code: bytescoutxls_c_sharp.zip (4 KB)// Create new Spreadsheet Spreadsheet document = new Spreadsheet();// Add new worksheet Worksheet worksheet = document.Workbook.Worksheets.Add("HelloWorld");// Set cell value worksheet.Cell(0, 0).Value = "Hello, World!";// Save document document.SaveAs("HelloWorld.xls");Download example source code: bytescoutxls_c_sharp.zip (4 KB)

Generating XLS documents from ASP.NET code using Bytescout Spreadsheet for .NETThis sample source code is designed to show how to generate Excel (XLS) document from ASP.NET using Bytescout Spreadsheet SDK and then write produced document into browser using Response object (implementing on-the-fly output)Download example source code: bytescoutxls_asp_net.zip (2 KB)To run Bytescout Spreadsheet on a ASP.NET project just do the following:1) Run Visual Studio 2005 2) Create new "Web-Site" project using Project Wizard 3) Click "Website" [...]

How to use different line styles for cells in spreadsheet document (XLS) generated with Bytescout Spreadsheet for .NETThis source code sample demonstrates how to use different line styles for cell formatting while using Bytescout Spreadsheet SDKDownload example source code: bytescoutxls_different_line_type_styles_for_cells.zip (8 KB)Output spreadsheet XLS document screenshot:using System; using System.Collections.Generic; using System.Text; using System.Diagnostics; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Constants;namespace HelloWorld { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new [...]