Read excel file with number and text
이전 댓글 표시
Hello,
I want to load an excel file (shared in attachments) which has numeric and text 'values' in it (text cells are also really important).
I tried using both readtable and xlsread but I never managed to replicate exactly the excel table in matlab (usually the text rows were NaN).
Here is my code.
datapath = '/…/';
d = dir(datapath);
nd = length(dir);
files=dir(fullfile(datapath,'*.xlsx'));
for n=2
file=fullfile(datapath,files(n).name);
int=readtable(file,"ReadVariableNames",true,"VariableNamingRule","preserve");
end
Thanks for your help,
Marine
채택된 답변
Table variables cannot contain a mix of numbers and text. In order to preserve the data, we must import each variable as text. detectImportOptions provides more advanced control over how data are read.
opts = detectImportOptions("BH_Model.xlsx",VariableNamesRange="A1:BO1",VariableNamingRule="preserve");
opts.VariableTypes = repmat("string",1,numel(opts.VariableTypes));
Table variables must all have the same number of rows, so extra rows are filled with missing strings.
readtable("BH_Model.xlsx",opts)
추가 답변 (0개)
카테고리
도움말 센터 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
