How to analyze excell sheet with Multiple Tab

2019 5 25
2 个回答
更新时间：2021 8 20
4 次查看（30 天）

回答（2 个）

Sajeer Modavan
Sajeer Modavan 2019-5-25
编辑：Sajeer Modavan 2019-5-25

0 个投票

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');
Life is Wonderful
Life is Wonderful 2019-5-29

0 个投票

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 个评论
显示 3更早的评论 隐藏 3更早的评论

Walter Roberson
Walter Roberson 2019-5-30
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.
Life is Wonderful
Life is Wonderful 2019-11-1
Can I use Data Import for all tabs in the *.xlsx and join them ?
Walter Roberson
Walter Roberson 2019-11-2
编辑：Walter Roberson 2019-11-2
No. importdata() does not give any way to specify the worksheet to import. You will need to use readtable() or readmatrix() or xlsread() .
Life is Wonderful
Life is Wonderful 2019-11-2
I have Imported the data . Please find the attachment
Walter Roberson
Walter Roberson 2019-11-2
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, '

此问题已关闭。

标签

关闭：

MATLAB Answer Bot
MATLAB Answer Bot
2021-8-20

Community Treasure Hunt

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

Start Hunting!

Translated by