I have a select query which retruns data to excel sheet. But the
problem is excel sheet has formulas in between coulmns how can i
retain the formulas as it is and export data from the query.

Query
---------
Select name, a1, a2, b1, b2
from test

Excel Worksheet
-----------------
Name A1 A2 Total(Fromula:A1+A2) B1 B2 Total(Fromula:B1+B2)

How can i retain total formula?

Thanks
-Payal