Info

This question is closed. Reopen it to edit or answer.

How to analyze excell sheet with Multiple Tab

1 view (last 30 days)
Jogger
Jogger on 25 May 2019
Closed: MATLAB Answer Bot on 20 Aug 2021
Hi
I want to analyze the excell sheet with multiple Tabs. please find the attachment

Answers (2)

Sajeer Modavan
Sajeer Modavan on 25 May 2019
Edited: Sajeer 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');

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
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, '

Community Treasure Hunt

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

Start Hunting!