01-16-2007 10:30 PM
01-17-2007 12:25 AM - edited 01-17-2007 12:25 AM
There are many ways to do this and some ways use much more memory than others. If you are not careful, you might create quite a few extra data copies in memory.
What kind of data is in the spreadheet file? Since you are converting it to an array of strings, I assume it is not numeric data. Is that right? What kind of operations do you need to perform on the data? How are you displaying it?
If the data is actually numeric, a 40MB tab-delimited spreadsheet file is in an inefficient storage format an a copy in memory should take much less than 40MB. If it is really numeric data you should convert it directy to a numeric 2D array. Make sure you use the right datatype, e.g. if it is all integers, make a I32 array istead of DBL.
What is the array dimension (rows x colums)?
If you want, attach your code and a small version of your data file and we might be able to offer more specific advice. 😉
Message Edited by altenbach on 01-16-2007 10:26 PM