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
0
votes
0 answers

Reading Realtime Data Into Matlab, then Saving and Realtime Plotting

I am currently trying to achieve the following: Read real-time, changing, data into Matlab(R2016a), from Excel(2016), saving this information and plotting it while it updates in real time. I am currently using vba to record the data into excel,…
TonyP
  • 3
  • 3
0
votes
1 answer

xlsread [num] discarding NaN

I'm trying to write a script to read a text column from an Excel file, checking the content, and then writing the content of the cells of another column(numeric) into other excel files. function [ output_args ] = export3( filename,cellranges…
napoleoninrags
  • 1
0
votes
1 answer

Read specific portions of an excel file based on string values in MATLAB

I have an excel file and I need to read it based on string values in the 4th column. I have written the following but it does not work properly: [num,txt,raw] = xlsread('Coordinates','Centerville'); zn={}; ctr=0; for i = 3:size(raw,1) tf =…
RezAm
  • 548
  • 2
  • 6
  • 20
0
votes
1 answer

stop matlab from trying to read "~$" temporary excel files

I have a loop that reads tables from several excel files in a folder. However I get the following error: Unable to open file 'C:\MATLAB\Data\fish\~$volume022017.xlsx' as a workbook. Check that the file exists, read access is available, and the…
Mary
  • 788
  • 6
  • 19
  • 43
0
votes
3 answers

Importing xls file into an all-strings cell-array

I'm trying to Import an xls file which has numeric as well as string data in it. Now I want the Output to be a cell-array consisting of strings only. I used [numeric,text,raw]=xlsread('myFile.xls'); to read the file. Now I'm looking for a way to…
Max
  • 1,471
  • 15
  • 37
0
votes
1 answer

xlsread and xlswrite troubles in MATLAB

I'm trying to write a script that loads an excel file and writes 10 sub-file either into 10 separate file or separate sheets.Im new to MATLAB and I've been running into some trouble. Need to figure a way to load the file and only access A1:B1000 on…
learnmore
  • 1
  • 1
  • 1
0
votes
1 answer

Structure array assigning

I have a 1x5 structure array called Game with two fields i.e. Game(5) = struct(Points, Scorers); Now, I also have a cell-array (5x2 cell array) (imported from xlsread - so its all in cell-array form). pts = [1 2;3 4;5 6;7 8;9…
Agnel
  • 11
  • 3
0
votes
1 answer

How do I subtract two arrays of cells in Matlab

I am trying to get some variables and numbers out from an Excel table using Matlab. The variables below named "diffZ_trial1-4" should be calculated by the difference between two columns (between "start" and "finish"). However I get the error:…
Spica
  • 127
  • 2
  • 10
0
votes
1 answer

reading hexadecimal data in matlab

I am trying to read accelerometer data from a csv file in matlab using xlsread with [num text raw] .However,the raw field only gives [NaN] instead of the text and character data that I am expecting.How can this be rectified? Any other ways to read…
Nrithya Catz
  • 1
0
votes
1 answer

Octave: xlsread function undefined + causes octave crash

I'm new to this, so I'll try to explain clearly. I'm using Octave (4.x) to process data and I want to import an Excel file. Excel is installed on my laptop as well. [num,txt,raw] = xlsread(input.rootdir); When the function is called, the following…
LodeBosmans
  • 1
  • 1
  • 3
0
votes
0 answers

Extract data from to connected Excel files, as if one is function and the other its parameter values

My question has 2 parts. Part 1: I have 3 Excel files each with multiple sheets. I have loaded all files with sheets into the matlab using a small code. The files are loaded in a structured form. i.e. One main structure and 3 files as a seperate…
Ahsan
  • 15
  • 4
0
votes
1 answer

using xlsread in matlab to loop through all .xls files in a folder

I'm writing a script that needs to loop through all the .xls files in a folder and pull data from specific cells. I think xlsread is capable of this, but I keep getting an error that reads: Matlab:xlsread:filenotfound Here is the basic structure…
S. Reaves
  • 35
  • 7
0
votes
1 answer

Opening all sheets of a spreadsheet by single call of xlsread in MATLAB

We can extract specific sheet using this function in MATLAB: out = xlsread(filename,sheet); How we can extract more than one sheet using single call of this function? I don't want use a loop and read the the file again and again for extracting…
Eghbal
  • 3,892
  • 13
  • 51
  • 112
0
votes
1 answer

How to read a specific range of several excel files in MATLAB

I want to write a program that is able to read a specific range of numerous excel files in a folder. because I need MATLAB to read from several excel files, I can't use a coding like this : xlsread('Report1',1,'k41') Is it possible to modify below…
Pedram
  • 11
  • 4
0
votes
1 answer

Call and extract name of an excel sheet using the index of sheet in MATLAB

We can call a sheet using it's name or index by xlsread function like this: for i=1:100 file = xlsread(`filename.xlsx`,i) %% I want get name of the called sheet here (storing in cell array) end In this loop if want call and…
Eghbal
  • 3,892
  • 13
  • 51
  • 112
1 2
3
4 5