Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting Excel cell formatting
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01270483
Message ID:
01270501
Views:
15
If you wish, send to me Excel file. I will see whether I can help.
Regards

Yuri Rubinov

>Just a quickie ... I'm accessing an Excel object from VFP, and I want to check the cell formatting before retrieving the data. Is it number or text? However, all I ever seem to get is "General," even after I went and formatted a sequence of cells (A1, A2, etc) in the worksheet to different formats.
>
>oExcelObject=GETOBJECT(, "Excel.Application")
>FOR nRow = 1 TO 14
>   _cliptext = IIF(LEN(_cliptext)>0, ;
>      _cliptext+CHR(13), ;
>      '') ;
>      + oExcelObject.Range("A"+ALLTRIM(STR(nRow))).NumberFormat
>ENDFOR
>
Previous
Reply
Map
View

Click here to load this message in the networking platform