Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Quick Transfer of Losts of VFP Data to Word Table?
Message
From
12/10/2001 17:36:07
Isabel Cabanne
Hubbard Woods Software, Inc.
Winnetka, Illinois, United States
 
 
To
12/10/2001 15:09:16
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00567281
Message ID:
00568004
Views:
26
>>>Word, Excel and Powerpoint now use HTML as a "native" file format. MS' approach is to incorporate some header information in XML and CSS in a format they call Office HTML.
>>
>>>Simply generate an HTML document in VFP, then open that in Word. It's orders of magnitude faster than OLE automation.
>>
>>>I have some code to generate an HTML table from a cursor and can share that if you're interested.
>>
>>
>>Jay,
>>
>>Yes, I'm interested. Moving through HTML would also open the opportunity of letting the user have the data as HTML. I'd like to se the code.
>>
>>Thanks,
>>Isabel
>
>Isabel --
>
> I rewrote this to avoid HTML tags in the code -- so some of the defines and variables will look a little funny. The UT, for self-preservation, doesn't allow a number of tags to be embedded in messages. If you want, you can just join the concatenated expression into a single string literal for better readability on your end. I did a test run after the mods, but haven't gone through all permutations, so please keep that in mind in your use.
>
> There is a file in the library -- DBFtoHTML -- which offers some of the same functionality. The benefit of that routine is the handling of various letters used in European alphabets with length indicators.
>
> My target output for this is Word. I generate the HTM doc then open in Word and reformat the table for my purposes. So, table formatting is at a minimum and may not be optimal for your use. It would be straightforward to add HTML formatting tags for the table or table cells to customize for your purposes.
>
> Enjoy!
>
> Jay


Jay,

Thanks, I'll take a look at it. I've also updated my email address.

Isabel
Previous
Reply
Map
View

Click here to load this message in the networking platform