Dear Pythonistas,
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.
Hence I was thinking on the lines of
XL_Handle=win32com.client.Dispatch('Excel.Application')
WorkSpace=XL_Handle.Workbooks.Open('C:somepath\template.xls')
Fill=WorkSpace.Worksheets(1)
i=2
while(i<31):
Fill.Cells(i,1).Value=(attendance[i]) ## assuming 30 people, This array
has P for present and A for Absent
i=i+1
WorkSpace.Save()
XL_Handle.Workbooks.Close()
This would give me a data for one day.
My question is there a way i can put data for the 2nd, 3rd, 4th..... etc..
till 31st on already saved xls file?
In other words in Fill.Cells(i,1) can i make it Fill.Cells(i,2) tommorrow
:):)
Thanks in advance
Warm Regards,
Abhijeet
My question here is
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
