cancel
Showing results for 
Search instead for 
Did you mean: 

How can read content of excel file*

janaka1984
Star Contributor
Star Contributor

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

1 ACCEPTED ANSWER

jpotts
World-Class Innovator
World-Class Innovator

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.

View answer in original post

8 REPLIES 8

mrks_js1
Star Contributor
Star Contributor

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.

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

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.

Hi Ramesh,

do have any idea to read excel content using javascript api within alfresco