This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We need to load Excel files that we produced using our Alteryx workflow into our Oracle based solution. Unfortunately, after we load the Excel file processed by Alteryx, the fields which type is String are empty. Cells are being loaded, we can see the cells, we can see that cell data types are strings, it's just the values are not accessible for some reason, the software shows them as empty values. The values for fields of the other types i.e. Int32, are accessible.
What is important is that when we open the file produced by Alteryx in Excel and save it, all the values are accessible when we load this to Oracle.
On Alteryx side, we have tested various String types, each time getting the same results. I have attached the sample workflow and the sample Excel test file.
This is the file processed by Alteryx:
This is what we see in our Oracle solution:
I am also attaching some feedback from our Oracle developer which is still investigating the issue on his side:
“… The file is being read into a BLOB. Then I tried 2 different Oracle-based developments to process it. The first is a freeware called AS_READ_XLSX. It's a very basic thing which gives you access to all the cells in an XLSX document using Dbms_Xslprocessor and Dbms_Xmldom.
The second is called PLPDF and we bought a license for it. It's also an Oracle based development to work with excel, PDF and XML documents. This is more sophisticated then the freeware, but also basically gives you access to all the cells.
The results were the same for both tools: in the tab DeclarationInfo both can only see values for client code and job number, the rest of the cells have empty values according to both tools…”