I have to read excel (xlsx) file from SFTP location and load it into CSF. Can ION Parse excel file into Plain text for loading?
In reply to Mike Kalinowski:
Just FYI that I've added supporting spreadsheet files (XLS & XLSX) to our backlog so our analyst team can do some more investigation. If you have more details such as whether your spreadsheets contain 2+ sheets, complex formatting & headers, etc. - or even some sample spreadsheets - I'd certainly love to hear more about it.
As an aside, we have a new product coming to ION & Infor OS in the cloud soon called "ION Scripting." Theoretically, you could grab your spreadsheet from a file server using ION's "ANY" document type (used for handling binary files) and use a Python script and/or package to convert your XLSX files into plain-text like a CSV. Keith Knuth is the product manager for this product so if you have questions or want to learn more, he's great to reach out to!
In reply to Sethu: