JSL Script for converting excel files to text files without opening the excel filesI'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
Automation and ScriptingRe: JSL Script for converting excel files to text files without opening the excel files - Status changed to: InvestigatingRe: JSL Script for converting excel files to text files without opening the excel filesThanks 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.
Re: JSL Script for converting excel files to text files without opening the excel files - Status changed to: Needs InfoSteve, 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-5d7bc4830968,
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
Re: JSL Script for converting excel files to text files without opening the excel files - Status changed to: Acknowledged
