Difference between revisions of "Ruby and Windows Automation"
Jump to navigation
Jump to search
PeterHarding (talk | contribs) |
PeterHarding (talk | contribs) |
||
| Line 44: | Line 44: | ||
=MSDN Links= | =MSDN Links= | ||
==Constants== | |||
* [http://msdn.microsoft.com/en-us/library/bb241279.aspx Excel] | |||
* [http://msdn.microsoft.com/en-us/library/bb238158.aspx Word] | |||
* [http://msdn.microsoft.com/en-us/library/bb251061.aspx PowerPoint] | |||
[[Category:Ruby]] | [[Category:Ruby]] | ||
[[Category:Microsoft Office Automation]] | [[Category:Microsoft Office Automation]] | ||
Revision as of 09:43, 12 March 2010
References
Functions
Miscellaneous function in the API...
excel = WIN32OLE.new('Excel.Application')
book = excel.Workbooks.Add()
sheet = book.Worksheets(1)
excel.Visible = true
range = sheet.Range('A1').Resize(data.size, data.first.size)
range.Value = data
sheet.Rows(1).AutoFilter()
iTunes
require 'win32ole'
app = WIN32OLE.new('iTunes.Application')
data = []
app.LibraryPlaylist.Tracks.each do |track|
if not track.Podcast
data << [track.Artist, track.Year, track.Album, track.Name]
end
end
data.sort!
data.insert(0, ['ARTIST', 'YEAR', 'ALBUM', 'NAME'])