Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pictures in Excel + Other Questions
Message
 
 
To
22/05/2002 09:26:15
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00659872
Message ID:
00659901
Views:
26
>Is there any way using Ole automation to add
>a picture to an excel worksheet.

There certainly is. Try:
LogoFile = _SAMPLES + "TasTrade\Bitmaps\TTradeSm.bmp"
oSheet.Shapes.AddPicture(LogoFile, .T., .T., 32, 32, 72, 72)
The parameters are: Filename, LinkToPicture, SaveWithDocument, Left, Top, Width, Height. A little playing is required when you’re trying to determine the width and height of the graphic. None of the parameters are optional, so you need to know the width and height of any graphic you’re adding.

>Also, is there a way of changing a cells indent value.

Yes there is a way. Look at the AddIndent() and InsertIndent() methods and the IndentLevel property. These all belong to the Range object (a Selection object is a special form of the Range object). I haven't used these, so I can't offer much advice other than looking in the Help file.

>Finally, where can I find a list of Ole commands for VFP. the help
>file is very limited.

I agree that the Help files are limited--when you're getting started. Actually, they are pretty good if you know what you're looking for, but an alphabetical list of properties, methods, and objects doesn't seem at all helpful if you're looking for "Group of Cells" instead of "Range." So Tamar Granor and I wrote a book, Microsoft Office Automation with Visual FoxPro, available from www.hentzenwerke.com. It's available as a CHM file, so if you purchase it from Hentzenwerke, you'll be able to download the CHM within a few business hours. You don't have to wait for the paper book to get across the ocean! (In fact, you can purchase just the CHM version).

Hope this helps!

- della
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform