c# - Need to automate crunching of excel data? -

i have processes running on windows xp/7. generate weekly .csv data files. have bunch of excel formulas crunch numbers each .csv file produced week separately , when adding weekly data 1 big spreadsheet containing data put together.

the number of rows varies each week , each process. can't hardcode number in dozens of formulas. right go through stupid process of manually entering formulas each week .csv files.

there's got way of automating this. looked doing through c# or vb code. recommend best way this. c# or vb right way go? if so, hints on how put - what's model use? example, this:

• c# module reads in .csv data file
• c# module creates excel spreadsheet , populates .csv data
• c# module runs formulas on rows.

is how 1 approach it? there better way has limited knowledge of c# or vb? know java , c++.

any advice highly appreciated.

thanks

from explanations in comments, appears having series of template excel sheets facilitate task.

so, each process generates data, formulas same, meaning columns same (am right?).

so, if don't know how many rows of data, can still either create template first row filled formulas, , copy row on , over, filling data needed, or, fill relatively "comfortable" number of rows same formulas, , fill in data.

there tons of atricles on how interop excel, it's beyond intent provide specific code, idea good.

if can allow myself, have worked in past interesting tool call flexcel studio .net, , have found of great when came generating excel sheets based on such templates.

cheers