how to import an excel spreadsheet into matlab Solved

Question

Hello,please I would like to work on a multiple linear regression using Matlab but I don't know how to extract data from an Excel file and import it into Matlab. I used the xlsread function but it didn't work. Thank you for the help.

Sacabouffe · Accepted Answer

Hello  xlsread works very well. [num, txt, tab] = xlsread('file.xls'); * num is the matrix containing the values of all the numerical cells in the Excel table * text is a cell array of strings. Its cells are the strings from the cells of the Excel table * tab is a cell array whose cells are those of the Excel table  See you later -- Thought I heard a rumbling, calling to my name Two hundred million guns are loaded, Satan cries "Take aim!"

Char Snipeur · Answer

And if there are several tabs?

Otherwise, export your Excel file in a text format with separators of your choice and open it traditionally with Matlab.
--
Greetings! Before I believed, now I am certain.Jesus Christ
Char Sniper

Sacabouffe · Answer

Hello
If there are multiple tabs

for k=1:n [numk,txtk,tabk]=xlsread('file.xls',['Sheet',num2str(k)]); num{k}=numk; txt{:,:,k}=txtk; tab{:,:,k}=tabk; clear numk txtk tabk; end

Good afternoon
--
Thought I heard a rumbling, calling to my name
Two hundred million guns are loaded, Satan cries "Take aim!"

cybervictime · Answer

Hello,I'm not really strong in Matlab, I'm supposed to do a study specifically on the software, meaning I will need to import Excel data into the Matlab interface.Could you provide a simple example of this data import action?Otherwise, on my workstation, only Open Office is installed (so no Excel), would the function you mentioned be compatible with Open Office files as well?Thank you in advance!!

Batfly · Answer

Hello,

I'm bumping this topic because I also have Open Office installed:
- Can we read an xls file without having Excel installed? (because it doesn't seem to me that it is possible).
- Otherwise, how to read an ods file?

Thanks ^^

Shadow · Answer

Hello,  Normally, Open Office can create files with Microsoft extensions, so MATLAB should be able to read them in the same way.

How to import an excel spreadsheet into matlab

6 réponses

Texture issues in enshrouded

Canon mb5350 - cartridge replacement impossible

Command prompt disabled by admin...

Zoom blocked canon digital ixus 750

Vd-tech (sub-brand of which brand???)

Issue with my kodak easyshare device!

Échec du disque flexible (40)

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection