MATLAB Answers

0

How to analyze excell sheet with Multiple Tab

Asked by Matlab on 25 May 2019
Latest activity Commented on by Walter Roberson
on 2 Nov 2019
Hi
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');

  0 Comments

Sign in to comment.


Answer by Matlab 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)
-Thanks
Sriram

  5 Comments

No. importdata() does not give any way to specify the worksheet to import. You will need to use readtable() or readmatrix() or xlsread() .
I have Imported the data . Please find the attachment
Are you asking for a table join operation such as described at https://www.mathworks.com/help/matlab/ref/table.join.html ? If so then is there a particular variable that you want to join on?
The variable names are not completely consistent between the files.
'Month, AmountCollected, Expenses, Balance, CashinHand, CashinBankMonthBegining, CashDepositedtoBank, BankWithdrawalthrucheque, CashinBankMonthEnd, BalanceCashinhandafterbankdeposit, , , , , , , , '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amount, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, PendingduesNote1TowardsApartmentNameAutoMaticwatercontrollerAmo, VarName9, Date, Descriptions, Amountcashtransaction, VarName13, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total'
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '
'Sl, Name, Flat, EmailID, OwnerContactDetails, TenentContactDetails, AmontReceived, VarName8, Date, Descriptions, Amount, VarName12, Date1, AmountInBank, DepositedAmount, WithdrawalAmount, Total, '

Sign in to comment.