Excel export at PNL and Balance Sheet
aungzwin10 opened this issue · 4 comments
I would like to request to develop Excel export function at PNL report and Balance Sheet report.
Format of excel would be the same as PDF export or current HTML output.
Our templating system is designed to allow users to develop this kind of functionality themselves. However, I've checked the HTML template for required functionalities to implement the template versus the functionalities available in the XLS templating engine.
The following functionalities are missing (to be checked once implemented):
- Setting of column width (in order to be able to create indenting)
- Merging of cells (in order to create a single cell with text for the remainder of the row)
Further more, the links at the bottom of the PNL and Balance sheet are hard-coded, meaning that additional templates in additional formats won't show, even when the application knows how to process these templates.
How can I implement this excel export?
@aungzwin10 you need to create a template named"balance_sheet.xlst" and use the tags from https://github.com/ledgersmb/LedgerSMB/blob/master/lib/LedgerSMB/Template/Plugin/XLSX.pm#L139 to generate worksheets, rows and cells.