Loading data into matlab gui from excel

Hello,

can you advise me how can I load data into gui into spreadsheet format?

Thank you for your answer.

Answer 1

[Image Analyst]

You can use guide and put a grid ((uitable) onto the figure. Then use set() to send your data to it:

set(handles.uitable1, 'data', yourData);

[Image Analyst]

Radoslav's "Answer" move to a comment here:

And how can I customize size of table to numbers of columns when I will always load different numbers of columns?

[Image Analyst]

I believe the size of the table adjusts to the data you pass it. If not, there's a property you can set that will change the number of rows and columns.

[Radoslav Vandzura]

There is empty place...on the right side.....What property? Any command?

[Walter Roberson]

You can set the ColumnWidth property

Note: there is no direct method of automatically resizing the column widths when the size of the control is changed. Within the last couple of days someone posted a link to some information from Yair on how to do this by calling Java.

[Image Analyst]

You can width the columns with the column width property. You can bring in the right side of the table control using the 'Position' property to set the size.

[Radoslav Vandzura]

Could you advise me with my problem with loading string data.....when I want to load string data into uitable....in these cells are value 'NaN'. How can I resolve it?:) Thank you very much for your answer...