on 06-18-2004 3:22 PM
Hi all,
Does anyone have experience with the interface of i_oi_spreadsheet?
We are using it to send some data to an Excel spreadsheet which has three sheets. Some of the data has to go to the second sheet. So we do something like
DATA: HANDLE TYPE REF TO I_OI_SPREADSHEET.
call method handle->insert_range_dim
exporting name = 'zfibudgetstk2'
top = 10
left = 2
rows = rows_number
columns = columns_number
SHEETNAME = 'Omslagsleutels'
importing
error = error
retcode = retcode.
where 'Omslagsleutels' is the name we gave to the second sheet.
But it doesn't work and the data keeps showing up on the first sheet...
Thanks in advance for any help,
ioana
Hello Ioana,
call the method SELECT_SHEET to switch to the second sheet. Then insert you ranges.
Regards,
Marc
SAP NetWeaver RIG, US BI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.