;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara

/*
Objective(s) -
- 	This program illustrates the use of following attributes of Field 
Excel Formula

About the program
-  This code is written to export excel file where the third field/cell shows the sum of first and second cell using 
-  excel formula in TDL 


*/



[#Menu: Gateway of Tally]
	
	Add: Item: ($$LocaleString:"Excel Formula"): Call: TSPL Report Excel Export 
	
[Function: TSPL Report Excel Export]
	
	000: Set	: SVExportFormat   : $$SysName:Excel
	010: Set	: SVPrintFileName  : ".\Export\Tally.xlsx"
	015: Export	: TSPL Report Excel Export : Yes : Yes

[Report: TSPL Report Excel Export]

	
[Form: TSPL Report Excel Export]
	
	Part: TSPL Report Excel Export
	
[Part: TSPL Report Excel Export]
	
	Line: TSPL Report Excel Export

	[Line: TSPL Report Excel Export]
		
		Field: TSPL Amt1, TSPL Amt2, TSPL Amt3
		
		[Field: TSPL Amt1]
			
			Use		: Amount Field
			Set as	: $$AsAmount:100
			
		[Field: TSPL Amt2]
			
			Use	   : Amount Field
			Set as : $$AsAmount:400
			
		[Field: TSPL Amt3]
			
			Use			 : Amount Field
			Excel Formula: "=A1+B1"

;EOF