- Home
- Anonymous
- Sign in
- Create
- Ask a question
- Spaces
- Site Issues (NOT FOR DATABASE QUESTIONS)
- Explore
- Topics
- Questions
- Users
- Badges

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!

ssisexcel
Comment

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?

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.

**13** People are following this question.

Copyright 2022 Redgate Software.
Privacy Policy