Skip to Content
0
Former Member
Apr 12, 2010 at 02:58 PM

OLE

41 Views

Hi All,

I am having one requirement i.e Generate Excel Using OLE.

My Requirement is

1 ) Get the Excel file from Presentation Server.

2) compare the excel sheet data by Posting area TFK033D-BUBER.

3) If the data matches than add the table TFK033D fields with existing data to the excel sheet with one status column for data matches or not.

e.g

On selection screen there are two fields

a) Posting area (TFK033D-BUBER)

b) Input File (rlgrap-filename)

Input file contain k1,k2k3,k4,k5,k6,k7,k8,f1,f2,f3,f4,f5,f6 data

than we have to compare this data with table TFK033D fileds k1,k2k3,k4,k5,k6,k7,k8,f1,f2,f3,f4,f5,f6.

If data matches than we have to generate Excel sheet with following fields

k1,k2k3,k4,k5,k6,k7,k8,f1,f2,f3,f4,f5,f6,SAP,k1,k2k3,k4,k5,k6,k7,k8,f1,f2,f3,f4,f5,f6,STATUS

4) SAP Field column is to divide the excel sheet data & table fields data.

5) STATUS Field shows data matches or not if data matches than it will be YES if not than it will be NO

6) All the field Label in the excels sheet should be in Color.

If anybody help me this than it will be great for me.

Thanks in Advance

Parag