topic Read an Excel file in a java action in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/read-an-excel-file-in-a-java-action/m-p/95092#M28011 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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.</P><P>The other restriction is that I can't modify the excel file before to insert it in alfresco.</P><P>Anyone have any suggestion to reach that?</P></BODY></HTML> Mon, 24 Jun 2019 22:57:51 GMT germangq 2019-06-24T22:57:51Z Read an Excel file in a java action https://connect.hyland.com/t5/alfresco-forum/read-an-excel-file-in-a-java-action/m-p/95092#M28011 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 con Mon, 24 Jun 2019 22:57:51 GMT https://connect.hyland.com/t5/alfresco-forum/read-an-excel-file-in-a-java-action/m-p/95092#M28011 germangq 2019-06-24T22:57:51Z Re: Read an Excel file in a java action https://connect.hyland.com/t5/alfresco-forum/read-an-excel-file-in-a-java-action/m-p/95093#M28012 <HTML><HEAD></HEAD><BODY><P>You can have the content of a node by using Java API on an Action:</P><P></P><P><A class="link-titled" href="https://github.com/keensoft/alfresco-simple-ocr/blob/master/simple-ocr-repo/src/main/java/es/keensoft/alfresco/ocr/OCRExtractAction.java#L91" title="https://github.com/keensoft/alfresco-simple-ocr/blob/master/simple-ocr-repo/src/main/java/es/keensoft/alfresco/ocr/OCRExtractAction.java#L91" rel="nofollow noopener noreferrer">alfresco-simple-ocr/OCRExtractAction.java at master · keensoft/alfresco-simple-ocr · GitHub</A>&nbsp;</P><P></P><P>Hope this helps.</P></BODY></HTML> Fri, 09 Aug 2019 07:35:36 GMT https://connect.hyland.com/t5/alfresco-forum/read-an-excel-file-in-a-java-action/m-p/95093#M28012 angelborroy 2019-08-09T07:35:36Z