Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

System Requirements for Importing Spreadsheets

Importing Spreadsheets with Excel for Windows

If your system has Excel® for Windows® installed, including the COM server (part of the typical installation of Excel):

  • All MATLAB® import options support XLS, XLSX, XLSB, XLSM, XLTM, and XLTX formats.

  • xlsread also imports HTML-based formats.

  • xlsread includes an option to open Excel and select the range of data interactively. To use this option, call xlsread with the following syntax:

    mydata = xlsread(filename, -1)
  • If you have Excel 2003 installed, but want to read a 2007 format (such as XLSX, XLSB, or XLSM), install the Office 2007 Compatibility Pack.

  • If you have Excel 2010, all MATLAB import options support ODS files.

    Note:   Large files in XLSX format sometimes load slowly. For better import and export performance, Microsoft® recommends that you use the XLSB format.

Importing Spreadsheets Without Excel for Windows

If your system does not have Excel for Windows installed, or the COM server is not available:

  • All MATLAB import options read XLS, XLSX, XLSM, XLTM, and XLTX files.

Was this topic helpful?