Hello. I hope not to annoy you with such a question.
I'd like to read cell data from specific columns within a spreadsheet. I'm trying to read data within the following format (from the .xls file I'm analyzing).
Wavelength (nm),Absorbance (AU),Std.Dev. 190,-0.333324432373047,0.187723662173536 191,-0.184257030487061,0.169325912513228 192,0.0989446640014648,0.243154257457939 193,-0.196856021881104,0.322099862671817 194,0.0530929565429688,0.250335468281439 195,0.146337985992432,0.301110817821903 196,0.0579915046691895,0.359937145256163 197,-0.309549331665039,0.293385120791022 198,-0.396398544311523,0.2578125
Lets say I'd like to get the average of all of the numbers within the second column? How would I go about doing that? I understand that the comma is used as a delimiter within the rows to separate the cell's association with the columns. How would I go about reading each value after the program encounters the delimiter? I want to use each value for a something mathematical, so I imagine I'd need to store each value as a number somehow.
-I'd like to read each cell from a column.
-I'd like to use the values within each cell to find an average.
Can someone please help me in doing this?
I thank you very much.