separate tab in excel sheet

[Former Member]

Hi All,

I am writing a report to get data related to material master and download it to excel sheet.

While downloading I need to use a separate tab in excel sheet for each area of the material master, for example, a tab for Basic 1, Basic 2, MRP1, etc…

Regards,

Gaurav

[Former Member]

Hi All,

I am writing a report to get data related to material master and download it to excel sheet.

While downloading I need to use a separate tab in excel sheet for each area of the material master, for example, a tab for Basic 1, Basic 2, MRP1, etc…

Regards,

Gaurav

[Former Member]

Hi, tyr this..

while u r priting ur output give space between the feilds.

for example....... u can write ur required field inplace of "text-000".

WRITE:/2 text-002

16 text-003 ,

25 text-004 ,

40 text-005 ,

60 text-006 ,

75 text-007 ,

90 text-008 ,

100 text-009 .

[Former Member]

Hi Kavitha,

I dont want to generate list output.

I need to download records to excel file having separate sheet for each column.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

Yuor requirement cannot be achieved by simple FM like GUI_DOWNLOAD.

U need to go for OLE DB coding.

In which you can create as many worksheet as u need, u can color the cells, bold , underline infact all feature which u have in MS-EXCEL.

Regards,

Vaibhav Modi.