I need help reading a .xls file. I'm using the advanced Excel forge component, but the data is returning empty. When I use the file in .xlsx format, I can read it normally. Besides this method, I tried using the BinaryData extension and the "BinaryDataToText" action, but it also returned empty. Does anyone have any idea how I can do this? I need to validate the file header."
Sure, we'll proceed with converting the files to .xlsx format since EPPlus doesn't support .xls. Thank you for your response and the suggestion to convert.
Hi Vinicius,
This component uses the EPPlus library, which doesn’t natively support the older .xls format used by Excel 97-2003.
According to the official EPPlus documentation, the following formats are supported:
Would it be possible for you to convert your files to .xlsx?
Hello Vinicius,
Perhaps, so that you don't always have to do the work of converting the xls file to xlsx, you can create your own extended action with C# to read the file and return the data you need. It's very simple using Integration Studio, but if you need any help, you can tell us so we can take your case as an example and create a specific method for it together.
Good luck and if you need help, count on us.
Thank you, Stanqueviski!
I handled it by creating an extension in Integration Studio to convert the file, which allowed me to read the data. Since it's a simple file and won't have many variations, I believe this solution is sufficient. Thank you once again for everyone's support.