01-24-2017 02:05 AM
Hi all,
i am trying to read content (folder structure : ID and name) of excel file. i need to know how can i do in proper way?
please give me hint
Regards
Janaka
01-29-2017 12:21 PM
This looks like a very simple Excel file. Why not save it as a CSV and then you'll have plain text which you can read and parse easily from JavaScript.
Or better yet, express it as JSON and then you won't have to parse anything.
01-24-2017 05:34 AM
Hi Janaka
If it is concerning the content of the file, you could do a transformation to txt. (similar to this Applying rules to folders | Alfresco Documentation).
But you need to give us a bit more info about what you are trying to do here.
01-24-2017 05:40 AM
Hi Markus Joos,
I have excel file which contain folder id and name. I have to read content of file and generate folder structure under document library. this is one time task
Folder Id Folder Name
1 folder one
1.1 folder two
1.2 folder three
2 folder abc
01-24-2017 06:48 AM
You can use Apache POI API to read/write to excel files. Take a look at Apache POI – Reading and Writing Excel file in Java for reference.
Hope this helps.
01-24-2017 07:01 AM
Hi Ramesh,
do have any idea to read excel content using javascript api within alfresco
Explore our Alfresco products with the links below. Use labels to filter content by product module.