reading a large xls file

Also, xlsread permits you to load only certain rows and columns, so I thought
that might help in paring down the amount of data in each load, but it won't
read any of the data if the entire file is too large, as is the case here.

Can anyone help me on this? Sorry for the newbie question!



"L. Tomas" <adam.e.sachs@xxxxxxxxx> wrote in message <ftdhdt$eqv
$1@xxxxxxxxxxxxxxxxxx>...
Thanks for the suggestion, Daphne. Unfortunately, much of the data is
non-
numeric, so dlmread can't read it in. Do you know of another workaround?
Thanks!


"Daphne " <daphnew_too_nospam@xxxxxxxxx> wrote in message
<ftcamh
$si2$1@xxxxxxxxxxxxxxxxxx>...

Have you tried saving the excel file as a Tab delimited
text file? Matlab can read those much faster than xlsread
with dlmread.

I don't know how long your file actually is, but I would
give this a shot, as writing a little excel macro to save
xls to txt shouldn't be hard.

Daphne



"L. Tomas" <adam.e.sachs@xxxxxxxxx> wrote in message
<ftbe3i$gd4$1@xxxxxxxxxxxxxxxxxx>...
I'm trying to xlsread a large excel file but get the
error:

"??? File contains unexpected record length. Try saving
as Excel 98."

If I break the excel file into chunks, I can read each
part in, but I'm looking for a
systematic way to do it without having to tinker with
the file itself. Any tips
would be greatly appreciated.



.

Relevant Pages

  • TOO Long to load
    ... can anyone tell me that after creating and saving an ... excel file why does it take a long time to load back when ...
    (microsoft.public.excel.crashesgpfs)
  • Re: Docs2Go v9
    ... manually with Filez and deleting as appropriate. ... Formatting is retained, which is nice, and one Excel file ... that would never load under previous versions now does. ... A Word file that has graphics embedded in it ...
    (comp.sys.palmtops.pilot)
  • Re: Import excel but selected column for selected table
    ... Do you other method where user can browse the excel file and then load it in ... the table with selected field to appear? ... Append query and append to table 1. ... For example i want to be able to specify column 1,2,3 to load in table 1 ...
    (microsoft.public.access.formscoding)
  • Re: Windows XP Repeated Crashes
    ... Excel file. ... The exact address will almost certainly not be listed. ... load address and extending up to but not including the load ... Using a recent PSTAT report from a different machine I find that ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: How to open a large excel file?
    ... Die Tastatur von alex lee wurde wie folgt gedrückt: ... Excel can onle open no more than 65000 row data.I also try to load ... the excel file from Access,but it also cann't run.So how can I load ... the data in the file without 65000 row data? ...
    (microsoft.public.excel)