Open and modify Excel

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

Open and modify Excel

Postby georgenwigwe » Tue Mar 25, 2014 4:15 pm

I need help in writing a simple python script to open a currently open excel file
go in the excel and change all the lower cases to upper cases
then save the excel and close.

the simpler the script the better please ... i am a newbie
Last edited by stranac on Tue Mar 25, 2014 5:19 pm, edited 1 time in total.
Reason: First post lock.
georgenwigwe
 
Posts: 1
Joined: Tue Mar 25, 2014 4:11 pm

Re: Open and modify Excel

Postby stranac » Tue Mar 25, 2014 5:22 pm

We won't write the script for you, at least not for free...
If you want help, show us what you've tried, and what problems you're having.

If you want someone to do this for you, let me know, and I'll move this to the Jobs section.
Friendship is magic!

R.I.P. Tracy M. You will be missed.
User avatar
stranac
 
Posts: 1112
Joined: Thu Feb 07, 2013 3:42 pm

Re: Open and modify Excel

Postby Marbelous » Wed Mar 26, 2014 1:42 pm

This is very trivial to do for a basic text file or CSV/TSV file but Excel is a proprietary format that requires special modules and much more advanced code (although the modules do most of the hard work for you :D ). Do a search for python excel and pick the package you want to use and start learning it.
Marbelous
 
Posts: 127
Joined: Fri May 31, 2013 8:12 pm


Return to General Coding Help

Who is online

Users browsing this forum: cnitin, W3C [Linkcheck] and 3 guests