examples/sparklines1.rb in write_xlsx-1.09.4 vs examples/sparklines1.rb in write_xlsx-1.09.5
- old
+ new
@@ -18,44 +18,43 @@
workbook = WriteXLSX.new('sparklines1.xlsx')
worksheet = workbook.add_worksheet
# Some sample data to plot.
data = [
- [ -2, 2, 3, -1, 0 ],
- [ 30, 20, 33, 20, 15 ],
- [ 1, -1, -1, 1, -1 ]
- ]
+ [-2, 2, 3, -1, 0],
+ [30, 20, 33, 20, 15],
+ [1, -1, -1, 1, -1]
+]
# Write the sample data to the worksheet.
worksheet.write_col('A1', data)
-
# Add a line sparkline (the default) with markers.
worksheet.add_sparkline(
- {
- :location => 'F1',
- :range => 'Sheet1!A1:E1',
- :markers => 1
- }
+ {
+ :location => 'F1',
+ :range => 'Sheet1!A1:E1',
+ :markers => 1
+ }
)
# Add a column sparkline with non-default style.
worksheet.add_sparkline(
- {
- :location => 'F2',
- :range => 'Sheet1!A2:E2',
- :type => 'column',
- :style => 12
- }
- )
+ {
+ :location => 'F2',
+ :range => 'Sheet1!A2:E2',
+ :type => 'column',
+ :style => 12
+ }
+)
# Add a win/loss sparkline with negative values highlighted.
worksheet.add_sparkline(
- {
- :location => 'F3',
- :range => 'Sheet1!A3:E3',
- :type => 'win_loss',
- :negative_points => 1
- }
- )
+ {
+ :location => 'F3',
+ :range => 'Sheet1!A3:E3',
+ :type => 'win_loss',
+ :negative_points => 1
+ }
+)
workbook.close