MATLAB Answers


How to analyze excell sheet with Multiple Tab

Asked by sriram shastry on 25 May 2019
Latest activity Commented on by Walter Roberson
on 30 May 2019
I want to analyze the excell sheet with multiple Tabs. please find the attachment

2 Answers

replace dot with '_' in file name
clc, clear
Month = 'Apr';
Year = 2015;
[Data, text, alldata] = xlsread('KP_Finance_FY2017-18_V1_17',[Month '-' num2str(Year)],'G3:G1000');


Sign in to comment.

Answer by sriram shastry on 29 May 2019

Concept :
I need to iterate all the Excell sheet tabs followed by data parse using string capture and values associated
Convert the cell into name and values (cellfunc)

  1 Comment

You can use xlsinfo to find all of the sheet names. That will give you a cell array of character vectors. You can process those in several ways. regexp() can often be useful in breaking apart cell array of character vectors.

Sign in to comment.