Tag Archives: ruby

Win32OLE and Ruby: working with cells and data

This post is part of a series. If you can’t understand what is detailed below, or can’t find the information you’re looking for, take a look at the index page. As explained previously, each Worksheet object Win32OLE uses contains many … Continue reading

Posted in Automation, Ruby | Tagged , , | 5 Comments

Win32OLE and Ruby: formatting worksheets

This post is part of a series. If you can’t understand what is detailed below, or can’t find the information you’re looking for, take a look at the index page. Now that we’ve crunched numbers and otherwise manipulated the data … Continue reading

Posted in Automation, Ruby | Tagged , , | Comments Off on Win32OLE and Ruby: formatting worksheets

Win32OLE and Ruby: working with worksheets

This post is part of a series. If you can’t understand what is detailed below, or can’t find the information you’re looking for, take a look at the index page. First things first Naturally, before you can use Win32OLE, you’ll … Continue reading

Posted in Automation, Ruby | Tagged , , | 4 Comments

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 … Continue reading

Posted in Automation, Ruby | Tagged , , | Comments Off on Using Ruby and Win32OLE to manipulate Excel