How can read content of excel file*

[janaka1984]

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

[mrks_js1]

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.

[janaka1984]

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

[romschn]

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.

[janaka1984]

Hi Ramesh,

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