i have loaded .xls file but only numeric values are only imported, character are not imported in it
9 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
i have loaded .xls file but only numeric values are only imported, character are not imported in it
0 Kommentare
Antworten (1)
David Verrelli
am 21 Dez. 2017
Bearbeitet: Guillaume
am 21 Dez. 2017
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 Kommentar
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!