I have to read the content of an excel file in a java backed webscript because I need to save the rows in a table in my database. The problem is that when I execute my action I just have a node and I don't know hoy to convert it to a excel file to use Apache POI o something like this to read the content of the file.
I have tried using the "transform and copy" action, to convert the excel file into a CSV file, but with this the empty cells just don't show in the csv and in those cases I don't have the same number of columns.
The other restriction is that I can't modify the excel file before to insert it in alfresco.
Anyone have any suggestion to reach that?