topic Re: call Excel SpreadSheet using OLE and set format = text in Application Development and Automation Discussions

call Excel SpreadSheet using OLE and set format = text

Former Member — Tue, 20 Mar 2007 08:26:01 GMT

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 — Tue, 20 Mar 2007 08:44:43 GMT

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

Former Member — Tue, 20 Mar 2007 09:45:18 GMT

Did U use

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

Former Member — Sun, 19 Jun 2011 03:17:18 GMT

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