OLE

[Former Member]

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

[ThomasZloch]

Please don't post entire specs here, get started and come back with specific questions if necessary. Search for existing answers before posting. Use descriptive subject lines when posting.

Thread locked.

Thomas