Hi All,
I am having an excel sheet with pre-defined format which our business team specified, what i need to do is i have to write a script which need to pick values from database and update specified cells in excel sheet..
can any one please help me in this regard..
I am able to pull the values from database using script but i am unable to do updation of excel sheet which i never worked..
Please let me know if you need more information
Thanks,
Balanarendra Muppala
Export your database tables into a tab separated text file, then launch excel, go to the help screen, search for "import", which will show you in details how to import these tables to the excel template
Good luck
It may be possible to write an excel macro in VBA to import the values and and then launch the script from python and then call the python from your shell script.
OpenOffice.org has some information that might be helpful here:
Accessing the VBA API from other languages.
You could use Active States Perl on Windows to do this. Here is a link if you want to check it out:
ActivePerl FAQ - Using OLE with Perl