[opencms-dev] Importing data from Excel-Sheets

[Shi Yusen]

It depends on what you want.

If you want to get Excel content in OpenCms, you can upload Excel file
and use jExcel to get its content. You can use jExcel to produce xml
document easily.

If you want to transfer Excel content to an OpenCms xmlcontent, you'd
better create a new xml content handler. I attached a sample handler
file, it extends the OpenCms mapping to support something like:
<mapping element="Title" mapto="property:Title|ExcelImport:sheet1!B2" />

Regards,

Shi Yusen/Beijing Langhua Ltd.


在 2006-11-03五的 11:07 +0100，Gabriele Wanielik写道：
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CmsSampleHandler.java
Type: text/x-java
Size: 14053 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20061103/ad06ae6d/attachment.java>