Create a new spreadsheet and edit workbook in web application without Microsoft Office installed.

C#.NET Excel Document Generator SDK, is a mature and reliable third-party spreedsheet toolkit, designed particularly for manipulating and managing single-page and multi-page Excel document. This Excel Document SDK provides Visual C#.NET developers to create new Excel workbook from local file or byte stream in C#.NET class applications.

This guide page provides C# users with detailed explanations for generating new XLSX and XLS file.

// Create a new excel workbook
Workbook workBook = new Workbook();
// Create a new worksheet from workbook
Sheet sheet = workBook.CreateSheet();

// Create a new row at first line
Row row = sheet.CreateRow(0);
// Create a new cell at first column
Cell cell = row.CreateCell(0);

// Generate a new row at third line
Row rowX = sheet.CreateRow(3);
// Generate a new cell at fifth column
Cell cellX = rowX.CreateCell(5);

// Save and show the spreedsheet
if (File.Exists("sample.xlsx")) File.Delete("sample.xlsx");            

Notice - If you used the trial version of XsExcel SDK, can only edit, insert or get the first 300 row data!

More Excel tutorial