how to display excel data
显示 更早的评论
i have used this code but it only displays data against coloumn1 (if I enter any field from coloumn1 then it displays the whole Row of that). I want it, like if I enter data from second or any other coloumn then it should display the whole row of that too.
in = input('F');
[num,txt,raw] = xlsread('soil silt.csv');
p = strcmpi(in,raw(:,2));% Compare user input string with entries in the Excel sheet
rowNum = find(p==1)%Get Row number
tab = readtable('soil silt.csv'); % see doc for more options
tab(ismember(tab.(1), 'Stage 1'), :) % the row at which the input str matches the first table's column
回答（1 个）
Subhajyoti Halder
2023-6-28
编辑：Subhajyoti Halder
2023-6-28
Hi Aiman,
It is my understanding that it is required to display all the rows in the table, where any column matches with the input keyword.
Here, I have implemented the same using ‘readtable’ function ’ in MATLAB R2023a on a sample csv file.
In the below code, itis iterating over the rows and storing the row-indices of the table that have any column matching the given token.
in = 'Calcuta';
raw = readtable('sample_sheet.csv')
rowNum = [];
p=1;
for i=1:size(raw)
if ismember(in,raw{i,:})
rowNum(p)=i;
p=p+1;
end
end
tab = readtable('sample_sheet.csv');
% the row at which the input str matches the first table's column
tab(rowNum, :)
Note: For numerical value, use ‘ismember(in,raw(i,:))’.
For more details on the ’readtable’, kindly go through the following documentation
类别
在 帮助中心 和 File Exchange 中查找有关 Deep Learning Toolbox 的更多信息
2023-6-7
2023-6-28
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
