this code is perfectly working but one problem in this tdl , balance sheet and profit & loss working good means export directly from tally to excel with all amounts , but trial balance not exported with amount so please help for this all expert ( this tdl code is already uploaded on forum - mr.D.Lokesh sir ) see this tdl code here , [#Menu : Gateway Of Tally] Add : Button : TallytoExcel [Button : TallytoExcel] Key : Alt + T Action : Call : TallytoExcel Title : Tally - Excel [Function : TallytoExcel] 10 : Delete File : @@TallyConfigSF + "BalaceSheet Excel.xlsx" 20 : Delete File : @@TallyConfigSF + "TrailBalance Excel.xlsx" 30 : Delete File : @@TallyConfigSF + "ProfitLoss Excel.xlsx" 40 : Call : TE BalaceSheet Master 50 : Call : TE TrailBalance Master 60 : Call : TE ProfitLoss Master [System : Formulae] TallyConfigSF : $$ApplicationPath + "\Export\" [Function : TE BalaceSheet Master] Variable : SVExportLanguage : String Local Formula : ExpFilePath : $$ApplicationPath + "\Export\BalaceSheet Excel" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : No 06 : SET : SVExportLocation : No 07 : SET : SVPRINTFILENAME : $$MakeExportNameExpFilePath:##SVExportFormat 08 : Export : Balance Sheet : True 10 : Return [Function : TE TrailBalance Master] Variable : SVExportLanguage : String Local Formula : ExpFilePath : $$ApplicationPath + "\Export\TrailBalance Excel" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : No 06 : SET : SVExportLocation : No 07 : SET : SVPRINTFILENAME : $$MakeExportNameExpFilePath:##SVExportFormat 08 : Export : Trial Balance : True 10 : Return [Function : TE ProfitLoss Master] Variable : SVExportLanguage : String Local Formula : ExpFilePath : $$ApplicationPath + "\Export\ProfitLoss Excel" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : No 06 : SET : SVExportLocation : No 07 : SET : SVPRINTFILENAME : $$MakeExportNameExpFilePath:##SVExportFormat 08 : Export : Profit and Loss : True 10 : Return
replace with this code.......... Code: [#Menu : Gateway Of Tally] Add : Button : TallytoExcel [Button : TallytoExcel] Key : Alt + T Action : Call : TallytoExcel Title : Tally - Excel [Function : TallytoExcel] ;10 : Delete File : @@TallyConfigSF + "BalaceSheet Excel.xlsx" ;20 : Delete File : @@TallyConfigSF + "TrailBalance Excel.xlsx" ;30 : Delete File : @@TallyConfigSF + "ProfitLoss Excel.xlsx" 40 : Call : TE BalaceSheet Master 60 : Call : TE ProfitLoss Master 70 : Call : TE TrailBalance Master [System : Formulae] TallyConfigSF : $$ApplicationPath + "\Export\" [Function : TE BalaceSheet Master] Variable : SVExportLanguage : String Local Formula : ExpFilePath : $$ApplicationPath + "\Export\BalaceSheet Excel.xlsx" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : No 06 : SET : SVExportLocation : No 07 : SET : SVPRINTFILENAME : $$MakeExportName:@ExpFilePath:##SVExportFormat 08 : Export : Balance Sheet : True 10 : Return [Function : TE TrailBalance Master] Variable : SVExportLanguage : String Variable : DSPShowClosing: Logical Local Formula : ExpFilePath : $$ApplicationPath + "\Export\TrailBalance Excel.xlsx" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : No 06 : SET : SVExportLocation : No 07 : SET : DSPSHOWCLOSING: Yes 10 : SET : SVPRINTFILENAME : $$MakeExportName:@ExpFilePath:##SVExportFormat 11 : Export : Trial Balance : True 12 : Return [Function : TE ProfitLoss Master] Variable : SVExportLanguage : String Local Formula : ExpFilePath : $$ApplicationPath + "\Export\ProfitLoss Excel.xlsx" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : NO 06 : SET : SVExportLocation : No 07 : SET : SVPRINTFILENAME : $$MakeExportName:@ExpFilePath:##SVExportFormat 08 : Export : Profit and Loss : True 10 : Return
100: SET: requestURL1: "http://localhost:8383/PDFupload/upload.php" 130: SET: SVExportFormat: $$SysName:XML 150: SET: SVPrintFileName: $$MakeHTTPName:##requestURL1:No:"":"":"ABC Company" 160: Upload REPORT: . : TRUE Sir if i upload/Export in XML format the Company address is not coming in XML but company address is visible if i upload/Export as PDF format