topic Script Content Excel in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/script-content-excel/m-p/292862#M245992 <HTML><HEAD></HEAD><BODY><SPAN>Good afternoon,</SPAN><BR /><BR /><SPAN>I am developing the following project in Alfresco. I have 3 types of documents belonging to a person: registration form, Identity and Passport Card . The metadata of each document are: Name, date of birth, Social Security Number. I'm working with the concept of dossier. All the same person documents are grouped in the same folder. After extracting the metadata and creating the dossier of each person ( with registration form, Identity and Passport Card) I want to view the extracted metadata for each document in one other document. For this I created an Excel spreadsheet with three tabs. I would like to copy the metadata into this worksheet.</SPAN><BR /><SPAN>I searched on the internet and not&nbsp;&nbsp; found a way to write in a .xlsx file. Does anyone know if there is a way to update the contents of a spreadsheet that is in the Alfresco repository using a script. If not, do you have any other suggestions?</SPAN><BR /><BR /><SPAN>Thank you</SPAN></BODY></HTML> Thu, 23 Jul 2015 20:29:52 GMT americanolinhar 2015-07-23T20:29:52Z Script Content Excel https://connect.hyland.com/t5/alfresco-archive/script-content-excel/m-p/292862#M245992 Good afternoon,I am developing the following project in Alfresco. I have 3 types of documents belonging to a person: registration form, Identity and Passport Card . The metadata of each document are: Name, date of birth, Social Security Number. I'm working with the concept of dossier. All the same p Thu, 23 Jul 2015 20:29:52 GMT https://connect.hyland.com/t5/alfresco-archive/script-content-excel/m-p/292862#M245992 americanolinhar 2015-07-23T20:29:52Z Re: Script Content Excel https://connect.hyland.com/t5/alfresco-archive/script-content-excel/m-p/292863#M245993 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>You can create a CSV and provide preference as XLS. The CSV created in this format will open directly in XLS</SPAN><BR /><BR /><SPAN>Refer : </SPAN><A href="https://super-csv.github.io/super-csv/apidocs/org/supercsv/prefs/CsvPreference.html" rel="nofollow noopener noreferrer">https://super-csv.github.io/super-csv/apidocs/org/supercsv/prefs/CsvPreference.html</A><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Mon, 27 Jul 2015 05:21:50 GMT https://connect.hyland.com/t5/alfresco-archive/script-content-excel/m-p/292863#M245993 rahulmackdani 2015-07-27T05:21:50Z Re: Script Content Excel https://connect.hyland.com/t5/alfresco-archive/script-content-excel/m-p/292864#M245994 <HTML><HEAD></HEAD><BODY><BR /><SPAN>Thank you. I'm using this approach.</SPAN></BODY></HTML> Thu, 06 Aug 2015 21:48:22 GMT https://connect.hyland.com/t5/alfresco-archive/script-content-excel/m-p/292864#M245994 americanolinhar 2015-08-06T21:48:22Z