Prev: filterbuilder bug: Scale SOS filter coefficients to reduce chance of overflow
Next: check syntax errors in m file
From: giulia on 17 Jun 2010 17:38
Hi all

i am sorry to bother you with such a simple question, but i am having problems loading a very long excel file for data analisys. The xlsread function errors out saying that the file is too big! And so does the dlmread function as it thinks that there are some "mismatch between file and format string"

I am running Matlab 7.4 Student Version on a Mac running 10.5.8

The excel file was created by an eye tracking program and it is tab-delimited text. Its dimensions are 34 columns and 24435 rows. The first row is a header row, which could be excluded if that were better.

Any help is much appreciated.

giulia
From: Walter Roberson on 17 Jun 2010 17:49
giulia wrote:

> i am sorry to bother you with such a simple question, but i am having
> problems loading a very long excel file for data analisys. The xlsread
> function errors out saying that the file is too big! And so does the
> dlmread function as it thinks that there are some "mismatch between file
> and format string"
>
> I am running Matlab 7.4 Student Version on a Mac running 10.5.8
>
> The excel file was created by an eye tracking program and it is
> tab-delimited text. Its dimensions are 34 columns and 24435 rows. The
> first row is a header row, which could be excluded if that were better.

That is correct, older versions of Excel only supported up to 16383 rows.

When you use dlmread, it has no way to skip the header for a file of unknown
number of rows.

I suggest you use textscan() as you can specify HeaderLines to it, and you can
use Delimiter '\t' . Your format string would reflect how you want the columns
parsed.
 | 
Pages: 1
Prev: filterbuilder bug: Scale SOS filter coefficients to reduce chance of overflow
Next: check syntax errors in m file