question

SSGC avatar image
SSGC asked

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!
ssisexcel
10 |1200 characters needed characters left characters exceeded

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

tanglesoft avatar image
tanglesoft answered
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?
10 |1200 characters needed characters left characters exceeded

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

SSGC avatar image
SSGC answered
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.
10 |1200 characters needed characters left characters exceeded

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

tanglesoft avatar image
tanglesoft answered
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.
10 |1200 characters needed characters left characters exceeded

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

SSGC avatar image
SSGC answered
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.
10 |1200 characters needed characters left characters exceeded

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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