Excel output from ChUI

[nicholas421]

For those still stuck in ChUI, you can still output to a spreadsheet (not CSV) with all the bells and whistles like formatting, sorting, subtotals, filters, comments etc. You basically output to an XML file and open it with Excel. See the attachment for a simplied example.

You can get as fancy as you want. To find out the proper tags, just create a spreadsheet in Excel the way you want it to look and save it as an XML file. Open the file with a text editor and you can see all the tags required.

 

[ttobba]

The program outputs the .xml file but I am unable to open the file in excel due to an error. It lists Table?

 

[trx]

XML probably requires newer version of Excel.
Alternatively:
- use mfg2xls if you have advanced terminal emulator - results in report opened locally in Excel
- use scripts ( UNIX SILENT VALUE("/path/to/<script>") ) to control Python to control headless OpenOffice to create and save spreadsheet - results in XLS file saved on server side (UNIX/Linux file system)

 

[joey.jeremiah]

http://www.oehive.org/project/libxlsx