Using Ruby and Win32OLE to manipulate Excel

In today’s business world, most data is presented in Excel format. However, working with Excel by hand can quickly become mind numbingly boring when it is reduced to repetitive actions such as copy and pasting, formatting, etc. This time would be much better on tasks with higher added value.

The solution? Automate the boring and repetitive parts!

As the title suggests, in this post we will touch upon automating certain tasks within Excel using Ruby, a powerful scripting language. But before you’ll be able to join in the fun, make sure to install Ruby.

Here are the various parts we’ll cover:

Hopefully, this will help you start freeing up some of your valuable time by automating the boring, repetitive tasks, so you can focus on the important things!

This entry was posted in Automation, Ruby and tagged , , . Bookmark the permalink.