diff options
Diffstat (limited to 'examples/pivot_test.rb')
| -rw-r--r-- | examples/pivot_test.rb | 63 |
1 files changed, 0 insertions, 63 deletions
diff --git a/examples/pivot_test.rb b/examples/pivot_test.rb deleted file mode 100644 index 80bdcd84..00000000 --- a/examples/pivot_test.rb +++ /dev/null @@ -1,63 +0,0 @@ -class RandomReportGenerator - def date - Date.today.strftime("%m/%d/%Y") - end - def member_id - @i ||= 0 - @i += 1 - end - def name - "John S." - end - def gender - ["Male", "Female"].sample - end - def age - rand(100) - end - def city - ["New York", "Mountain View", "Newark", "Phoenix"].sample - end - def state - ["NY", "CA", "NJ", "AZ"].sample - end - def parenting - "Foo" - end - def student - "Bar" - end - def income - "Bar" - end - def education - "Bar" - end - def answer - ["Yes", "No", "Maybe", "I dont know"].sample - end - def run - package = Axlsx::Package.new - workbook = package.workbook - - workbook.add_worksheet(:name => "Data Sheet") do |sheet| - sheet.add_row [ - "Date", "Member ID", "Name", "Gender", "Age", "City", "State", - "Parenting Status", "Student Status", "Income", "Education", "Answer" - ] - 30.times do - sheet.add_row [date, member_id, name, gender, age, city, state, - parenting, student, income, education, answer] - end - end - - workbook.add_worksheet(:name => "Summary") do |sheet| - pivot_table = Axlsx::PivotTable.new 'A1:B15', "A1:L31", workbook.worksheets[0] - pivot_table.rows = ['Answer'] - pivot_table.data = [{:ref => "Member ID", :subtotal => "count"}] - sheet.pivot_tables << pivot_table - end - - package.serialize("pivot_table.xlsx") - end -end |
