Spreadsheet SDK

How to use different fonts for cells in spreadsheet Excel XLS documents generates with Bytescout Spreadsheet SDKThis source code sample demonstrates how to set different font names for cells in spreadsheet and Excel documents generated by Bytescout Spreadsheet for .NETDownload example source code: bytescoutxls_different_fonts_for_cells.zip (8 KB)Sample spreadsheet (XLS document) 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 [...]

How to generate Excel document report with data table using Bytescout Spreadsheet SDKThis source code sample generates report with table and saves into .XLS document using Bytescout Spreadsheet SDKDownload example source code: bytescoutxls_create_report_with_table_in_xls.zip (5 KB)using System; using System.Collections.Generic; using System.Drawing; using System.Text; using Bytescout.Spreadsheet; namespace Create_a_report_with_table_in_XLS { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new Spreadsheet(); // Add new worksheet Worksheet worksheet = document.Workbook.Worksheets.Add("SimpleReport"); // Set Values [...]

How to convert Excel document into text (.txt) file using Bytescout Spreadsheet SDKThis source code sample shows how to convert excel XLS document into text file (.txt) using Bytescout Spreadsheet SDK with C# in .NETDownload example source code: bytescoutxls_converting_xls_to_txt.zip (8 KB) using System; using System.Collections.Generic; using System.IO; using System.Text; using Bytescout.Spreadsheet;namespace Converting_XLS_to_TXT { class Program { static void Main(string[] args) { // Create new Spreadsheet from SimpleReport.xls file Spreadsheet document = new Spreadsheet("SimpleReport.xls");// delete output [...]

How to convert Excel document into CSV (comma separated data) file using Bytescout Spreadsheet SDKThis source code sample shows how to convert excel XLS document into comma-separated data file (.CSV) using Bytescout Spreadsheet SDK with C# in .NETDownload example source code: bytescoutxls_converting_excel_to_csv.zip (8 KB)using System; using System.Collections.Generic; using System.IO; using System.Text; using Bytescout.Spreadsheet; namespace Converting_XLS_to_TXT { class Program { static void Main(string[] args) { // Create new Spreadsheet from SimpleReport.xls file Spreadsheet document = new [...]

How to convert Excel document into XML format using Bytescout Spreadsheet SDKThis source code sample converts existing Excel document report into XML document using Bytescout Spreadsheet SDKDownload example source code: bytescoutxls_converting_excel_to_xml.zip (5 KB)using System; using System.Collections.Generic; using System.Text; using System.Runtime.InteropServices; using System.IO; using Bytescout.Spreadsheet; namespace SaveAsXML { class Program { static void Main(string[] args) { Spreadsheet document = new Spreadsheet("SimpleReport.xls"); document.Workbook.Worksheets[0].SaveAsXML("SimpleReport.xml"); document.Close(); } } }Download example source code: bytescoutxls_converting_excel_to_xml.zip (5 KB)

How to convert Excel document into HTML page using Bytescout Spreadsheet SDKThis source code sample converts existing Excel document report into HTML page using Bytescout Spreadsheet SDKDownload example source code: bytescoutxls_export_xls_to_html.zip (5 KB)Source Excel document:using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet; namespace ExportToHTML { class Program { static void Main(string[] args) { // Open Spreadsheet Spreadsheet document = new Spreadsheet("SimpleReport.xls"); // Get Worksheet Worksheet worksheet = document.Workbook.Worksheets[0]; // Export to HTML worksheet.SaveAsHTML("SimpleReport.htm"); // Close [...]

How to change data in an existing Excel (XLS) document using Bytescout Spreadsheet SDKThis source code sample demonstrates how to use Bytescout Spreadsheet SDK to change data in an existing Excel (.XLS) document and save changed file as a new one.Download example source code: bytescoutxls_changing_data_in_existing_xls.zip (8 KB)Source document screenshot:Modified document screenshot (see Homer's Full Name changed)using System; using System.Collections.Generic; using System.Text; using Bytescout.Spreadsheet; namespace Changing_data_in_existing_XLS { class Program { static void Main(string[] args) { // [...]