From b20ad2247db8032af420096e6567497b834108bf Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Mon, 21 Nov 2011 23:51:52 +0900 Subject: moving example.rb into example dir and altering gemspec to point to github --- assets/example.rb | 83 ------------------------------------------------ assets/multi_chart.xlsx | Bin 39673 -> 0 bytes axlsx.gemspec | 4 +-- examples/example.rb | 83 ++++++++++++++++++++++++++++++++++++++++++++++++ 4 files changed, 85 insertions(+), 85 deletions(-) delete mode 100644 assets/example.rb delete mode 100644 assets/multi_chart.xlsx create mode 100644 examples/example.rb diff --git a/assets/example.rb b/assets/example.rb deleted file mode 100644 index fd889556..00000000 --- a/assets/example.rb +++ /dev/null @@ -1,83 +0,0 @@ - require 'rubygems' - require 'axlsx' - -#A Simple Workbook - p = Axlsx::Package.new - p.workbook.add_worksheet do |sheet| - sheet.add_row ["First", "Second", "Third"] - sheet.add_row [1, 2, 3] - end - p.serialize("example1.xlsx") - -#Generating A Bar Chart - p = Axlsx::Package.new - p.workbook.add_worksheet do |sheet| - sheet.add_row ["First", "Second", "Third"] - sheet.add_row [1, 2, 3] - sheet.add_chart(Axlsx::Bar3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 2: Chart") do |chart| - chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells - end - end - p.serialize("example2.xlsx") - -#Generating A Pie Chart - p = Axlsx::Package.new - p.workbook.add_worksheet do |sheet| - sheet.add_row ["First", "Second", "Third"] - sheet.add_row [1, 2, 3] - sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 3: Pie Chart") do |chart| - chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells - end - end - p.serialize("example3.xlsx") - - -#Using Custom Styles - - p = Axlsx::Package.new - wb = p.workbook - black_cell = wb.styles.add_style :bg_color => "FF000000", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } - blue_cell = wb.styles.add_style :bg_color => "FF0000FF", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } - wb.add_worksheet do |sheet| - sheet.add_row ["Text Autowidth", "Second", "Third"], :style => [black_cell, blue_cell, black_cell] - sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER - end - p.serialize("example4.xlsx") - -#Using Custom Formatting and date1904 - - p = Axlsx::Package.new - wb = p.workbook - date = wb.styles.add_style :format_code=>"yyyy-mm-dd", :border => Axlsx::STYLE_THIN_BORDER - padded = wb.styles.add_style :format_code=>"00#", :border => Axlsx::STYLE_THIN_BORDER - percent = wb.styles.add_style :format_code=>"0%", :border => Axlsx::STYLE_THIN_BORDER - wb.date1904 = true # required for generation on mac - wb.add_worksheet do |sheet| - sheet.add_row ["Custom Formatted Date", "Percent Formatted Float", "Padded Numbers"], :style => Axlsx::STYLE_THIN_BORDER - sheet.add_row [Time.now, 0.2, 32], :style => [date, percent, padded] - end - p.serialize("example5.xlsx") - -#Validation - p = Axlsx::Package.new - p.workbook.add_worksheet do |sheet| - sheet.add_row ["First", "Second", "Third"] - sheet.add_row [1, 2, 3] - end - - p.validate.each do |error| - puts error.inspect - end - -#Generating A Line Chart - - p = Axlsx::Package.new - p.workbook.add_worksheet do |sheet| - sheet.add_row ["First", 1, 5, 7, 9] - sheet.add_row ["Second", 5, 2, 14, 9] - sheet.add_chart(Axlsx::Line3DChart, :start_at => [0,2], :end_at => [10, 15], :title=>"example 6: Line Chart") do |chart| - chart.add_series :data=>sheet.rows.first.cells[(1..-1)], :title=> sheet.rows.first.cells.first - chart.add_series :data=>sheet.rows.last.cells[(1..-1)], :title=> sheet.rows.last.cells.first - end - end - p.serialize("example6.xlsx") diff --git a/assets/multi_chart.xlsx b/assets/multi_chart.xlsx deleted file mode 100644 index 2390e68c..00000000 Binary files a/assets/multi_chart.xlsx and /dev/null differ diff --git a/axlsx.gemspec b/axlsx.gemspec index 648f77fe..20d07764 100644 --- a/axlsx.gemspec +++ b/axlsx.gemspec @@ -1,7 +1,7 @@ require File.expand_path(File.dirname(__FILE__) + '/lib/axlsx/util/constants.rb') Gem::Specification.new do |s| s.name = 'axlsx' - s.homepage = 'https://rubyforge.org/projects/axlsx/' + s.homepage = 'https://github.com/randym/axlsx' s.has_rdoc = 'axlsx' s.rubyforge_project = 'axlsx' s.version = Axlsx::VERSION @@ -13,7 +13,7 @@ Gem::Specification.new do |s| EOF s.authors = ["Randy Morgan"] s.email = 'digital.ipeseity@gmail.com' - s.files = Dir.glob("{docs,lib,test,schema}/**/*") + ['LICENSE', 'README.md', 'Rakefile'] + s.files = Dir.glob("{docs,lib,test,schema,examples}/**/*") + ['LICENSE', 'README.md', 'Rakefile'] s.add_runtime_dependency 'nokogiri', '~> 1' s.add_runtime_dependency 'active_support', '~> 3' s.add_runtime_dependency 'rmagick', '~> 2.12' diff --git a/examples/example.rb b/examples/example.rb new file mode 100644 index 00000000..fd889556 --- /dev/null +++ b/examples/example.rb @@ -0,0 +1,83 @@ + require 'rubygems' + require 'axlsx' + +#A Simple Workbook + p = Axlsx::Package.new + p.workbook.add_worksheet do |sheet| + sheet.add_row ["First", "Second", "Third"] + sheet.add_row [1, 2, 3] + end + p.serialize("example1.xlsx") + +#Generating A Bar Chart + p = Axlsx::Package.new + p.workbook.add_worksheet do |sheet| + sheet.add_row ["First", "Second", "Third"] + sheet.add_row [1, 2, 3] + sheet.add_chart(Axlsx::Bar3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 2: Chart") do |chart| + chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells + end + end + p.serialize("example2.xlsx") + +#Generating A Pie Chart + p = Axlsx::Package.new + p.workbook.add_worksheet do |sheet| + sheet.add_row ["First", "Second", "Third"] + sheet.add_row [1, 2, 3] + sheet.add_chart(Axlsx::Pie3DChart, :start_at => [0,2], :end_at => [5, 15], :title=>"example 3: Pie Chart") do |chart| + chart.add_series :data=>sheet.rows.last.cells, :labels=> sheet.rows.first.cells + end + end + p.serialize("example3.xlsx") + + +#Using Custom Styles + + p = Axlsx::Package.new + wb = p.workbook + black_cell = wb.styles.add_style :bg_color => "FF000000", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } + blue_cell = wb.styles.add_style :bg_color => "FF0000FF", :fg_color => "FFFFFFFF", :sz=>14, :alignment => { :horizontal=> :center } + wb.add_worksheet do |sheet| + sheet.add_row ["Text Autowidth", "Second", "Third"], :style => [black_cell, blue_cell, black_cell] + sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER + end + p.serialize("example4.xlsx") + +#Using Custom Formatting and date1904 + + p = Axlsx::Package.new + wb = p.workbook + date = wb.styles.add_style :format_code=>"yyyy-mm-dd", :border => Axlsx::STYLE_THIN_BORDER + padded = wb.styles.add_style :format_code=>"00#", :border => Axlsx::STYLE_THIN_BORDER + percent = wb.styles.add_style :format_code=>"0%", :border => Axlsx::STYLE_THIN_BORDER + wb.date1904 = true # required for generation on mac + wb.add_worksheet do |sheet| + sheet.add_row ["Custom Formatted Date", "Percent Formatted Float", "Padded Numbers"], :style => Axlsx::STYLE_THIN_BORDER + sheet.add_row [Time.now, 0.2, 32], :style => [date, percent, padded] + end + p.serialize("example5.xlsx") + +#Validation + p = Axlsx::Package.new + p.workbook.add_worksheet do |sheet| + sheet.add_row ["First", "Second", "Third"] + sheet.add_row [1, 2, 3] + end + + p.validate.each do |error| + puts error.inspect + end + +#Generating A Line Chart + + p = Axlsx::Package.new + p.workbook.add_worksheet do |sheet| + sheet.add_row ["First", 1, 5, 7, 9] + sheet.add_row ["Second", 5, 2, 14, 9] + sheet.add_chart(Axlsx::Line3DChart, :start_at => [0,2], :end_at => [10, 15], :title=>"example 6: Line Chart") do |chart| + chart.add_series :data=>sheet.rows.first.cells[(1..-1)], :title=> sheet.rows.first.cells.first + chart.add_series :data=>sheet.rows.last.cells[(1..-1)], :title=> sheet.rows.last.cells.first + end + end + p.serialize("example6.xlsx") -- cgit v1.2.3