how to select a spreadsheet cell from one column only

1 次查看（过去 30 天）

显示更早的评论

Leonardo Wayne 2016-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/276330-how-to-select-a-spreadsheet-cell-from-one-column-only

评论： dpb 2016-3-31

I need the syntax for freely selecting a single cell that is in Column A always. The cell is a single number like 540.

2 个评论
显示无隐藏无

Leonardo Wayne 2016-3-31

编辑：dpb 2016-3-31

在 MATLAB Online 中打开

for example

disp('please select the ID number first')
[num0,text0,both0] = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx',-1);

this interactively lets me pick the cell I want but doesn't limit me to choose from a single column, say I make a mistake and choose another column or another cell.

dpb 2016-3-31

Not a Matlab feature; pilot error is another problem.

Not expert enough to know if can protect a cell from being selected/read in Excel or not but it's an Excel, not a Matlab question. You could arbitrarily read column 'A:' from the spreadsheet and present only those results from which to choose instead of opening the spreadsheet itself. That would at least limit the damage.

请先登录，再进行评论。

请先登录，再回答此问题。