Skip to Content (Press Enter)
2014-07-01 01-00-59
Miguel Oliveira
4Views
2Comments
Export to Excel XSLX files
Question
Hi all,

I need to export to Excel, data with more than 65536 rows.
In OutSystems Platform 5.1, is it possible to export xlsx excel files?

Best regards,
Miguel Oliveira
0
0
25 Aug 2011
Copy Link
2020-10-15 10-24-31
Miguel Seabra Melo
Hi Miguel,

Unfortunately not: version 5.1 will only produce "normal" XLS files with the 64k row limit. Version 6.0 of the Platform, however, outputs XLSX files and does not have the old format's limit.

Cheers,


Miguel
0
0
25 Aug 2011
Copy Link
2018-09-07 11-54-27
Eric Oud Ammerveld
Actually you might want to create an XML file yourself.

An XLSX file is just a zip file with some XML content.
Rename attached TextFile.xlsx to .zip and open it.

You find "sheet1.xml" in \xl\worksheets\

Create a Structure (Record type) according to that XML and do an RecordListToXML instead.
Only problem then would be to put that XML in the ZIP file and save provide that file to the user as an XLSX.

Hope that kind of helps. :)
TextFile.xlsx
0
0
25 Aug 2011
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.