Spreadsheet SDK

How to use cell formatting (set font color, style, name) for new XLS (Excel) documents generated using Bytescout Spreadsheet libThis source code demonstrates use of rich formatting for cells in new Excel spreadsheets generated with Bytescout Spreadsheet SDK for .NETDownload example source code: bytescoutxls_using_rich_formatting_to_create_xls_report.zip (5 KB)using System; using System.Collections.Generic; using System.Drawing; using System.Text; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Constants; namespace Using_rich_formatting_to_create_a_XLS_report { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = [...]

How to use cell format for numbers while writing spreadsheet document using Bytescout Spreadsheet SDKThis source code sample demonstrates how to use different number formatting for cells in spreadsheet generated with Bytescout Spreadsheet SDKDownload example source code: bytescoutxls_number_formatting_for_cells.zip (8 KB)Generated spreadsheet screenshot:using System; using System.Collections.Generic; using System.Text; using System.Diagnostics; using Bytescout.Spreadsheet; namespace HelloWorld { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new Spreadsheet();// Get worksheet by name [...]

How to format cell to display formatted date time value in XLS spreadsheet generated/modified with using Bytescout Spreadsheet SDKThis source code sample demonstrates how to format date value in cell in spreadsheet using Bytescout Spreadsheet for .NET applicationsDownload example source code: bytescoutxls_date_formatting_for_cells.zip (8 KB)Output spreadsheet (XLS) screenshot:using System; using System.Collections.Generic; using System.Text; using System.Diagnostics; using Bytescout.Spreadsheet;namespace HelloWorld { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new Spreadsheet();// [...]

How to set cell alignment in excel XLS document made with Bytescout Spreadsheet SDK for .NET in C#This source code sample demonstrates how to set and use different alignments (left, right, center) for a cell in xls documents generated with with Bytescout Spreadsheet SDK for .NETDownload example source code: bytescoutxls_write_formula_into_cell.zip (1 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 [...]

How to set active worksheet in the generated spreadsheet (this worksheet will be selected by default when spreadsheet is opened)This source code sample demonstrates how to use Bytescout Spreadsheet SDK to select default worksheet in spreadsheet (XLS or other format) documentDownload example source code: bytescoutxls_select_active_worksheet.zip (4 KB)Saved XLS document screenshot (Worksheet2 tab is selected by default)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[] [...]

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 rename a worksheet in existing spreadsheet (Excel XLS) using Bytescout Spreadsheet SDKThis source code sample demonstrates how to rename workshett in existing XLS document file using Bytescout Spreadsheet SDK for .NETDownload example source code: bytescoutxls_rename_worksheet.zip (8 KB)Screenshot of the spreadsheet with renamed worksheet (first worksheet was renamed from "Sheet1" into "Collected Data Sheet"):using System; using System.Collections.Generic; using System.Text; using System.Diagnostics; using Bytescout.Spreadsheet;namespace HelloWorld { class Program { static void Main(string[] args) { // [...]

How to remove rows from existing XLS (Excel) document using Bytescout Spreadsheet SDKThis source code describes how to remove rows from existing Excel (XLS) document and save changed document as new document file using Bytescout Spreadsheet libSource Excel document:Modified Excel document (row with Maggie name and full name was removed):using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet; namespace Removing_rows_from_existing_XLS { class Program { static void Main(string[] args) { // Open Spreadsheet Spreadsheet document = new [...]

How to remove columns from existing Excel (.XLS) document using Bytescout Spreadsheet SDKThis source code sample removes columns from existing XLS document and saves modified document into new document file using Bytescout Spreadsheet libDownload example source code: bytescoutxls_removing_columns_from_existing_xls.zip (5 KB)using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet; namespace Removing_columns_from_existing_XLS { class Program { static void Main(string[] args) { // Open Spreadsheet Spreadsheet document = new Spreadsheet("AdvancedReport.xls"); // Get Worksheet Worksheet worksheet = document.Workbook.Worksheets[0]; // Remove [...]

How to read data from XSLX document (MS Office 2007 spreadsheet) using Bytescout Spreadsheet SDK for .NET This source code sample demonstrates how to read cells from existing .XLSX Excel 2007 spreadsheet file using Bytescout Spreadsheet lib for .NET Source Excel 2007 XLSX 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 Spreadsheet Spreadsheet document = new Spreadsheet(); // load [...]