how to Convert XLSX (EXCEL) to XLS (EXCEL) without ms-office using c#

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