Formulas

This sample demonstrates how to use formulas in your spreadsheets.

HelloWorld

This sample shows how to create a workbook.

Styles

This sample demonstrates how to use styles, such as fonts, borders, background colors and so on, in spreadsheets.

AutoSizeColumns

The sample loops through all cells measuring their contents, then sets the column widths based on the widest entry. This sample takes into account the cell contents, format and font. It does not account for content wrapping or merging. This sample uses the C1XLBook component.

CombineSheets

This sample scans all the .xlsx files in a folder, clones the first sheet, renames it with the file name, and adds the cloned sheets to a master workbook. It then saves the combined workbook into a file and opens that. This sample uses the C1XLBook component.

ExcelDemos

This sample shows three different example spreadsheets: one creates a simple Hello World spreadsheet, the second creates a spreadsheet with formulas, and the third creates a spreadsheet using styles, such as font, borders, background colors, and so on.

ExcelFormulas

This sample demonstrates how to use formulas in your spreadsheets.

HelloWorld

This sample actually does more than save a "Hello World" document. It shows how to create workbooks, assign names to the worksheets, create styles and assign them to cells, assign content to cells, and save workbooks. This sample uses the C1XLBook component.

PrintSettings

This sample has a Load button that opens an existing XLS file and shows the print settings for the first sheet. You can modify the print settings, then click the Save button to save a new file (in the c:\temp folder). The new file is then displayed in Excel . This sample uses the C1XLBook component.