Aug-19-2017, 05:33 PM
(Aug-03-2017, 01:30 AM)Gbry71 Wrote: I am REALLY new to python. I have used it to open some web pages and used eventghost to take it from there. I have an Excel workbook that has sheets in it named for months of the year. I need to write script that will extract this month and last months sheet and email it to several people automatically. I am fine with changing the sheet names manually if need be, or even finding a way to email the file without python if need be, but can I save a file with only the sheets I need? (example: now it is August, can I save sheets July and August to a file on my laptop?)
I use the xlxswriter module for all my excel work in python http://xlsxwriter.readthedocs.io/
Admittedly I have only used it to create spreadsheets with my data. It is easy to use and the documentation is well done. Like you I'm new to python only been using for 4 weeks.
For emailing your newly created spreadsheet I use the module smtplib https://docs.python.org/3/library/smtplib.html