topic Re: separate tab in excel sheet in Application Development and Automation Discussions

separate tab in excel sheet

Former Member — Fri, 25 Jan 2008 05:08:51 GMT

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

Re: separate tab in excel sheet

Former Member — Fri, 25 Jan 2008 05:19:43 GMT

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 .

Re: separate tab in excel sheet

Former Member — Fri, 25 Jan 2008 05:23:51 GMT

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

Re: separate tab in excel sheet

Former Member — Fri, 25 Jan 2008 06:36:17 GMT

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.