public static void InsertDataToExcelFile(SpreadsheetDocument sheet, DataTable table) { sheet.AddWorkbookPart(); sheet.WorkbookPart.Workbook = new Workbook(); sheet.WorkbookPart.Workbook.AppendChild(new Sheets()); WorksheetPart newWorksheetPart = sheet.WorkbookPart.AddNewPart<WorksheetPart>(); newWorksheetPart.Worksheet = new Worksheet(); uint worksheetNumber = 1; SheetData sheetData = newWorksheetPart.Worksheet.AppendChild(new SheetData()); int numberOfColumns = table.Columns.Count; bool[] IsNumericColumn = new bool[numberOfColumns]; Row newRow = sheetData.AppendChild(new Row()); Cell newCell; foreach (DataRow dr in table.Rows) { newRow = sheetData.AppendChild(new Row()); for (int colInx = 0; colInx < numberOfColumns; colInx++) { string cellValue = dr.ItemArray[colInx].ToString(); if (IsNumericColumn[colInx] && !string.IsNullOrEmpty(cellValue)) { newCell = CreateNumericCell(cellValue); } else { newCell = CreateTextCell(cellValue); } newRow.AppendChild(newCell); } } newWorksheetPart.Worksheet.Save(); sheet.WorkbookPart.Workbook.GetFirstChild<Sheets>().AppendChild(new Sheet() { Id = sheet.WorkbookPart.GetIdOfPart(newWorksheetPart), SheetId = worksheetNumber++, Name = table.TableName }); sheet.WorkbookPart.Workbook.Save(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)