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
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 CenterFile Exchange에서 Workspace Variables and MAT-Files에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by