[melbourne-pug] Excel spreadsheet munging under Linux. Limits?

[Simon Cropper]

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
> <bianca.rachel.gibson at gmail.com> wrote:
>> What exactly are you using it for? Is csv an option?
>>
>> Bianca
>>
>> _______________________________________________
>> melbourne-pug mailing list
>> melbourne-pug at python.org
>> https://mail.python.org/mailman/listinfo/melbourne-pug
>>
> _______________________________________________
> melbourne-pug mailing list
> melbourne-pug at python.org
> 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