ledgersmb / LedgerSMB

Double-entry accounting & ERP for the web
https://ledgersmb.org
Other
429 stars 152 forks source link

Excel export at PNL and Balance Sheet #4958

Open aungzwin10 opened 4 years ago

aungzwin10 commented 4 years ago

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.

ehuelsmann commented 4 years ago

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):

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.

aungzwin10 commented 4 years ago

How can I implement this excel export?

ehuelsmann commented 1 year ago

@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.

ehuelsmann commented 11 months ago

I'll build this when someone sponsors it.