Query on spreadsheetimport options

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 日

0 投票

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

製品

リリース

R2019a

質問済み:

2019 年 10 月 31 日

回答済み:

2019 年 11 月 6 日

Community Treasure Hunt

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

Start Hunting!

Translated by