Ruby wrapper to the Confluence API

The Confluence Wiki system has an XML RPC api for easy scripting access. There is also a wrapper available to make the calls to this api even more easy.

http://confluence.atlassian.com/display/CONFEXT/Confluence4r

From Ruby to Excel

Here is a little snippet showing how you can open up an Excel document in Ruby to read or update data in the spreadsheet.

# Require the WIN32OLE library
require 'win32ole'

# Create an instance of the Excel application object
xl = WIN32OLE.new('Excel.Application')

# Make Excel visible if you want to see a little live action
#xl.Visible = 1

xl.workbooks.open("C:\\Documents and Settings\\MyName\\Desktop\\MyFile.xlsx")

for row in 2..148

url = xl.Cells(row, 2).Value
xl.Cells(row, 3).Value = Version

end

# Quit Excel
xl.Quit