I need to download internal tables data and header data into one excel sheet with XLSX format. Now I am doing with OLE approach, but it is in XLS format. Is there any other way to download excel data in the form of XLSX format.
If anyone facing similar issue then here is the solution. While saving the excel file using method 'SaveAs' for #2 parameter we need to pass 51 for XLSX and 1 for XLS file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.