Excel Script

[shimomura]

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.

[RedBullAddicted]

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

[Kulverstukas]

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

[vezzy]

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

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

[Zesh]

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.