General information
Category:
COM/DCOM and OLE Automation
>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only