EvilZone

Programming and Scripting => Projects and Discussion => : shimomura March 13, 2014, 06:39:39 AM

: Excel Script
: shimomura March 13, 2014, 06:39:39 AM

I was looking to write a script that reads an excel sheet, edits the sheet, and writes it back to the sheet or even better a whole new sheet.


For Example: If len(column b1) = 1: delete b1 and replace with c1.  (lol)


I know it's not a simple or straight forward task so I'm willing to look into any language that is the most efficient for the task.   


Any general leads would be nice, I'll do the rest of the research.

: Re: Excel Script
: RedBullAddicted March 13, 2014, 07:00:31 AM

As far as I know those excel macros and all of the automation stuff is done in vba.
http://msdn.microsoft.com/en-us/library/ee814737%28v=office.14%29.aspx

Guess you can get the most out of it cause it is deeply integrated into excel. If you are looking for a more "general purpose" way have a look at the csv format. There are a lot of libraries for many languages that deal with csv files.

Cheers,
RBA

: Re: Excel Script
: Kulverstukas March 13, 2014, 07:11:24 AM

I am sure Python has some sweet MS Office integration libs.

: Re: Excel Script
: vezzy March 13, 2014, 02:23:00 PM

: Kulverstukas  March 13, 2014, 07:11:24 AM

I am sure Python has some sweet MS Office integration libs.

Yes, third party: http://www.python-excel.org/ (http://www.python-excel.org/)

: Re: Excel Script
: Zesh March 13, 2014, 06:45:29 PM

Use VBA. I did quite a bit of programming with VBA using Excel back in school but since I don't have MS Office installed I can't really help you there but just google some examples.