Re: How to create .WK1 files?
Posted in 1994
Topics: General Discussion
In <2sb5po$ah9@emory.mathcs.emory.edu> finleyd@vrinet.com (Dave Finley) writes: >Stu Miller wrote .... (stuf removed) >One of the requests from our clients is for data files (reports) from the >system in Lotus .WK1 format. Remembering that I am not a programmer but >an adept hacker, is it possible to create a report that writes output to a >file in .WK1 format or does this require some fancy C application(s)? >Any advice or leads to pursue on this would be greatly appreciated. >TIA, >Stu (stuff added that was posted in a follow-up) I neglected to mention that the application uses Informix for DOS v4.10SE as a backend. >-- >Stu and all, >You don't have to go to C. Instead, you should consider the following >options: >1.- Put your output into a "simple" comma-delimited ASCII file. Lotus (and >most) spreadsheets can "easily" import this format. >2.- Use a Microsoft Access front-end, and attach your database to it. >MS-Access provides a "TransferSpreadsheet" action as part of Access Basic. >Use this to export your attached data to an appropriate spreadsheet file. >3.- If you prefer, you might also look into Visual Basic. You might be able >to provide something a little smaller and faster, but at the expense of >more development time. >Hope this advice is helpful. >Dave Finley >finleyd@vrinet.com Thanks to Dave and others for your responses. However, (don't you hate those) our clients are demanding native format .WK1 files to be loaded into another application that is not a spreadsheet or database application. Apparently they aren't _comfortable_ (read into this as much as you see fit) having to take an ASCII file into Lotus or Excel, parsing and then saving as .WK1 files. That said, how tough is it to create a native format Lotus .WK1 file? If any of you have tried to do this please let me know if you have had any success. Also, if you know of any source code (ACE or C) available to do this I'd be greatful for any info. Thanks again, Stu