>>>>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_editorsI 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