Adding Content to a Workbook

To create a new workbook and add values to the first ten cells, complete the following steps:

Add a reference to C1.WPF.Excel.dll or C1.Silverlight.Excel.dll and create a C1XLBook.

C#	Copy Code
// Create a new workbook to be saved C1XLBook book = new C1XLBook();

Add values to the first ten cells.

C#	Copy Code
// write content for the first ten cells XLSheet sheet = book.Sheets[0]; for (int i = 0; i <= 9; i++) { sheet[i, 0].Value = i + 1; }

Save and open the workbook. The code looks like the following.

C#	Copy Code
// Save and open the file book.Save(@"C:\test.xls"); System.Diagnostics.Process.Start(@"C:\test.xls");