LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Saby

Hi All,

I want to Publish my output as a multi tab Excel file using Lavastorm 4.5.3.

I know this can be easily done using LAE 4.6. But the problem is 4.5.3 does not have the EXCEL out put option.

So if any one use the similar version and know the way out please let me know the same.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

Obviously the easiest way to get nodes for these purposes would be to upgrade to a later version of the LAE.
The nodes are written against the version of the LAE with which they are shipped, therefore you can't simply use the nodes against an older install.

However, if upgrading your LAE system isn't an option then the only alternatives I can think of are to write a custom Python or Java node.

While I've never used it myself, I believe you should be able to use the Python xlwt package to perform this (https://secure.simplistix.co.uk/svn/...wt.html?p=4966).

If writing a custom Java node, the Apache POI (http://poi.apache.org/) project can be used.
The Output Excel, Append Excel and Excel File nodes within the LAE (as of 4.6+) all use the Apache POI libraries.

Obviously, this would require you writing a custom Java or Python node, which would mean that some coding on your part would be required.

If you go down this path, then the Java Node Getting Started Guide or Python Node Getting Started Guide (depending on which way you go) would be a good starting point to learn how to write custom Python or Java nodes.
The Java Node Getting Started Guide should be packaged with your installation.
I think in LAE 4.5.3 the Python Node Getting Started Guide was not shipped with the installation.
A version of it is available here: http://www.lavastorm.com/assets/5.0-...ng-Started.pdf - which is applicable to LAE 5.0.
However, the Python node API has been pretty stable for a long time, so the information in that getting started guide should also be sufficient to get started writing Python nodes in LAE 4.5.3.

Regards,
Tim.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

There is a version of the excel publishing node available with 4.5.3 however it is an experimental node but it does work.
To get access to this node in BRE click on Tools>General then click the Advanced button at the bottom right hand corner then select "Use Expermental Nodes" in the Plugin Paths