Ruby and Windows Automation - Revision history

PeterHarding at 06:26, 6 January 2011

2011-01-06T06:26:28Z

← Older revision		Revision as of 16:26, 6 January 2011
Line 169:		Line 169:
	[[Category:Microsoft Office Automation]]		[[Category:Microsoft Office Automation]]
	[[Category:OLE]]		[[Category:OLE]]
			[[Category:Windows Development]]

2010-03-11T23:59:54Z

Add a Picture

2010-03-11T23:21:44Z

← Older revision		Revision as of 09:21, 12 March 2010
Line 168:		Line 168:
	[[Category:Ruby]]		[[Category:Ruby]]
	[[Category:Microsoft Office Automation]]		[[Category:Microsoft Office Automation]]
			[[Category:OLE]]

2010-03-11T23:14:39Z

← Older revision		Revision as of 09:14, 12 March 2010
Line 4:		Line 4:
	* http://rubyonwindows.blogspot.com/2007/03/automating-excel-with-ruby-workbook.html		* http://rubyonwindows.blogspot.com/2007/03/automating-excel-with-ruby-workbook.html
	* http://rubyonwindows.blogspot.com/2007/04/automating-excel-with-ruby-worksheet.html		* http://rubyonwindows.blogspot.com/2007/04/automating-excel-with-ruby-worksheet.html
			* http://rubyonwindows.blogspot.com/2008/06/automating-excel-creating-charts.html
			* http://rubyonwindows.blogspot.com/2008/06/automating-excel-chart-axis-and-legend.html
	* http://rubyonwindows.blogspot.com/search/label/excel		* http://rubyonwindows.blogspot.com/search/label/excel

2010-03-11T23:11:14Z

← Older revision		Revision as of 09:11, 12 March 2010
Line 4:		Line 4:
	* http://rubyonwindows.blogspot.com/2007/03/automating-excel-with-ruby-workbook.html		* http://rubyonwindows.blogspot.com/2007/03/automating-excel-with-ruby-workbook.html
	* http://rubyonwindows.blogspot.com/2007/04/automating-excel-with-ruby-worksheet.html		* http://rubyonwindows.blogspot.com/2007/04/automating-excel-with-ruby-worksheet.html
			* http://rubyonwindows.blogspot.com/search/label/excel

	=Functions=		=Functions=

2010-03-11T23:10:57Z

← Older revision		Revision as of 09:10, 12 March 2010
Line 65:		Line 65:

	data.insert(0, ['ARTIST', 'YEAR', 'ALBUM', 'NAME'])		data.insert(0, ['ARTIST', 'YEAR', 'ALBUM', 'NAME'])
			</pre>

			==Add a Picture==

			<pre>
			require 'win32ole'

			excel = WIN32OLE.connect('Excel.Application')
			sheet = excel.ActiveSheet

			range = sheet .Range('C3:F5')

			pic = sheet .Shapes.AddPicture({
			'FileName' => 'C:\Temp\Image1.jpg',
			'LinkToFile' => false,
			'SaveWithDocument' => true,
			'Left' => range.Left,
			'Top' => range.Top,
			'Width' => range.Width,
			'Height' => range.Height
			})
	</pre>		</pre>

2010-03-11T23:08:48Z

← Older revision		Revision as of 09:08, 12 March 2010
Line 42:		Line 42:

	book.Worksheets(3).Copy(book.Worksheets(1))		book.Worksheets(3).Copy(book.Worksheets(1))

			sheet = book.ActiveSheet

	</pre>		</pre>

2010-03-11T23:08:09Z

← Older revision		Revision as of 09:08, 12 March 2010
Line 41:		Line 41:
	sheet.Delete		sheet.Delete

			book.Worksheets(3).Copy(book.Worksheets(1))

	</pre>		</pre>

2010-03-11T23:07:28Z

← Older revision		Revision as of 09:07, 12 March 2010
Line 2:		Line 2:

	* http://rubyonwindows.blogspot.com/		* http://rubyonwindows.blogspot.com/
			* http://rubyonwindows.blogspot.com/2007/03/automating-excel-with-ruby-workbook.html
			* http://rubyonwindows.blogspot.com/2007/04/automating-excel-with-ruby-worksheet.html

	=Functions=		=Functions=
Line 9:		Line 11:
	<pre>		<pre>
	excel = WIN32OLE.new('Excel.Application')		excel = WIN32OLE.new('Excel.Application')

			excel.DisplayAlerts = false
			excel.Visible = true

	book = excel.Workbooks.Add()		book = excel.Workbooks.Add()

	sheet = book.Worksheets(1)		sheet = book.Worksheets(1)

	~~excel.Visible = true~~

	range = sheet.Range('A1').Resize(data.size, data.first.size)		range = sheet.Range('A1').Resize(data.size, data.first.size)
Line 33:		Line 36:
	sheet = book.Worksheets(4)		sheet = book.Worksheets(4)
	sheet.Name = "XYZZY"		sheet.Name = "XYZZY"

			sheet.PrintOut

			sheet.Delete


	</pre>		</pre>

2010-03-11T23:04:53Z

← Older revision		Revision as of 09:04, 12 March 2010
Line 23:		Line 23:
	book.Worksheets(3).Move book.Worksheets(1)		book.Worksheets(3).Move book.Worksheets(1)

			excel.activeworkbook.save

			excel.sheets(idx).activate

			no_sheets = excel.sheets.count

			excel.workbooks.open("filename.xls")

			sheet = book.Worksheets(4)
			sheet.Name = "XYZZY"

	</pre>		</pre>