How to analyze excell sheet with Multiple Tab

Question

Life is Wonderful 2019-5-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/463944-how-to-analyze-excell-sheet-with-multiple-tab

关闭： MATLAB Answer Bot 2021-8-20

KP_Finance_FY2017-18_V1.17.xlsx

Hi

I want to analyze the excell sheet with multiple Tabs. please find the attachment

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

per isakson 2019-5-25

See TUTORIAL: how to ask a question (on Answers) and get a fast answer

此问题已关闭。

Answer 1

Sajeer Modavan 2019-5-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/463944-how-to-analyze-excell-sheet-with-multiple-tab#answer_376554

编辑：Sajeer Modavan 2019-5-25

在 MATLAB Online 中打开

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

Answer 2

Life is Wonderful 2019-5-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/463944-how-to-analyze-excell-sheet-with-multiple-tab#answer_377036

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更早的评论

Life is Wonderful 2019-11-2

Import_2019Data.zip

I have Imported the data . Please find the attachment

Walter Roberson 2019-11-2

在 MATLAB Online 中打开

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

How to analyze excell sheet with Multiple Tab

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

回答（2 个）

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

5 个评论
显示 3更早的评论隐藏 3更早的评论

另请参阅

标签

Community Treasure Hunt

How to analyze excell sheet with Multiple Tab

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

回答（2 个）

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

5 个评论 显示 3更早的评论隐藏 3更早的评论

另请参阅

标签

Community Treasure Hunt

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

5 个评论
显示 3更早的评论隐藏 3更早的评论