How to Export Tally Data programmatically to CSV or Excel format

Question

I am trying to export data from Tally ERP9 using Python/Pentaho. Is there any way to connect to Tally ERP9 and export the data programmatically or via Pentaho?

Answer 1

Tally Data in Excel or PDF: How to Export Tally Data
1.Open the data to be exported (general ledger, profit and loss, or balance sheet).
2.Click the Export button ( Shortcut Alt E)
3.Esc.
4.Choose between Excel and PDF as your file type.
5.Enter the required file name.
6.Leave the rest of the information alone.
7.Press Enter or Ctrl A to start typing.
8.The file was downloaded to the Tally folder.