examples for sprk2012

4 files changed, 44 insertions, 0 deletions

diff --git a/examples/skydrive/axlsx.csv b/examples/skydrive/axlsx.csv
new file mode 100644
index 00000000..b3cea7c1
--- /dev/null
+++ b/examples/skydrive/axlsx.csv
@@ -0,0 +1 @@
+,,,,,
,College Budget,,,,
,,,,,
,What's coming in this month.,,,How am I doing,
,Item,Amount,,Item,Amount
,Estimated monthly net income,\500,,Monthly income,"\20,600"
,Financial aid,\100,,Monthly expenses,"\2,255"
,Allowance from mom & dad,"\20,000",,Semester expenses,\440
,Total,"\20,600",,Difference,"\17,905"
,,,,,
,What's going out this month.,,,Semester Costs,
,Item,Amount,,Item,Amount
,Rent,\650,,Tuition,\200
,Utilities,\120,,Lab fees,\50
,Cell phone,\100,,Other fees,\10
,Groceries,\75,,Books,\150
,Auto expenses,\0,,Deposits,\0
,Student loans,\0,,Transportation,\30
,Other loans,\350,,Total,\440
,Credit cards,\450,,,
,Insurance,\0,,,
,Laundry,\10,,,
,Haircuts,\0,,,
,Medical expenses,\0,,,
,Entertainment,\500,,,
,Miscellaneous,\0,,,
,Total,"\2,255",,,
\ No newline at end of file
diff --git a/examples/sprk2012/basics.rb b/examples/sprk2012/basics.rb
new file mode 100644
index 00000000..8f5cb543
--- /dev/null
+++ b/examples/sprk2012/basics.rb
@@ -0,0 +1,10 @@
+require 'axlsx'
+
+package = Axlsx::Package.new
+package.workbook.add_worksheet(:name => "Basic Worksheet") do |sheet|
+  sheet.add_row ["First Column", "Second", "Third"]
+  sheet.add_row [1, 2, 3]
+end
+package.serialize 'basics.xlsx'
+
+
diff --git a/examples/sprk2012/images.rb b/examples/sprk2012/images.rb
new file mode 100644
index 00000000..d7fc768e
--- /dev/null
+++ b/examples/sprk2012/images.rb
@@ -0,0 +1,14 @@
+require 'axlsx'
+package = Axlsx::Package.new
+workbook = package.workbook
+
+workbook.add_worksheet(:name => "Image with Hyperlink") do |sheet|
+  img = File.expand_path('../image1.jpeg', __FILE__)
+  sheet.add_image(:image_src => img, :noSelect => true, :noMove => true, :hyperlink=>"http://axlsx.blogspot.com") do |image|
+    image.width=720
+    image.height=666
+    image.hyperlink.tooltip = "Labeled Link"
+    image.start_at 2, 2
+  end
+end
+
diff --git a/examples/sprk2012/styles.rb b/examples/sprk2012/styles.rb
new file mode 100644
index 00000000..e9ff6a9e
--- /dev/null
+++ b/examples/sprk2012/styles.rb
@@ -0,0 +1,19 @@
+require 'axlsx'
+package = Axlsx::Package.new
+workbook = package.workbook
+
+workbook.styles do |s|
+
+  black_cell = s.add_style :bg_color => "00", :fg_color => "FF", :sz => 14, :alignment => { :horizontal=> :center }
+  blue_cell =  s.add_style  :bg_color => "0000FF", :fg_color => "FF", :sz => 20, :alignment => { :horizontal=> :center }
+
+  wb.add_worksheet(:name => "Styles") do |sheet|
+
+    # Applies the black_cell style to the first and third cell, and the blue_cell style to the second.
+    sheet.add_row ["Text Autowidth", "Second", "Third"], :style => [black_cell, blue_cell, black_cell]
+
+    # Applies the thin border to all three cells
+    sheet.add_row [1, 2, 3], :style => Axlsx::STYLE_THIN_BORDER
+  end
+end
+