Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert a Lotus 123 file (.wks) file to Excel (.xls or .
Message
 
To
19/06/2009 14:38:14
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 9.0
OS:
Vista
Miscellaneous
Thread ID:
01407044
Message ID:
01407255
Views:
26
>>>>Hi
>>>>
>>>>I have to automate a process in which I receive a Lotus 123 file (.wks) file to an Excel format (.xls or .csv).
>>>>
>>>>I cannot rely on using Lotus and/or Excel as neither will be installed on the server where the process will run (and this is not an option).
>>>>
>>>>Does anybody knows a magic trick?
>>>
>>>Not sure that a .wks is Lotus - is it actually a Microsoft Works file?
>>>
>>>If it is Lotus you want to convert, a quick Web search found this: http://www.processtext.com/abclotus.html
>>
>>It doesn't seems to support .wks files and no batch mode neither! Too bad.
>
>Well, in the second line of the description it does claim both batch mode and command-line operation:
>
>"The software supports a batch conversion, a run from command line, more than 50 languages. Batch conversion ability allows you to convert a unlimited number of Lotus 1-2-3 files at a time."
>
>As for .wks, they have a free trial download, you could test it to see if it works. IIRC .wks is the oldest file type, .wk1, .wk2 etc. are newer, so if a converter can do the newer ones it should be able to do .wks too (?)
>
>It looks like there might be some GNU/open source conversion utility: http://en.wikipedia.org/wiki/Lotus_1-2-3#Freely_available_wk4.2C_wk3_File_viewer.2C_converter_and_editors

I have already found GNumeric, tested it and it is working. The client doesn't waht to use anything with a GNU GPL license (propably does not understand exactly what it is).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Reply
Map
View

Click here to load this message in the networking platform