Windows OLE Automation in Ruby - Revision history

PeterHarding at 23:22, 11 March 2010

2010-03-11T23:22:06Z

← Older revision		Revision as of 09:22, 12 March 2010
Line 142:		Line 142:

	[[Category:Ruby]]		[[Category:Ruby]]
			[[Category:Microsoft Office Automation]]
	[[Category:OLE]]		[[Category:OLE]]

PeterHarding at 04:26, 29 August 2009

2009-08-29T04:26:50Z

@@ Line 1: / Line 1: @@
 =Examples=
-==Simple 1==
+==Simple Spreadsheet 1==
 <pre>
@@ Line 54: / Line 54: @@
 </pre>
-==Simple 2==
+==Simple Spreadsheet 2==
 Drop some data into Sheet11 and delete the other sheets.
@@ Line 88: / Line 88: @@
 excel.quit
 </pre>
 [[Category:Ruby]]
 [[Category:OLE]]

PeterHarding at 03:52, 29 August 2009

2009-08-29T03:52:15Z

@@ Line 1: / Line 1: @@
 =Examples=
 <pre>
@@ Line 50: / Line 52: @@
 # ...and collect it.
 GC.start
 </pre>
 [[Category:Ruby]]
 [[Category:OLE]]

PeterHarding at 03:43, 29 August 2009

2009-08-29T03:43:51Z

← Older revision		Revision as of 13:43, 29 August 2009
Line 6:		Line 6:
	# Purpose: Exercise a few simple operations...		# Purpose: Exercise a few simple operations...
	#		#
	#~~-------------~~--------------------------------------------------------------------------		#--------------------------------------------------------------------------

	require 'win32ole'		require 'win32ole'

PeterHarding at 03:43, 29 August 2009

2009-08-29T03:43:12Z

← Older revision		Revision as of 13:43, 29 August 2009
Line 3:		Line 3:
	<pre>		<pre>
	#!/usr/bin/env ruby		#!/usr/bin/env ruby
			#
			# Purpose: Exercise a few simple operations...
			#
			#---------------------------------------------------------------------------------------

	require 'win32ole'		require 'win32ole'

PeterHarding at 03:42, 29 August 2009

2009-08-29T03:42:26Z

← Older revision		Revision as of 13:42, 29 August 2009
Line 20:		Line 20:

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

			sheet.Name = "Directions"

	sheet.Range('A1:D1').value = ['North','South','East','West'];		sheet.Range('A1:D1').value = ['North','South','East','West'];

PeterHarding: moved WinOLE Automation in Runy to Windows OLE Automation in Ruby: Typographical...

2009-08-29T03:39:34Z

moved WinOLE Automation in Runy to Windows OLE Automation in Ruby: Typographical...

← Older revision	Revision as of 13:39, 29 August 2009
(No difference)

PeterHarding at 03:39, 29 August 2009

2009-08-29T03:39:04Z

← Older revision		Revision as of 13:39, 29 August 2009
Line 47:		Line 47:

	[[Category:Ruby]]		[[Category:Ruby]]
	[[Category:~~WinOLE~~]]		[[Category:OLE]]

PeterHarding: Created page with '=Examples=

 #!/usr/bin/env ruby  require 'win32ole'  # You can, of course, iterate over the Workbooks collection: #  #    for workbook in excel.Workbooks #       # ...code....'

2009-08-29T03:36:21Z

Created page with '=Examples= <pre> #!/usr/bin/env ruby require 'win32ole' # You can, of course, iterate over the Workbooks collection: # # for workbook in excel.Workbooks # # ...code....'

New page

=Examples=

<pre>
#!/usr/bin/env ruby

require 'win32ole'

# You can, of course, iterate over the Workbooks collection:
#
# for workbook in excel.Workbooks
# # ...code...
# end

excel = WIN32OLE.new('Excel.Application')

excel.visible = TRUE

book = excel.Workbooks.Add();
# book = excel.ActiveWorkbook

sheet = book.Worksheets(1);

sheet.Range('A1:D1').value = ['North','South','East','West'];

book.SaveAs('C:\temp\Workbook.xlsx')

book.Close

book = excel.Workbooks.Open('C:\temp\Workbook.xlsx')

sheet = book.Worksheets(1);

sheet.setproperty('Cells', 3, 2, 10) # => The B1 cell value is 10.

book.Save

book.Close

excel.quit

# lose the reference so that excel can be garbage collected
excel = nil

# ...and collect it.
GC.start
</pre>

[[Category:Ruby]]
[[Category:WinOLE]]