Friday, November 26, 2010

Convert XSL file to XLSX file using C# .net

the below code is just on your Upload control event

Code Starts--->


/*User control name */  CutomerFileUpload.SaveAs("C:\\Temp.xls");
//here use can add reference for Excel library by--> Project tab --> add reference --> com tab then add
" Microsoft Excel 12.0 Object Library component "


Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
excelApp.Visible = false;

Microsoft.Office.Interop.Excel.Workbook eWorkbook = excelApp.Workbooks.Open("C:\\Temp.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

eWorkbook.SaveAs("C:\\Temp2.xlsx", Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

eWorkbook.Close(false, Type.Missing, Type.Missing);

//Finish


Enjoyyyyyyyyyyyyyyyyyyyyyy