Hi Mark, Thank you for your help I will investigate this and see if the client thinks it is suitable.
Regards Richard On 1 March 2010 15:56, Mark Fortner <[email protected]> wrote: > Hi Richard, > I usually just use Excel XML as a Velocity template and insert > Velocity macro statements directly into the template using a text > editor. It's pretty easy to do and Velocity is pretty well > documented. This should help you get started: > http://velocity.apache.org/ > > Hope this helps, > > Mark > > On Monday, March 1, 2010, Richard Holmes <[email protected]> > wrote: > > Hi All, > > > > A client of mine is looking to export a java object model to various > EXCEL > > sheets. These sheets are not of any particular format or layout and they > > would like to be able to use some form of configuration files to populate > > the sheets how they wish, the EXCEL version being used is 2003. > > > > The options I am looking into are: > > 1) Use the XML features in EXCEL to populate the workbook - but in this > case > > I can not find a way of updating the XML source in Java, in .net is it > > ImportXML. > > 2) Use some sort of configuration take the java or XML object and > populate > > the sheets/cells in Excel, I have tried jxls but this does not have the > > flexibility other than this I have come up short. (I am looking into > using > > mono but I don't believe this is possible either). > > 3) Use EXCEL macros to re-format the data once in the sheet, but again > this > > requires the users to perform actions, such as allowing macros to be run. > > Some of our users find this a complex proceedure :) > > > > I have thought of writing my own engine but the deadlines are too short. > > > > If anyone has any ideas I would be very greatful, the easiest for me > would > > be to find a way of updating XML or find an engine that uses a > configuration > > file to populate EXCEL. > > > > Many thanks > > Richard > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
