Sorry for my little knowledge on Python. Actually my knowledge is specific for automating geo-processing tasks within ESRI environment, but sometimes I need to automate some other tasks (like this one) which require more in-depth knowledge of this language. Lots of documentation are of no use when you don't know exactly what to look for or have a wrong idea of what to do. Thanks for the guidance.
On 8 ene, 02:21, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote: > On 7 Jan 2007 17:06:10 -0800, "John Machin" <[EMAIL PROTECTED]> > declaimed the following in comp.lang.python: > > > However I don't understand how a reasonable solution to the OP's > > requirement (translate a tab-separated file to a DBF file with a bit of > > slicing and dicing on the way) would have anything to do with .xls > > files, or Excel, or VB ... Only in that the original poster stated > > they were trying to > translate an Excel VBA "macro" into Python, and the malformed (for > Python) code appeared to be using Window's COM access to run all the > work via Excel (I presume via importing the TSV, performing the edits, > then exporting via some DBF compatible format -- ODBC?). > > I'd agree, however, that the specification of the task to be > performed does not, it would seem, require any of the clumsiness of > using Excel. Read the lines of the TSV file using proper specifications > to the Python CSV file handling module, edit the lines as needed, and > write them via an ODBC (or other) database adapter that generates the > desired DBF format... > -- > Wulfraed Dennis Lee Bieber KD6MOG > [EMAIL PROTECTED] [EMAIL PROTECTED] > HTTP://wlfraed.home.netcom.com/ > (Bestiaria Support Staff: [EMAIL PROTECTED]) > HTTP://www.bestiaria.com/ -- http://mail.python.org/mailman/listinfo/python-list