We are trying to export a report to .xlsx format with a PB 2019 application using PowerServer 2020. Here is the GetFileSaveName call we are using for the dialog.
GetFileSaveName ( "Save As", ls_path, ls_file, "", "Excel with headers (*.xls),*.xls,Excel12 with headers (*.xlsx),*.xlsx,Text with headers (*.txt),*.txt, CSV with headers (*.csv),*.csv" , "", 32770)
If the extension is xlsx we then call dw.SaveAs(s_path,EXCEL!,True, EncodingANSI!). We have also tried EXCEL5!. The export seems to work but when you open the file you get the attached error. Is the xlsx extension not supported in PowerServer? If not, are there any known workarounds?