- Home /

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!

Comment

Tim

Best Answer

**Answer** by tanglesoft ·

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?

**Answer** by SSGC ·

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.

**Answer** by tanglesoft ·

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.

Copyright 2019 Redgate Software.
Privacy Policy

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