reading from excel by page

Question

Kris Lawson 2016-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/275177-reading-from-excel-by-page

评论： Kris Lawson 2016-3-26

Hello,

I'm looking to read from 1 excel document that consists of 3 pages of information(EMG) each consisting of 19col. 44000rows

I would like to know how to manipulate cells from seperate pages as well as how to cross corolate between pages, if at all possible. (would it be easier from a text file?)

Any help would be greatly appreciated.

1st time Matlab user.

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

Kris Lawson 2016-3-24

yes the information is 3 sheets for pre, post, and follow up. The data on each sheet has the same number of input fields rows/col.

KSSV 2016-3-24

using xlsread you can read the sheet you want.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

John BG 2016-3-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/275177-reading-from-excel-by-page#answer_214833

在 MATLAB Online 中打开

Kris

the page of a Microsoft Excel workbook can be directly addressed in the command xlsread:

filename='wrkbk1.xlsx'
read_sheet = 3
read_range = 'B2:C3'
[num,txt,raw]=xlsread(filename,read_sheet,read_range)

the extracted data is in num. Once whatever data in MATLAB you can process it with any operation you want, and once ready you can store it back in same or another Excel spread sheet with command xlswrite that has format

xlswrite(file,A,write_sheet,write_range)

If you find this answer of any help solving your question, please click on the thumbs-up vote link,

thanks in advance

John

jgb2012@sky.com

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

Kris Lawson 2016-3-24

Thanks for the response, John.

Would these two files be the same? filename=' wrkbk1.xlsx' read_sheet = 3 read_range = 'B2:C3' [num,txt,raw]=xlsread( filename,read_sheet,read_range)

And could you break this code down for me by variable: [num,txt,raw]=xlsread( filename,read_sheet,read_range)

Also after thinking this project through I think what I am looking for is a nested loop for 6 variables to process all 44001 rows of data per column. This way I can reuse the code for future projects and just replace the file names.

Six variables for individual cells:

P1a = Page 1 odd columns (A1-A44000, C1-C44000, E1-E44000, etc)
P1b = Page 1 even columns (B1-B44000, D1-D44000, F1-F44000, etc)
P2a = Page 2 odd columns
P2b = Page 2 even columns
P3a = Page 3 odd columns
P3b = Page 3 even columns

I would add a line of "0" at the end of each column as to establish an internal reset:

filename='wrkbk1.xlsx'read_sheet = 1read = 'A1'*

Start Loop

If P1a~= 0

xlsread

filename='wrkbk1.xlsx'read_sheet = 1read = 'A1'* (=P1a need code to +1 down the coulmn each loop pass)

*filename='wrkbk1.xlsx' read_sheet = 2 read = 'A1' (=P2a)

do my calculations

Then I use the xlswrite function you mentioned.

xlswrite (Results,A)

I am probably missing a nested loop here to continue calculating without constantly overwritting Cell A1 with the results

If P1a = 0

filename='wrkbk1.xlsx'read_sheet = 1read = 'A1'* (Pa1= need code to move +2 coulmn & reset cell to 1)

Else Restart Loop

END Loop

Again, I might be biting off more then I can chew with this program at the moment, but any help with this type of code would be greatly appreciated.

Thank You again, John, for your quick reply.

John BG 2016-3-26

在 MATLAB Online 中打开

for instance, there is an excel file called ShipData.xlsx that looks like this:

When reading with

[num,txt,raw]=xlsread('ShipData.xlsx','ShipData','A1:B10')

you get the following

num =
    9180401.00
    9376036.00
    9354868.00
    9573000.00
    9179397.00
    9293545.00
    9707792.00
    8972194.00
    9148142.00
txt = 
    'Register Number'    'IMO Number'
    '12536D'             ''          
    '14968W'             ''          
    '16283B'             ''          
    '15126T'             ''          
    '06466F'             ''          
    '04893V'             ''          
    '22394T'             ''          
    '962G60'             ''          
    '39Y697'             ''          
raw = 
    'Register Number'    'IMO Number'
    '12536D'             [9180401.00]
    '14968W'             [9376036.00]
    '16283B'             [9354868.00]
    '15126T'             [9573000.00]
    '06466F'             [9179397.00]
    '04893V'             [9293545.00]
    '22394T'             [9707792.00]
    '962G60'             [8972194.00]
    '39Y697'             [9148142.00]

the file name can be the same or a different file, it's up to you.

Hope it helps.

Regarding your design reasoning, i rather not go through it until you have a script that, working or crashing, is a concise start point for another question or comment.

John

jgb2012@sky.com

Kris Lawson 2016-3-26

Ok. Thank you very much for clearing that up for me.

I will post again when I have some code underway.

请先登录，再进行评论。

reading from excel by page

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

回答（1 个）

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

另请参阅

类别

标签

Community Treasure Hunt

reading from excel by page

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

回答（1 个）

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

另请参阅

类别

标签

Community Treasure Hunt

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

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