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 日間)
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 件のコメント
Ankit
Ankit 2020 年 1 月 15 日
編集済み: Ankit 2020 年 1 月 15 日
here you can find one similar solution to your problem:
You can also use "assignin" command to save the variables to workspace:
Ashwini  More
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.

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeWhos についてさらに検索

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by