MS Excel, sometimes we got some task which is time taking and require good manual effort. To automate these kind of task and making our life easy there are two ways - 1) Macro - MS Excel provide Macros functionality to automate tasks in Excel. We can record our steps ( go to 'View' tab then Record Macro) then run this recorded Macro to perform the same task again. It will be good if you know VB Scripting to write general algorithm Macros. 2) Python - Python has excel API xlrd and xlwt for reading and writing Excel documents. Python is easy to use and you can code easily as compare to VB Scripting. With Python Excel API we can easily automate the excel task. I) Setup the environment - Download Eclipse - Eclipse is a Intergrated Development Environment in which we can easily write code. Download Python . Download Python Excel API . Open Eclipse - then go to Help menu bar - then Eclipse Marketplace Search pydev and install the Pydev - Python IDE for Eclipse Afte
