您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

import data into matlab

1 次查看（过去 30 天）

显示更早的评论

Radoslav Vandzura 2015-10-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab

评论： Radoslav Vandzura 2015-11-8

采纳的回答： Walter Roberson

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?

采纳的回答

Walter Roberson 2015-10-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#answer_195112

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#answer_195112

编辑：Walter Roberson 2015-10-7

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 readtable: is that the routine you are using? What kind of file are you importing the data from?

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_314708

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_314708

编辑：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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_314720

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_314720

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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315013

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315013

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

Walter Roberson 2015-10-9

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315016

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315016

在 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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315019

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315019

编辑：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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315027

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315027

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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315152

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315152

编辑：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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315174

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315174

Which part did you measure with tic/toc ?

Please show your code.

Radoslav Vandzura 2015-10-10

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315237

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315237

编辑：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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315295

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315295

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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315447

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315447

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

Walter Roberson 2015-10-11

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315483

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315483

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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315714

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315714

编辑：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

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315788

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/247302-import-data-into-matlab#comment_315788

在 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