nickfinity
New Member
- Joined
- Feb 9, 2010
- Messages
- 19
Hello,
I hope you all can help me. I'm using C# to insert some values into spreadsheets. I've got about 40 files I'm looping through and getting the sheet I need. Each sheet has anywhere between a few hundred to a few thousand rows with values. I need to add about 10 more columns for each row. Each new cell will have a formula in it, something simple like, =min(A3:A13).
Right now it's really, really slow. I'm going through each row, grabbing the range "J1:W1" for example, and setting the value of each cell. Is there a faster way to do this?
Thanks for any help, I really appreciate it.
Nick
I hope you all can help me. I'm using C# to insert some values into spreadsheets. I've got about 40 files I'm looping through and getting the sheet I need. Each sheet has anywhere between a few hundred to a few thousand rows with values. I need to add about 10 more columns for each row. Each new cell will have a formula in it, something simple like, =min(A3:A13).
Right now it's really, really slow. I'm going through each row, grabbing the range "J1:W1" for example, and setting the value of each cell. Is there a faster way to do this?
Thanks for any help, I really appreciate it.
Nick