Import data from excel

Hi
does anyone know how to import data tab for tab from one of those text files you can save excel spreadsheets as into c++ alternatively, is there a way of taking it directly from an excel spreadsheet i would need to be able to read a certain value from the table and then a value a specified subsequent number of timesteps further on and multiply them, then reiterate this in a loop. i am lost

Answer this question

Import data from excel

kjellj

Hello,

to read a tabulated text file, you could probably use sscanf.
For example to read one line with 3 columns containing an integer, a float and another float, you would do :

int iFirstValue;
float fSecondValue, fThirdValue;

sscanf(pTextLine, "%d\t%f\t%f", &iFirstValue, &fSecondValue, &fThirdValue);
// Assuming pTextLine is a char* string containing one line of your file.

The best if you have to do some processing on the data would be to use an array for each column of your sheet and to read the whole file into these arrays.
Afterwards you can do all the calculation you want on the arrays.

Import data from excel

Answer this question