1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
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
|
