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!
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?
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.
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.
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.