call Excel SpreadSheet using OLE and set format = text

[Former Member]

Hi All,

I am working on an object, where I need to call Excel SpreadSheet using OLE.

In SpreadSheet, I need to show data as text (Without Excel Internal Modifications).

i.e

if i pass 03/2007 as month in excel, it should show 01/2007 not jan-07.

I am trying to use the code as below.

call method of cell 'SET_FORMAT' = text.

set property of text 'CATEGORY' = 4.

this code is not giving me desired output.

Is there any other method i can call? or property I can set?

can somebody pls send me a document with list of all formattiong methods and properties. I will really appreciate the help.

Regards,

Hardik

[Former Member]

Hi All,

I am working on an object, where I need to call Excel SpreadSheet using OLE.

In SpreadSheet, I need to show data as text (Without Excel Internal Modifications).

i.e

if i pass 03/2007 as month in excel, it should show 01/2007 not jan-07.

I am trying to use the code as below.

call method of cell 'SET_FORMAT' = text.

set property of text 'CATEGORY' = 4.

this code is not giving me desired output.

Is there any other method i can call? or property I can set?

can somebody pls send me a document with list of all formattiong methods and properties. I will really appreciate the help.

Regards,

Hardik

[Former Member]

can so ebody pl help........

[Former Member]

Did U use

SET PROPERTY OF cell 'NumberFormat' = '@'.

[Former Member]

Hi, you should concatenate the character ( ' ) into your text, example

CONCATENATE '''' text INTO text.

Then print the variable Text into excel and you will see the format as Text,

Thanks and regards.

David Carballido

PD: Sry for my bad English