I was able to create the code which save the data to a excel file which extension is "xlsx". However, I need find a way to export the data into an old excel file format which extension is "xls".
Any simple way I can implement this?
Here is my code :
wb.SaveAs(fileName, Excel.XlFileFormat.xlOpenXMLWorkbook, Type.Missing, Type.Missing, false, false, Excel.XlSaveAsAccessMode.xlNoChange, Excel.XlSaveConflictResolution.xlUserResolution, true, Type.Missing, Type.Missing, Type.Missing);
Thanks for reading this.