Import Numeric Data from All Worksheets
This example shows how to import worksheets in an Excel® file that contains only numeric data (no row or column headers, and no inner cells with text) into a structure array, using the importdata function.
Create a sample spreadsheet file for importing by writing an array of numeric data to the first and second worksheets in a file called numdata.xlsx.
Import the data from all worksheets in numdata.xlsx.
S = importdata('numdata.xlsx')
S = Sheet1: [5x5 double] Sheet2: [5x6 double]
importdata returns a structure array, S, with one field for each worksheet with data.