Query on spreadsheetimport options

조회 수: 21 (최근 30일)
Amit Vaidya
Amit Vaidya 2019년 10월 31일
답변: Sai Sri Pathuri 2019년 11월 6일
In Spreadsheetimportoptions (in script not gui). How to assign opts.variablenames from excel row in script.

이 질문에 답변하려면 로그인하십시오.

답변 (1개)

Sai Sri Pathuri
Sai Sri Pathuri 2019년 11월 6일
You may use readcell function to read the excel sheet in the form of a cell array and assign the desired value from cell array to opts.VariableNames variable by proper indexing.
Refer the following link for readcell function documentation
https://www.mathworks.com/help/matlab/ref/readcell.html

카테고리

Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

제품


릴리스

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by