On 04/02/14 14:49, Javier Candeira wrote:
No, CSV is not an option. I need to generate an Excel that users will
run macros on. I can possibly (and hopefully) have a template that
already has the macros in it, and just load the new data on the
template every time a user hits the "download" button.
J
On Tue, Feb 4, 2014 at 2:41 PM, Bianca Gibson
<[email protected]> wrote:
What exactly are you using it for? Is csv an option?
Bianca
_______________________________________________
melbourne-pug mailing list
[email protected]
https://mail.python.org/mailman/listinfo/melbourne-pug
_______________________________________________
melbourne-pug mailing list
[email protected]
https://mail.python.org/mailman/listinfo/melbourne-pug
J,
This is a VBA problem not a python problem
Your template needs to eat something and whether it is an excel file or
a CSV is irrelevant. At some point a convert or import command needs to
get your data into your spreadsheet.
The only way python can do this is (i) through automation (e.g.
http://msdn.microsoft.com/en-us/library/ms178745%28v=vs.90%29.aspx), or
(2) by creating a Excel File of data with macros already inserted.
Otherwise python is only used to create the datafile and whether this is
CSV, dBase or Excel format is irrelevant as long as the process of
importing into the template can be automated.
--
Cheers Simon
Simon Cropper - Open Content Creator
Free and Open Source Software Workflow Guides
------------------------------------------------------------
Introduction http://www.fossworkflowguides.com
GIS Packages http://www.fossworkflowguides.com/gis
bash / Python http://www.fossworkflowguides.com/scripting
_______________________________________________
melbourne-pug mailing list
[email protected]
https://mail.python.org/mailman/listinfo/melbourne-pug
