i have loaded .xls file but only numeric values are only imported, character are not imported in it
4 次查看(过去 30 天)
显示 更早的评论
i have loaded .xls file but only numeric values are only imported, character are not imported in it
0 个评论
回答(1 个)
David Verrelli
2017-12-21
编辑:Guillaume
2017-12-21
Hello, Pavithra.
You have not explained which method you used to "load" the ".xls" file, but I am guessing you might have used the xlsread command to open a Microsoft Excel spreadsheet, and furthermore that you used the syntax:
num = xlsread(filename)
As described in the documentation for xlsread, this will read "the first worksheet in the Microsoft® Excel® spreadsheet workbook named filename and returns the numeric data in a matrix." [emphasis added]
So, if that is the case, what you might want to try instead is the syntax:
[num, txt, raw] = xlsread(filename)
for which two additional variables are output from the function (or 'loaded' in your phrasing), namely txt and raw. The variable txt will contain the text fields in the form of a cell array, while raw will contain a mixture of numeric and text data, also in the form of a cell array.
—DIV
1 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!