MATLAB How can I create a MATLAB function for importing data from an Excel table?

[Tina22]

Hi all,

I am trying to create a function in MATLAB for a table in Excel. Basically, I have to define a header (an array 34*1), waveform characteristics (that is an array 34*88), and finally data for the waveforms (that is a array 10001*88). Could you please help me on that??

Thanks

 

[Pythagorean]

You really need to give more details. Questions:

1)

What do you want in the header (34x1 array)?

a 34x1 array of characters will only hold 34 characters, so if you have 34 features to describe wave characteristics, you'll only be able to use one letter for each feature.

2)

I'm assuming these are meant to be two different tables (one with a text header above each column). Do they go on the same, separated by blank cells, or do they go on another sheet? Or am I totally misunderstanding your goal here?

 

[Tina22]

You are right. I would have explained more. Sorry about that.

1) I would like to have some characteristics in the header like rise time, fall time,etc. Isn't it possible?

2) Basically, There are not two different tables. Let me explain more. Header is not above each column, it is the first vertical column in the table, that's why I define the array like 34*1.

There should not be anything above each column. I have the data right in front of the header and that's all for the top part of the table.

For the bottom part (waveforms data), it starts exactly after the top part finishes (no blank cell between). That's why the array (10001*88) for that has the same columns like the waveform char data (34*88).

I am trying to write MATLAB codes for that (basically a function) to easily access the data, instead of using Excel.

Your help is greatly appreciated.

 

[viscousflow]

why don't you use excel and let MATLAB read it?

 

[Tina22]

because I have to do it in the way I explained above.