Skip to content

Instantly share code, notes, and snippets.

@mourdok
Created September 12, 2010 03:19
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mourdok/575805 to your computer and use it in GitHub Desktop.
Save mourdok/575805 to your computer and use it in GitHub Desktop.
Simple Xls to Html Converter
# To use this application, you need to install the following and specify RubyGem
# >> sudo gem install roo -v 1.3.11
# Which should return something like
# >> Successfully installed ruby-ole-1.2.10.1
# >> Successfully installed spreadsheet-0.6.4.1
# >> Successfully installed GData-0.0.4
# >> Successfully installed roo-1.3.11
# >> 4 gems installed
# So here we have our basic class
require "rubygems"
require "roo"
class SimpleXls2HtmlConverter
def initialize(file = "", default_sheet = 0)
@spreadsheet = Excel.new(file)
@spreadsheet.default_sheet = @spreadsheet.sheets[default_sheet]
end
def converts_column(column_name = "A")
lines_converted = []
(@spreadsheet.first_row).upto(@spreadsheet.last_row) do |line|
lines_converted << @spreadsheet.cell(column_name, line).to_s.gsub("\n", "<br/>")
end
lines_converted
end
def object
@spreadsheet
end
end
# And here the implementation of this class
spreadsheet = SimpleXls2HtmlConverter.new("base.xls")
puts spreadsheet.object.info
puts spreadsheet.converts_column
puts spreadsheet.converts_column("B")
puts spreadsheet.converts_column("C")
# More information
# Visit: http://github.com/hmcgowan/roo
@Fechin
Copy link

Fechin commented Jan 25, 2019

Thanks,I can use online tool to convert excel to html:https://tableconvert.com/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment