MATLAB uses a function called xlsread to read Microsoft Excel files (spreadsheet).
matlab uses a function called xlsread to read microsoft excel files (spreadsheet).
Questions tagged [xlsread]
69 questions
0
votes
2 answers
Does anyone know of a way to use a variable as the filename input into xlsread?
EDIT: I figured out the problem. claim was listed as a cell class. Used cell2mat to convert it to char, and the code worked. Thank you, everybody!
I have a string variable set to a file pathway/location. I would like to use this variable as the…
user2447846
- 49
- 5
-1
votes
1 answer
Secifying a common range for xlsread function in Matlab
I am trying to figure out how to specify a common range for xlsread() function in matlab.
Usually I use n=xlsread('filename','#sheet','A1:A10'), but I have quite a bit of data in the same sheet and I'd like to know if I can specify it with one…
-1
votes
1 answer
Displaying imported date with data
I need to display an imported date on the legend for a figure, I'm importing a number of different values that correspond to different dates. However the legend just displays 'Data1', 'Data2' etc. I'm not sure how to go about having the date matched…
Scott
- 61
- 7
-1
votes
2 answers
Importing data with engineering notation into Matlab
I've got a .xls file and I want to import it into Matlab by xlsread function..I get NaNs for numbers with engineering notation..like I get NaNs for 15.252 B or 1.25 M
Any suggestions?
Update: I can use [num,txt,raw] = xlsread('...') and the raw one…
MDBX
- 13
- 4
-1
votes
1 answer
MATLAB xlsread's cell range changing on each loop
I would like to incorporate an xlsread instruction into a loop running over a list of different years. My intention is that at every loop the cell range changes, in order to import data for the respective year. I would like the cell range to move to…
Adriana LE
- 139
- 2
- 9
-1
votes
1 answer
How to plot an excel file in matlab
Assume that I imported a 703*778 excel file into matlab workspace as a .mat file. Now,say I want to plot these data excluding the datas from two particular rows,say 250th & 500th row.The excel data is purely numerical.Here is the code that I…
user3382202
- 1
- 1
- 2
-2
votes
1 answer
How can i list all the files in a folder with a specific name in matlab?
I have been making a loop that assign Mx names for 121 different files in a folder.
allFiles = dir( '*.xls''String' );
allNames = { allFiles.name };
for ii = 1:length(allNames) M(ii) = xlsread(allFiles(1i));
end
Trouble is that there is no…
chemicaluser3195825
- 29
- 1
- 8
-2
votes
1 answer
xlsread function with very small number matlab
I want to use xlsread function in matlab to import very small data like 10E-13. But it always shows 0 in vector 'num'. I want to read the exact number and export it.
So, does anyone know how to increase the accuracy or precision?
Thank you in…
David Jiang
- 17
- 1
-3
votes
1 answer
Basic Steps in reading Excel files into matlab
>> [NUM,TXT,RAW]=xlsread('C:\Users\Lincoln Wachn\Google Drive\Summer time\Book1')
??? Error using ==> xlsread at 219
XLSREAD unable to open file C:\Users\Lincoln Wachn\Google Drive\Summer
time\Book1.
File C:\Users\Lincoln Wachn\Google Drive\Summer…
