abap怎么读取excel的第二个sheet？

[q262067995]

abap怎么读取excel的第二个sheet？
知道的请教下哈。。

[goddy123]

CALL METHOD OF excelobj " wbook object
'Workbooks' = wbookobj.

CALL METHOD OF wbookobj 'Open' = wbookobj
EXPORTING #1 = 'c:\list.xls'.
CALL METHOD OF wbookobj " wsheet object
'Worksheets' = wsheetobj EXPORTING #1 = c_sheet.
CALL METHOD OF wsheetobj 'Activate'.

这里面的c_sheet内容就是要读取的sheet的名称

[衣犹未尽]

CALL METHOD OF P_EXCEL 'WORKSHEETS' = P_ACTV_SHHET
EXPORTING #1 = L_CNT.
GET PROPERTY OF P_ACTV_SHHET 'NAME' = L_TMPNAME.
CALL METHOD OF P_ACTV_SHHET 'ACTIVATE'.
你要读取第二个，l_cnt 为2就可以，我一般读取多个sheet就是这么读的

[suntanlei]

刚确认过了,ok!
受教了!