Can matlab R2009a hold an input value greater than 65336 values?

I am trying to import an excel file which is 100,000 entries into matlab but matlab keeps saying inout can only handle 65336 data?

How do I import more than 65336 data points to one array?

Answer 1

[Jan]

This magic number has been a limitation of old Excel versions, but not of Matlab. Are you using a pre-Office2007 version of Excel to import an XLS file written with a modern Excel version?

[moizz]

Excel 2007 .xlsx files. Can matlab R2009a read .xlsx files cause when I run uigetfile the .xslx files do not show up?

[Jan]

It is not Matlab who reads the XLSX files. You still need an installed Excel for the import. Otherwise only the "basic" import is used, as explained in the documentation of XLSREAD exhaustively.

Answer 2

[Walter Roberson]

Which version of excel are you using, and what is the file extension (e.g., .xls ?) 65536 was a long-standing limit in Excel itself.

[moizz]

Excel 2007 .xlsx files. Can matlab R2009a read .xlsx files cause when I run uigetfile the .xslx files do not show up?