[opencms-dev] Importing data from Excel-Sheets

[Ron Wheeler]

You can also open your Excel document in OpenOffice and save it in the 
native OpenOffice format
This format is just a zipped archive and the sub-file "content.xml" is 
the spreadsheet data.

 If OpenCMs can unzip the archive and extract the xml file, you should 
be all done.

Ron

Jonathan Woods wrote:
> There's no conversion capability out of the box.  In my case, I put an 
> empty XML document instance in Word and mail-merged my spreadsheet 
> into that to generate multiple concrete XML docs, and then uploaded 
> those into the VFS.  You can zip files up, upload the zip archive and 
> have OpenCms unzip it for you.
>  
> Jon
>
> ------------------------------------------------------------------------
> *From:* opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] *On Behalf Of *Gabriele Wanielik
> *Sent:* 03 November 2006 10:08
> *To:* The OpenCms mailing list
> *Subject:* [opencms-dev] Importing data from Excel-Sheets
>
> Hi list,
>
> I want to import data that are stored in Excel-Sheets to OpenCms so 
> that they are available in OpenCms as XML-content. Do I have to 
> convert them or can I access parts of the Excel-Sheets directly from 
> OpenCms e.g. using some mapping?
>
> I couldn't find a description on this. Did I miss something in the 
> docs or can anyone give me a solution to my problem?
>
> Thanks,
>
> Gabriele Wanielik
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev