I have imported data into uitable in gui, but data are large and appear statement: Matlab is not responding. Is uitable appropriate for importing large files?

uitable() does not import data. uitable is for creating table structures in graphics. There is a table() data type which has various import routines including : is that the routine you are using? What kind of file are you importing the data from?

import data into matlab

Radoslav Vandzura 2015-10-7

编辑：Radoslav Vandzura 2015-10-7

I import .xls or .xlsx file. I have file with about 180 000 rows. After pressing push button in gui, data shoult be displayed in uitable...After that I want to analyze data.

Part of my code is: global strFilename

[num,txt,raw] = xlsread(strFilename)

set(handles.edit3, 'data', raw); -edit3 is tag of uitable in gui

Walter Roberson 2015-10-7

If you are using GUIDE then handles.edit3 would be the tag of a uicontrol('style','edit') rather than a uitable.

I just experimented with a uitable with 180000 rows and 1023 columns. Creating the uitable took only a fraction of a second; modifying it with new data was even faster, including the time to format the numbers into strings. It was faster than I could mentally measure.

The only notable delay I had in any of this, in the graphics part, was creating the initial figure. Creating the data with rand() was slower than any of the display.

Reading 180000 rows with xlsread() certainly could take time. You could put a tic/toc around the xlsread to get an idea of how long it takes.

Radoslav Vandzura 2015-10-9

And how can I set tag of uicontrol('style','edit')?....uitable I insert as an object uitable in guide....

Walter Roberson 2015-10-9

在 MATLAB Online 中打开

table_h = findobj(ancestor(hObject, 'figure'), 'type', 'uitable');
set(table_h, 'data', raw);

Unless you have more than one uitable.

Radoslav Vandzura 2015-10-9

编辑：Radoslav Vandzura 2015-10-9

And If I load data only into 1 uitable? I dont know what you mean more than 1 uitable....

Walter Roberson 2015-10-9

My suggested code is fine as long as you only have 1 uitable. The code would have problems if you had 2 or more uitable.

Radoslav Vandzura 2015-10-9

编辑：Radoslav Vandzura 2015-10-9

I already tried your suggested code but it doesnt work so good:( Somewhere is value NaN and there are not loaded all data of file. If I tried tic toc, result is t =168.4031....It takes very long time .....How can I do it faster? ....and when i want to use these data later..in data mining (data analyze)...how shoult I do it?....What do you think about datastore? ....Shout I try it?....Thank you very much for your answer....I appreciate your help...:)

Walter Roberson 2015-10-9

Which part did you measure with tic/toc ?

Please show your code.

Radoslav Vandzura 2015-10-10

编辑：Walter Roberson 2015-10-10

在 MATLAB Online 中打开

My code is:

function pushbutton1_Callback(hObject, eventdata, handles)
set(handles.text2,'String','');
global strFilename
          % ask user which file to import - road to file
          FilterSet = {'*.xl??','Excel Files (*.xl?)';...
              '*.csv','CSV Files (*.csv)';...
              '*.*','All Files (.)'};
          [FileName,PathName] = ...
              uigetfile(FilterSet,'Select Excel file to import');
   if ~isequal(FileName,0)        
                  strFilename = fullfile(PathName,FileName);
                  set(handles.text2,'String',strFilename)
              else
                set(handles.text2,'String','Incorrect loading!!!')
          end
function pushbutton2_Callback(hObject, eventdata, handles)
global strFilename
tic;
[num,txt,raw] = xlsread(strFilename)
t=toc
table_h = findobj(ancestor(hObject, 'figure'), 'type', 'uitable');
set(table_h, 'data', raw);

Walter Roberson 2015-10-10

You are measuring the speed of the xlsread(), not the speed of sending the data to the uitable.

You might be able to get faster xlsread() using http://www.mathworks.com/matlabcentral/fileexchange/22365-function-for-faster-data-transfer-matlab-%3C-%3E-excel

Radoslav Vandzura 2015-10-11

And if i want to get faster sending the data to the uitable, should i use the same way?

Walter Roberson 2015-10-11

My tests indicate that once you have the data read in, then creating the uitable() is under 0.03 seconds.

The file exchange contribution linked to above is only for reading the data in possibly faster. It has nothing to do with uitable() . uitable is a graphics feature entirely unrelated to any particular method of getting data from a file.

Radoslav Vandzura 2015-10-12

编辑：Radoslav Vandzura 2015-10-12

According link above I don´t know to do it :( Is there any method how to use it, any steps? How I insert this file xlsread1.m into my code? Should I use all the code?...

Walter Roberson 2015-10-12

在 MATLAB Online 中打开

Download the .zip file. Unzip it in to a new directory. Use pathtool to add the directory to your MATLAB path. Then in your code, where you currently have xlsread() put in

Excel = actxserver ('Excel.Application');
File = strFilename;
if ~exist(File, 'file')
  Excel.Quit
  Excel.delete
  clear Excel 
  error('file does not exist: %s', File);
end
Excel.Workbooks.Open(File);
assignin('base', 'Excel', Excel);
[num, txt, raw] = xlsread1(strFilename);
Excel.ActiveWorkbook.Save;
Excel.Quit
Excel.delete
clear Excel

If you are reading multiple files then some of this does not need to be repeated each time.

Note: I seldom run MS Windows (it frustrates me immensely), so this is not tested.

Radoslav Vandzura 2015-10-13

It is going good, I am so thankful, thank you very much for your help....;-)

Radoslav Vandzura 2015-11-7

And how can I get these data for analyze? (access to data)

Walter Roberson 2015-11-8

You can get() the Data property from the uitable handle.

Radoslav Vandzura 2015-11-8

And what is code of this?

I wrote this:

function pushbutton4_Callback(hObject, eventdata, handles)

waitfor(gcf)

x=0.5;

waitbar(x+0.3,h,'Data are saving')

pause(3)

get(handles.edit3,'data')%edit3 is tag for uitable object in guide

x=0.8;

waitbar(x+0.2,h,'Data are succesfully saved')

pause(2)

close(h)

But it doesnt work.

import data into matlab

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

18 个评论
显示 16更早的评论隐藏 16更早的评论

更多回答（0 个）

类别

标签

Community Treasure Hunt

import data into matlab

0 个评论 显示 -2更早的评论 隐藏 -2更早的评论

采纳的回答

18 个评论 显示 16更早的评论 隐藏 16更早的评论

更多回答（0 个）

类别

标签

另请参阅

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

18 个评论
显示 16更早的评论隐藏 16更早的评论