JSL Script for converting excel files to text files without opening the excel files

[shampton82]

I'd like to request an ability to convert an excel file to a text file through JSL without having to open the excel file first.  This would greatly speed up daily reports that have to reference excel files (fyi: an excel file currently takes 30 seconds to open but the same file as a text CSV file opens in a second).  Something along the lines of Copy(source, tabs, starting row, starting col, ending row, ending col).

This was brought up in this discussion post as well:

https://community.jmp.com/t5/Discussions/Save-xlsx-to-csv-file/m-p/36763

Thanks for considering it!

Steve

[SamGardner]

Steve, thanks for the input and the suggestion. Could you share an example XLSX file that takes a long time to import versus import as a CSV.  We can investigate that.  

I feel like a direct XLSX -> text import might be challenging.  Under the hood, XLSX is a compressed file with an XML structure, see https://docs.microsoft.com/en-us/openspecs/office_standards/ms-xlsx/f780b2d6-8252-4074-9fe3-5d7bc483...

but that XML structure and the data format can be hard to work with.

Another community discussion around this topic:

https://community.jmp.com/t5/Discussions/Help-With-XML-Parsing/td-p/86614

[shampton82]

Thanks for the input Sam and those links!

Let me clean up those files so I can share them and I'll get them over to you this weekend.