We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] Gui_Download export to excel delivering only one row in excel output

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Metsik
on May 28 at 12:55 AM 		Mark this reply as helpfulMark as helpful
Did you try to use OLE functions like "insert_one_table"?

Somethink like this:

data : ref_spr_sheet TYPE REF TO i_oi_spreadsheet,

CALL METHOD ref_spr_sheet->insert_range_dim
EXPORTING
name = 'SAP_range'
top = l_first_row
left = 1
rows = 1
no_flush = 'X'
columns = 1
IMPORTING
error = wa_tab_err.
APPEND wa_tab_err to tab_err.

CALL METHOD ref_spr_sheet->insert_one_table
EXPORTING
ddic_name = 'ZXLS_043_T'
data_table = it_xls[]
rangename = 'SAP_range'
wholetable = 'X'.

It should be work with Office 2007. At least it works with XP Office 2007.

---------------Original Message---------------
From: Adamsap
Sent: Monday, May 24, 2010 1:52 AM
Subject: Gui_Download export to excel delivering only one row in excel output

> Hello,
>
> I am using Vista Os with the SAP front end logon 710 and Office 2007. Also my company is using Ecc6.0 in the server.
>
> I am able to export the Itab data to excel but all the rows are on the first row in Excel.
> If i have 3 rows in ITAB then all the 3 rows are on the First row of Excel
>
> I have supplied these parameters
> filename = 'C:\ITAB2XLS.xls'
> FILETYPE = 'ASC'
> WRITE_FIELD_SEPARATOR = 'X'
> SHOW_TRANSFER_STATUS = 'X'
>
> tables
> data_tab = itab[]
> FIELDNAMES = headingTab[]
>
> Is anyone having the same issue like me ?
>
> Thanks.

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language