WrapExcel is a wrapper library that specializes in the operation of Excel win32ole.
Ruby
Latest commit 84302a6 Mar 15, 2013 @tomiacannondale Update version
Failed to load latest commit information.
lib
spec
.gitignore
Gemfile
Guardfile Update Guardfile for new version of guard Nov 10, 2012
LICENSE
README.ja.rdoc
README.rdoc Fix README Mar 15, 2013
Rakefile
wrap_excel.gemspec

README.rdoc

WrapExcel

Description

WrapExcel is a to wrap the win32ole, and easy to use Excel operations with ruby.

Requirements

  • ruby 1.9.2 or higher (platform is windows)

Install

gem install wrap_excel

Usage

access book

Read with block.

WrapExcel::Book.open('./sample.xls') do |book|
  # do something
end

Read without block.

book = WrapExcel::Book.open('./sample.xls')
book.close

Options are the following.

read_only

boolean(default true)

displayalerts

boolean(default false)

visible

boolean(default false)

access sheet

Sheet object can access with Book#[] method.

sheet = book[0]

Access with sheet name.

book['Sheet1']

access row or column

Sheet object is included enumerable. Use Sheet#each_column or Sheet#each_row or Sheet#each method.

sheet.each do |cell|
  # do something with cell
  # read every row every column
end

sheet.each_row do |row|
  # do something with row_range
end

sheet.each_column do |column_range|
  # do something with column_range
end

access cell

Read from sheet object.

sheet[0, 0]  => first cell.

Read from range object

row_range[0]  => first cell in row_range
column_range[1] => second cell in column_range

write excel

Can save an existing file.

WrapExcel::Book.open('./sample.xls', :read_only => false) do |book|
  # do something
  book.save
end

or

book = WrapExcel::Book.open('./sample.xls', :read_only => false)
book.save
book.close

Can save an another file name.

WrapExcel::Book.open('./sample.xls', :read_only => false) do |book|
  # do something
  book.save './another_file.xls'
end

Save to another_file.xls

Can not save new file.

Want to do more things

All WrapExcel object include win32ole instance. If you want to do something that not provide a function, you can use win32ole methods.

Support

Report issues and feature requests to github Issues. github.com/tomiacannondale/wrap_excel/issues

Collaborate

Please pull request on github.

Author

tomi tomiacannondale@gmail.com

License

MIT License. For more imformation, please see LICENSE.