To Extract data from the .csv or .xlsx file and out it ti the Matlab Base workspace for Simulink to access it and read data from it

1 次查看（过去 30 天）

Ashwini More 2020-1-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/499398-to-extract-data-from-the-csv-or-xlsx-file-and-out-it-ti-the-matlab-base-workspace-for-simulink-to

评论： Ashwini More 2020-1-16

I have written code for extracting file from user and then read data from that file. I can extract file from this code but not able to read the data because it is showing error as (Undefined function or variable 'excelread_activex')

Code is given below for your reference:

handle = msgbox('Select Unladen Logged Data file');
pause(2);
if ishandle(handle)
     delete(handle);
 end
 clear handle;
global pathname sim_time pathname_saved 
if pathname~=0
    [filename, pathname]= uigetfile({'*.csv'},'Load Data File',pathname);
    if pathname==0;pathname=pathname_saved;end
    if pathname~=0;pathname_saved=pathname;end
else
     [filename, pathname]= uigetfile({'*.csv';'*.xlsx'},'Load Data File');pathname_saved=pathname;
end
if filename~=0
            h_wait=waitbar(0,'Reading Logged Data........');
            if filename~=0
                    ResultFile=[pathname filename]
                    raw = excelread_activex([pathname,'\',filename]);
                    waitbar(.5,h_wait);

3 个评论
显示 1更早的评论隐藏 1更早的评论

Ankit 2020-1-15

编辑：Ankit 2020-1-15

here you can find one similar solution to your problem:

https://de.mathworks.com/matlabcentral/answers/479081-how-to-import-excel-data-in-matlab-gui

You can also use "assignin" command to save the variables to workspace:

https://de.mathworks.com/help/matlab/ref/assignin.html

Ashwini More 2020-1-16

Thank you for the solution!!

I only find the way to open the file with GUI. but I am not able to read data from it and further development is I want to remove specific rows from it. can you please suggest solution to it.

请先登录，再进行评论。

请先登录，再回答此问题。