How to save Excel file as a variable and pull data from it?

조회 수: 15 (최근 30일)
Din N
Din N 2021년 7월 9일
답변: Sergio Yanez-Pagans 2021년 7월 9일
I have an Excel file with several sheets. I would like to first read the whole Excel file and then just pull data from specific sheets. This is what I have now. This works but is very slow and I have to do this for every sheet.
data_prev=readtable('Predictions.xlsx','Sheet','Specific Impulse','Range','A1:A10');
And this is what I would like to do:
k=readtable('Predictions.xlsx');
data_prev(l,etc.)
So, to make it more clear, I just want to read the whole file and store it as a variable ( k for example) and then when I need to read a specific sheet, just use that variable.
I cannot share my Excel file for various reasons, so I am just asking for some guidance.

채택된 답변

Walter Roberson
Walter Roberson 2021년 7월 9일
Unfortunately, Mathworks does not provide any method of reading all sheets at the same time.
I am not familiar enough with the Excel object model to know if it is even possible with Excel to fetch data from multiple sheets at the same time.

추가 답변 (1개)

Sergio Yanez-Pagans
Sergio Yanez-Pagans 2021년 7월 9일
Using the Import Data option in the Home tab of MATLAB might be the easiest thing to you assuming you don't have tons of sheets in your Excel file.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by