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); cell.SetValue(123); // Generate a new row at third line Row rowX = sheet.CreateRow(3); // Generate a new cell at fifth column Cell cellX = rowX.CreateCell(5); cellX.SetValue("XsExcel"); // Save and show the spreedsheet if (File.Exists("sample.xlsx")) File.Delete("sample.xlsx"); workBook.Save("sample.xlsx"); Process.Start("sample.xlsx");
Notice - If you used the trial version of XsExcel SDK, can only edit, insert or get the first 300 row data!