Excel to Tally - Using PHP
This code illustrates how to read data from Excel sheet and import it into Tally Software for free without using any third party tools or software.
Excel data
The Excel sheet that we have used in this sample contains LEDGER Masters. The sheet format is as follows :
Ledger_Name Parent
ABC Co Sundry Debtors
Infosheel Marketing Sundry Creditors
Prism Corporation Sundry Debtors
As you can see, there are two columns. The first contains the Ledger names and the second contains the Group / parent name.
Import data from Excel to Tally
Copy the files into a folder within www folder and then open the folloiwng URL in a browser
localhost://myfolder/excel-to-tally.php
We use PHPExcelReader class to read the Excel data and PHP Curl to post it into Tally ERP 9.
The Excel data is read and converted into XML. It is then posted to Tally automatically without any manual intervention. This is done using HTTP POST request on Port 9000. If there is any error, the same is returned by Tally software.
You can view the ledgers created in Tally ERP 9 using the following option :
Gateway of Tally > Accounts Info >> Ledgers > Display
Read all about Excel to Tally at : https://www.rtslink.com