Python Script for opening excels files saving, closing them

This is the place for queries that don't fit in any of the other categories.

Python Script for opening excels files saving, closing them

Postby djasper6 » Wed Jan 29, 2014 7:22 pm

Hi,

I am new to learning python and wanted to know how to open excel files from python, save them and close them at the same time everyday which is midnight. Any help would be greatly appreciated.


I will be using 8 different workbooks that I want to open at the same time and save all of them and close them.



Thank you.
Last edited by stranac on Wed Jan 29, 2014 7:34 pm, edited 1 time in total.
Reason: First post lock.
djasper6
 
Posts: 1
Joined: Wed Jan 29, 2014 7:14 pm

Re: Python Script for opening excels files saving, closing t

Postby Marbelous » Thu Jan 30, 2014 3:38 pm

I would start here: http://www.python-excel.org/

I personally avoid MS file formats so I've never worked with Excel through Python but a Google for "Python Excel" returned many links to modules and tutorials. Openpyxl and xlswriter are also available.
Marbelous
 
Posts: 97
Joined: Fri May 31, 2013 8:12 pm

Re: Python Script for opening excels files saving, closing t

Postby Yoriz » Thu Jan 30, 2014 6:02 pm

You dont mention altering the excel files in anyway, if you just want to open them and save to a different location/name, just copy the file
Code: Select all
import shutil
shutil.copy(src, dst)

shutil.copy
New Users, Read This
Join the #python-forum IRC channel on irc.freenode.net!
Spam topic disapproval technician
Windows7, Python 2.7.4., WxPython 2.9.5.0., some Python 3.3
User avatar
Yoriz
 
Posts: 721
Joined: Fri Feb 08, 2013 1:35 am
Location: UK


Return to General Coding Help

Who is online

Users browsing this forum: Bing [Bot] and 10 guests