Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for considering Aspose.
Yes, you can open Excel 2007 Xlsx files and save them in XLS file format and vice versa. Please see the following documentation link regarding the details about opening and saving of different excel file formats.
Set workbook = Server.CreateObject(“Aspose.Cells.Workbook”) workbook.open filexlsx, FileFormatType.Excel2007Xlsx ’ Open the XLSX file workbook.save filexls, FileFormatType.Excel2003 ’ Save as XLS file --------------------
The above gives an error on the workbook.open line. Error: "Object required: FileFormatType"
Please use the constant values for the enumeration types and take care about overloaded version numbers in Classic ASP.
e.g
Set workbook = Server.CreateObject(“Aspose.Cells.Workbook”)
workbook.open_6
filexlsx, 6 ’ Open the XLSX file
workbook.save_5
filexls, 5 ’ Save as XLS file
or you may even skip it. the product would auto detect the file format types.
Set workbook = Server.CreateObject(“Aspose.Cells.Workbook”)
workbook.open_5
filexlsx ’ Open the XLSX file
workbook.save_4
filexls ’ Save as XLS file
Note: We do provide a TLB file with the Aspose.Cells.dll library. Please open this file into VS.NET to know about the APIs and the constant values for enumerations.