Stack Overflow
Stack Overflow

Questions tagged [xlsread]

MATLAB uses a function called xlsread to read Microsoft Excel files (spreadsheet).

uses a function called xlsread to read files (spreadsheet).

69 questions
2
votes
1 answer

Octave - Excel - Xlsread reads Nan instead of text

The Universities spread sheat in Excel include: ID & University Name 0 Mechanical Engineering 1 Civil Engineering filename = 'test.xlsx'; sheet = 'Universities'; xlRange = 'A2:B31'; UniversityNames = xlsread(filename,sheet,xlRange); but…
user768199
  • 25
  • 2
  • 6
2
votes
3 answers

How can I increase the speed of this xlsread for loop?

I have made a script which contains a for loop selecting columns from 533 different excel files and places them into matrices so that they can be compared, however the process is taking too long (it ran for 3 hours yesterday and wasn't even halfway…
R Thompson
  • 353
  • 3
  • 15
2
votes
3 answers

Does the xlsread function in MATLAB require Excel?

I have two computers with the same MATLAB code and same Excel file (.csv format). The code only works on the machine that has Excel. I can't think of any other differences. Does a computer need Excel for xlsread to work? The error I'm getting is an…
Dan
  • 474
  • 1
  • 7
  • 16
2
votes
2 answers

Improve speed of reading data from excel to matlab

I have (at the time) five coloumns in Excel which I need to read and store into Matlab variables. I currently use the following…
ROLF
  • 284
  • 2
  • 14
2
votes
1 answer

xlsread does not work in Octave

Hope someone can help me here, cause I've tried everything recommended in other threads online. I am running octave on Ubuntu, and trying to use the xlsread command. More specifically I am running the following [num, txt]=xlsread('GLD'); And I am…
claushojmark
  • 27
  • 1
  • 5
2
votes
1 answer

dynamic column resizing in Matlab based on excel inputs

I want to read in some data from excel into Matlab say a 3x10 matrix. I need to distinguish whether the some cells are empty or blank in the read data. If empty, delete the row, if zero leave the matrix unchanged. I am facing two problems with this:…
Mia
  • 171
  • 1
  • 12
2
votes
1 answer

Why is xlsread returning empty?

I'm trying to read some data stored in a .xlsx file into MATLAB. However, using xlsread returns an empty data set. data = xlsread('myFile.xlsx'); The sheet name is the standard 'Sheet1', so I know it's not looking for the wrong sheet. I even…
Doresoom
  • 7,398
  • 14
  • 47
  • 61
1
vote
1 answer

MATLAB's xlsread gives different data than shown by Excel - hidden sheets

I want to use xlsread in MATLAB R2017b to read from an externally supplied data file. Usually, this works fine for me. However, in this case I get data I can't find in the .xls file and I don't know what happened. Here is screenshot of the…
Paul Paulsen
  • 355
  • 4
  • 18
1
vote
2 answers

Read excel file and assign each coulmn a variable in MATLAB

I am having a simple problem while reading excel data which contains strings, long string, and numbers. Now I need to make each column (I have 11 here) to define separate variables of 1 column vector so that I can plot in MATLAB against each other…
aguntuk
  • 127
  • 9
1
vote
1 answer

DateConverter does not support default String to 'Date' conversion. N.B. Re-configure Converter or use alternative implementation

I am reading an .xlsx file which contain columns like Name, Id , Date(11/28/2017) and few more. I created one .xml file "cancellation.xml" to map my excel cells. After that I am reading the excel file using these lines of codes. Resource configFile…
Muddassir Rahman
  • 976
  • 1
  • 9
  • 20
1
vote
1 answer

Error using xlsread and csvread

I have a folder with many .csv files. I need to load one file at at time and perform some operations. I tried loading files in a loop using the csvread and xlsread command but it does not work. My files are in a .csv format but csvread does not read…
Prasanth
  • 11
  • 1
  • 5
1
vote
2 answers

xlsread in Matlab returns NaN even there is no data in Excel

I use xlsread to read a xlsx file. I expect the rawdata will return a 34x3 cell array. [raw_num raw_txt rawdata]=xlsread('file.xlsx'); The raw_num and raw_txt return correct value, 34x1 cell array and 34x2 cell array. However, when I check rawdata,…
chshiu
  • 25
  • 5
1
vote
2 answers

Using disp function to display values

Data.xlsx is an excel file containing the data for 156 students. From cell 4 of the excel file, the 1st Student Number is displayed and if you increment by 7, you have the 2nd Student Number and so on up until the last cell 1094. F =…
SB998
  • 13
  • 5
1
vote
2 answers

matlab lose response when use xlsread reading a large spreadsheet

I am trying to use xlsread functioin to read spreadsheets of 6000x2700 (xlsx file). I have two questions: First, when I use something like [num,txt,~]=xlsread(input_file,input_sheet,'A1:CYY6596') Matlab keeps showing 'busy' and lose response (while…
Cognitive Easer
  • 11
  • 2
1
vote
0 answers

xlsread error - Undefined function 'biffread' for input arguments of type 'char'

For one of my Matlab routines, I receive the following error message when reading an xls file with Matlab 2012b: Undefined function 'biffread' for input arguments of type 'char'. Error in xlsread (line 71). biffvector = biffread(filename); The…
kanimbla
  • 858
  • 1
  • 9
  • 23
1
2 3 4 5