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?
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!