[python-win32] Append data to an already saved XL File

[abhijeet mahagaonkar]

Thanks Tim,

I guess i explored a bit on csv.
It turns out that works far too well for me.

Thanks,
-Abhijeet

On Wed, Aug 3, 2011 at 10:16 PM, Tim Roberts <timr at probo.com> wrote:

> abhijeet mahagaonkar wrote:
> >
> > I'm writing an attendance tracking application where i pull data daily
> > from a webpage.
> > I have to collate it daily and generate a report at the end of the month.
> >
> > I have a predefined XL template for the report.
> > I wanted to know if i can add (append) the data everyday to this file
> > and mail it at the end of the month.
>
> I'm not sure this is the way I would solve this problem.  If I were
> doing it, I'd tuck the data into a simple database, or a comma-separate
> text file, both of which are more easily manipulated in Python.  Then,
> at the end of the month, I could have a Python script generate the
> report as an HTML file or a PDF.  In my opinion, it's much easier to
> generate reports in HTML using Python than it is to manipulate an Excel
> spreadsheet.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20110804/33fe1234/attachment.html>