Specific row as a header on Excel File

Specific row as a header on Excel File

  

Hi,

I have an Excel File stored as binary data type as an attribute of an Entity "E". So I want to read back this binary data as excel file, but it only works if the excel´s header starts on the first row. In my case the header is the row 3 (second and third rows are empty), and when I try to retrieve some data with the ExcelToRecordList, an error is raised because of the header. 

Why do I want to do this? Because I need to update an Entity "E2" from that Excel content.


The flow would be like this:

1- Excel File is received (the header will always be the row 3)

2- Excel File is stored as an attribute of the Entity "E"

3- When is needed, the binary attributes are read from Entity "E" to update Entity "E2".


** Stack: Java


So, is there a way to get the excel content if it doesn't start at row 1?

Or, is there another way to update the Entity directly from the binary data?  


If anyone can help me out with this, it would be nice!

Thanks!

Hi Daniel, 


There are several components on the Forge that you can use to get what you want.

You can try, for instance, this one.


Hope it helps.

João Sousa

Thank you, but that component is for Stack .NET. I wasn't able to find any component for Stack Java. If you know about one, please let me know.


Regards.