Working with Excel inside Python

[AleydisGP at gmail.com]

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 <wlfr... at ix.netcom.com> wrote:
> On 7 Jan 2007 17:06:10 -0800, "John Machin" <sjmac... at lexicon.net>
> 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
>         wlfr... at ix.netcom.com             wulfr... at bestiaria.com
>                 HTTP://wlfraed.home.netcom.com/
>         (Bestiaria Support Staff:               web-a... at bestiaria.com)
>                 HTTP://www.bestiaria.com/