Putting cell values from excel columns into multiple arrays

[bellaelysium]

http://www.dotnetperls.com/datagridview-vbnet for some brief info on datagridview. It basically contains columns and rows kind of like a spreadsheet.

If you wanted to view the items all at one time, say through a messagebox, you could use whats called a stringbuilder. In your instance however, you do not need to view all the data at once. Instead, you can write each value in the list to a row using a for each loop. Increment the row number and column numbers as needed. Below is an example to get you started.

Finally I am getting started somewhere. I have read through the datagridview and it seems like its for displaying purposes. Can you actually manipulate the data?
I am trying to actually manipulate the values of each column with this code (excel macro) in vb.net format:

ActiveCell.FormulaR1C1 = "=RC1/INDIRECT(""$A""&(COLUMN()))"

So initially, my idea is to put each column of values into new workbook and then insert this INDIRECT formula before combining the same column from all workbooks into one master workbook and filtered out the rows that I don't want. Does the datagridview able to do that? I have huge datasets so it is a performance killer and cause my computer to lag so I thought of putting them into arrays and manipulate straight from there but I do not know if its possible to that for generic list...and have no idea how to proceed.


From what I read, it seems the datagridview is more for displaying purposes?


Thanks for your guidance so far