I have 6 WorkBook let say a.xlsx , b.xlsx and so on...
for ex. data of a.xlsx file
and I fill these 6 Workbook from SQL Database and at Bottom of Every WorkBook i have applied Excel formula for Addition .. Total Commission
and Now I want to make One Summary Sheet (Summary.xlsx) Where I need to display List of Summary of Total Commission from Each Sheet
After Exporting Report from asp.net using C# .. if I will do changes in abc.xlsx than Summary Sheet data will also Updated accordingly
Is it Possible to DO ?
public static class ExcelTest
{
public static void Basic_one()
{
Excel.Application xlApp ;
Excel.Workbook xlWorkBook ;
Excel.Worksheet ...
Go to the complete details ...