Workbook book = new Workbook();book.LoadFromFile("sample.xlsx");book.SaveToFile("result.xls", ExcelVersion.Version97to2003);
appalanaidu
//Read the xlsx format file ExcelPackage package = new ExcelPackage(new FileInfo(@"c:\temp\New Microsoft Excel Worksheet.xlsx")); DataTable tbl = ToDataTable(package); using (ExcelPackage pck = new ExcelPackage()) { //Create the worksheet ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Demo"); //Load the datatable into the sheet, starting from cell A1. Print the column names on row 1 ws.Cells["A1"].LoadFromDataTable(tbl, true); //Write it back to the client as 2003 format pck.SaveAs(new System.IO.FileInfo(@"c:\temp\Demo.xls")); }
public DataTable ToDataTable(ExcelPackage package) { ExcelWorksheet workSheet = package.Workbook.Worksheets.First(); DataTable table = new DataTable(); foreach (var firstRowCell in workSheet.Cells[1, 1, 1, workSheet.Dimension.End.Column]) { table.Columns.Add(firstRowCell.Text); } for (var rowNumber = 2; rowNumber <= workSheet.Dimension.End.Row; rowNumber++) { var row = workSheet.Cells[rowNumber, 1, rowNumber, workSheet.Dimension.End.Column]; var newRow = table.NewRow(); foreach (var cell in row) { newRow[cell.Start.Column - 1] = cell.Text; } table.Rows.Add(newRow); } return table; }
Thanks, A2H My Blog
Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
Login to post response