Hi Reader,

I have a situation like I have an application which is having Export Excel option and for that I am using Excel package forge component. 

While passing template I will be using empty template with only the sheet name as "Purchase" and the data for this excel will be passed through JSON values

My requirement is Before clicking on export I can select the date range and it will download the excel based on that date range. So now I want that excel to have a formula inside it and that cell should be updated based on the other cell values. 

For example:

I have a column Pending Supply and this column values should be 

Total Ask-Sum(StartRange:EndRange)

I want to use this formula for the Pending Supply column. The entries inside excel will be dynamic. So I want this formula to be applied for all the rows present. 

That is, If there are 5  entries inside excel and have selected 3 days range  then this formula should be applied for all those 5 rows and formula will be like

Total Ask-Sum(Day1:Day3)

How can I achieve this can someone please help me?

Thanks in advance