MATLAB Answers

How to analyze excell sheet with Multiple Tab

1 view (last 30 days)

Answers (2)

Mohamed Sajeer Ibn Azad Modavan
Edited: Mohamed Sajeer Ibn Azad Modavan on 25 May 2019
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.


Jogger
Jogger 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

Show 2 older comments
Walter Roberson
Walter Roberson on 2 Nov 2019
No. importdata() does not give any way to specify the worksheet to import. You will need to use readtable() or readmatrix() or xlsread() .
Jogger
Jogger on 2 Nov 2019
I have Imported the data . Please find the attachment
Walter Roberson
Walter Roberson on 2 Nov 2019
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.

Community Treasure Hunt

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

Start Hunting!