# question

## How I can do automatic calculation for two excel files?

I have two excel files. I want to do some calculation for both files then genrated a new excel file. something like: excel file#1: a 1 b 2 c 3 Excel file#2: a 4 b 5 c 6 After automaticly calculation get third Excel file#3 like: a 5 b 7 c 9 Could some one help with this issue? Can I do it in SSIS package? Thank you very much!

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

·
You could import both excel files into tables then construct a third table by calculating the columns in T-SQL then outputting to third spreadsheet. However it sounds like a problem that can be solved with Excel only. Can the third spreadsheet just contain links and formulas to the other 2?

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you for the answer. Can we do it all in a ssis package not create any outside tables? how i can solved it with excel only? we have two excel files in a file folder, then we want generate a new excel file after calculation.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You could write Excel automation code that you execute inside the SSIS package. If the third spread sheet is based on a complex transformation of 1 and 2 you may be better of creating the 3rd spreadsheet with all the links and formulas as macros in the third spreadsheet. To avoid a user having to open the third spreadsheet you could automate the open/update links and save part of the process in SSIS. I need to understand the different parties involved the generation of the data to give a better informed answer.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

We have a weekly job to generate a Excel file. We want compare this new Excel file with previus week's Excel file. Each file have a lot data many columns. We want match the row and do the calculation to generate new Excel file. Can we do it all in SSIS package? If we need generate a third Excel first with marco code how we can do it? Thanks.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total. 