General information
Category:
COM/DCOM and OLE Automation
>I have an application in which I use Word as the destination of all reports. All data ends up in tables in Word docs. I started out transferring data from VFP to Word through Excel, which had acceptable performance, but need to change that, as Word appears to need Excel (or at least some tools) to import the Excel spreadsheet. I cannot require the user to have Excel.
>
>Do you have a quick way of transferring lots of data from VFP into Word tables? I have tried a cell by cell approach but it takes an unacceptable amount of time. I need a generic routine that does not require knowing the table layout, and allows any ordinary data type. Delimited files don't work either, as VFP adds quotation marks around character data and Word does not strip them out. Can XML be used in any way?
>
>Thanks for the help,
>Isabel
Isabel --
Here's another twist.
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
Previous
Next
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