Spreadsheet SDK
Create spreadsheets and CSV, Read spreadsheets and CSV, Calculate cells with formula, supports XLS and XLSX Spreadsheets with no Excel or other apps required. Work with Spreadsheets from .NET, ASP.NET code, use as ActiveX component or even from command line.
Go To Samples
SDK Reference
- About Bytescout Spreadsheet SDK
- Getting Started
- Spreadsheet SDK API Reference
- Bytescout.Spreadsheet
- Spreadsheet Class
- Spreadsheet Methods
- SpreadsheetComponent Class
- SpreadsheetProtectionXLSSheetLimitationsException Class
- SpreadsheetWebControl Class
- Worksheet Class
- Spreadsheet Class
- Bytescout.Spreadsheet.BaseClasses
- Bytescout.Spreadsheet.Charts
- Bytescout.Spreadsheet.COM
- ISpreadsheet Interface
- ISpreadsheet Methods
- IWorksheet Interface
- ISpreadsheet Interface
- Bytescout.Spreadsheet.Generic
- Bytescout.Spreadsheet.MSODrawing
- Bytescout.Spreadsheet
- Supported formulas
- ActiveX Notice
- Console version (command line) options
- Installation Tasks (.NET)
- Installation Tasks (ActiveX for VB6 and other)
- History
- License Agreement
- How To Buy
Samples
- ASP Classic - Generate XLS Spreadsheet
- ASP.NET C# - Display XLS as HTML
- ASP.NET VB.NET - Display XLS as HTML
- C# - Add Area Chart
- C# - Add Background Image
- C# - Add Bar Chart
- C# - Add Bubble Chart
- C# - Add Column Chart
- C# - Add Columns Into Existing Spreadsheet
- C# - Add Combination Chart
- C# - Add Doughnut Chart
- C# - Add Header and Footer for Spreadsheet
- C# - Add Image Into Existing Spreadsheet
- C# - Add Image to Spreadsheet
- C# - Add Images Advanced
- C# - Add Images to Spreadsheet
- C# - Add Line Chart
- C# - Add Pie Chart
- C# - Add Radar Chart
- C# - Add Rows Into Existing Spreadsheet
- C# - Add Stock Chart
- C# - Add Surface Chart
- C# - Add XYScatter Chart
- C# - Calculate Auto Update On Cell Change
- C# - Calculate Formula In Cell
- C# - Calculate XIRR Function
- C# - Calculations and Spreadsheet as Database
- C# - Change Cell Width and Height
- C# - Change Column Width and Row Height
- C# - Change Data in Existing Spreadsheet
- C# - Change Document Properties
- C# - Convert CSV To XLS
- C# - Convert CSV to SQL Server
- C# - Convert ODS to SQL Server
- C# - Convert TXT to SQL Server
- C# - Convert Template To XLS
- C# - Convert XLS to CSV
- C# - Convert XLS to SQL Server
- C# - Convert XLS to SQL Server (via CSV BULK INSERT)
- C# - Convert XLS to TXT
- C# - Convert XLS to XLSX
- C# - Convert XLS to XML
- C# - Convert XLS to XML and XML to XLS
- C# - Convert XLSX to SQL Server
- C# - Convert XML to XLS
- C# - Copy Range
- C# - Copy Worksheet
- C# - Copy Worksheet Data To Clipboard
- C# - Copy Worksheet to Another Workbook
- C# - CopyPaste Columns
- C# - CopyPaste Rows
- C# - Create Hello World Spreadsheet
- C# - Create Worksheets
- C# - Create XLSX
- C# - Download and Process file
- C# - Export To 2D Array
- C# - Export To DataTable
- C# - Export To Dataset
- C# - Export To HTML
- C# - Export To JSON
- C# - Export To Jagged Array
- C# - Export To List
- C# - Export To PDF
- C# - Export to WinForms DataGrid
- C# - Font Style In Cell
- C# - Fonts Available For Cells
- C# - Freeze Rows And Columns
- C# - Generate Invoice
- C# - Get Cell Color
- C# - Hidden Formula
- C# - Hidden Rows And Columns
- C# - Import From 2D Array
- C# - Import From Data Table
- C# - Import From Dataset
- C# - Import From JSON
- C# - Import From Jagged Array
- C# - Import From List
- C# - Import From WinForms DataGrid
- C# - Insert Page Break
- C# - Line Styles In Cells
- C# - Merge Cells
- C# - Merge Two Documents
- C# - Override Culture and Date Format Settings
- C# - Read CSV File
- C# - Read Cell Color
- C# - Read Date From Cell
- C# - Read Document Properties
- C# - Read Formula From Cell
- C# - Read Merged Cells
- C# - Read Number Format In Cell
- C# - Read ODS (Open Office Calc) Files
- C# - Read TXT (Tab Delimited)
- C# - Read XLSX (Office 2007) Files
- C# - Read XML Spreadsheet (SpreadsheetML format)
- C# - Remove Columns from Existing Spreadsheet
- C# - Remove Rows from Existing Spreadsheet
- C# - Rename Worksheet
- C# - Search Text
- C# - Search and Replace Text
- C# - Select Active Worksheet
- C# - Set Cell Alignment
- C# - Set Cell Formula
- C# - Set Date Formatting in Cells
- C# - Set Number Format In Cells
- C# - Set Rich Text Formatting in Cell
- C# - Set ShrinkToFit for Cells
- C# - Sort Range
- C# - Swap Cells and Their Values
- C# - Swap Worksheets
- C# - Unmerge Cells
- C# - Use Custom Functions
- C# - Use Rich Formatting to Create Report
- C# - Use Special Cells
- C# - Use Unicode Text
- C# - Validate Cell if Value is in Range
- C# - Validate Cells with Dates
- C# - Validate Data in Cell and Mark Wrong With Color
- C# - View Spreadsheet
- C# - Workbook AutoCalculation
- C++ (managed) - Create Simple Spreadsheet
- C++ (unmanaged) - Create Simple Spreasdsheet
- Console - Convert in Batch from XLS to CSV
- Console - Convert in Batch to XLS
- Delphi - Add Image to Spreadsheet
- Delphi - CopyPaste Rows
- Delphi - Validate Cells with Dates
- JavaScript - Create Spreadsheet
- PHP - Create Spreadsheet
- VB.NET - Add Area Chart
- VB.NET - Add Background Image
- VB.NET - Add Bar Chart
- VB.NET - Add Bubble Chart
- VB.NET - Add Column Chart
- VB.NET - Add Columns Into Existing Spreadsheet
- VB.NET - Add Combination Chart
- VB.NET - Add Doughnut Chart
- VB.NET - Add Header and Footer
- VB.NET - Add Images
- VB.NET - Add Images Advanced
- VB.NET - Add Line Chart
- VB.NET - Add Pie Chart
- VB.NET - Add Radar Chart
- VB.NET - Add Rows Into Existing Spreadsheet
- VB.NET - Add Stock Chart
- VB.NET - Add Surface Chart
- VB.NET - Add XYScatter Chart
- VB.NET - CSV to SQL Server
- VB.NET - CSV to XLS
- VB.NET - Calculate Formula In Cell
- VB.NET - Calculate XIRR Function
- VB.NET - Calculations and Spreadsheet as Database
- VB.NET - Change Cell Width and Height
- VB.NET - Change Column Width and Row Height
- VB.NET - Change Data in Existing Spreadsheet
- VB.NET - Change Document Properties
- VB.NET - Convert ODS to SQL Server
- VB.NET - Convert TXT to SQL Server
- VB.NET - Convert Template To XLS
- VB.NET - Convert XLS to CSV
- VB.NET - Convert XLS to SQL Server
- VB.NET - Convert XLS to SQL Server (via CSV BULK INSERT)
- VB.NET - Convert XLS to TXT
- VB.NET - Convert XLS to XLSX
- VB.NET - Convert XLS to XML
- VB.NET - Convert XLS to XML and XML to XLS
- VB.NET - Convert XLSX to SQL Server
- VB.NET - Convert XML to XLS
- VB.NET - Copy Range
- VB.NET - Copy Worksheet
- VB.NET - Copy Worksheet Data To Clipboard
- VB.NET - CopyPaste Columns
- VB.NET - CopyPaste Rows
- VB.NET - Create Simple Hello World Spreadsheet
- VB.NET - Create Worksheets
- VB.NET - Create XLSX
- VB.NET - Download and Process file
- VB.NET - Export To 2D Array
- VB.NET - Export To DataSet
- VB.NET - Export To DataTable
- VB.NET - Export To HTML
- VB.NET - Export To JSON
- VB.NET - Export To Jagged Array
- VB.NET - Export To List
- VB.NET - Export To PDF
- VB.NET - Export to WinForms DataGrid
- VB.NET - Font Style In Cell
- VB.NET - Fonts Available For Cells
- VB.NET - Freeze Rows And Columns
- VB.NET - Generate Invoice
- VB.NET - Get Cell Color
- VB.NET - Import From 2D Array
- VB.NET - Import From DataSet
- VB.NET - Import From DataTable
- VB.NET - Import From JSON
- VB.NET - Import From Jagged Array
- VB.NET - Import From List
- VB.NET - Import From WinForms DataGrid
- VB.NET - Insert Page Break
- VB.NET - Line Styles In Cells
- VB.NET - Merge Cells
- VB.NET - Merge Two Documents
- VB.NET - Number Format In Cells
- VB.NET - Override Culture and Date Format Settings
- VB.NET - Read CSV File
- VB.NET - Read Cell Color
- VB.NET - Read Date From Cell
- VB.NET - Read Document Properties
- VB.NET - Read Formula From Cell
- VB.NET - Read Merged Cells
- VB.NET - Read Number Format In Cell
- VB.NET - Read ODS (Open Office Calc) Files
- VB.NET - Read XLSX (Office 2007) Files
- VB.NET - Read XML Spreadsheet (SpreadsheetML format)
- VB.NET - Remove Columns from Existing Spreadsheet
- VB.NET - Remove Rows from Existing Spreadsheet
- VB.NET - Rename Worksheet
- VB.NET - Rich Text Formatting in Cell
- VB.NET - Search Text
- VB.NET - Select Active Worksheet
- VB.NET - Set Cell Alignment
- VB.NET - Set Cell Formula
- VB.NET - Set Custom Functions
- VB.NET - Set Date Formatting in Cells
- VB.NET - Set Hidden Formula
- VB.NET - Set Hidden Rows And Columns
- VB.NET - Set ShrinkToFit for Cells
- VB.NET - Swap Cells and Their Values
- VB.NET - Swap Worksheets
- VB.NET - Unmerge Cells
- VB.NET - Use Rich Formatting to Create Report
- VB.NET - Use Unicode Text
- VB.NET - Validate Cell if Value is in Range
- VB.NET - Validate Cells with Dates
- VB.NET - Validate Data in Cell and Mark Wrong With Color
- VB.NET - View Spreadsheet
- VB.NET - Workbook AutoCalculation
- VB6 - Create Spreadsheet
- VBScript - Add Images to Spreadsheet
- VBScript - Change Cell Background Color
- VBScript - Change Column Height
- VBScript - Change Row Height
- VBScript - Convert CSV to XLS
- VBScript - Copy Data Between Spreadsheets
- VBScript - Create Barcode from Excel
- VBScript - Create Simple Spreadsheet
- VBScript - Export To HTML
- VBScript - Merge Cells and Set Alignment
- VBScript - Save As PDF
- VBScript - Use Rich Text Formatting