diff options
| author | Randy Morgan <[email protected]> | 2012-03-29 01:00:43 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2012-03-29 01:00:43 +0900 |
| commit | 978e998e167452aafe46953746100f8e4a7d7b59 (patch) | |
| tree | 28ddaa66e4e7a8c16efe11f16523235c4db4a965 /README.md | |
| parent | da054ee2f47261f70ebc18f133dc303acd810581 (diff) | |
| download | caxlsx-978e998e167452aafe46953746100f8e4a7d7b59.tar.gz caxlsx-978e998e167452aafe46953746100f8e4a7d7b59.zip | |
Implement full set of col attributes and improve performance of autowidth two fold.
```
user system total real
axlsx_noautowidth 0.810000 0.020000 0.830000 ( 0.836274)
axlsx 1.430000 0.160000 1.590000 ( 1.776305)
axlsx_shared 9.360000 0.160000 9.520000 ( 9.662113)
axlsx_stream 1.320000 0.110000 1.430000 ( 1.429806)
csv 0.260000 0.020000 0.280000 ( 0.296828)
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 17 |
1 files changed, 16 insertions, 1 deletions
@@ -161,6 +161,20 @@ To install Axlsx, use the following command: end end +##Hiding Columns + + wb.styles do |s| + percent = s.add_style :num_fmt => 9 + wb.add_worksheet(:name => "Hidden Column") do |sheet| + sheet.add_row ['col 1', 'col 2', 'col 3', 'col 4'] + sheet.add_row [1, 2, 0.3, 4] + sheet.add_row [1, 2, 0.2, 4] + sheet.add_row [1, 2, 0.1, 4] + sheet.col_style 2, percent, :row_offset => 1 + sheet.column_info[1].hidden = true + end + end + ##Styling Rows wb.styles do |s| @@ -369,7 +383,8 @@ This gem has 100% test coverage using test/unit. To execute tests for this gem, - added option to *not* use RMagick - and default all assigned columns to the excel default of 8.43 - added border style specification to styles#add_style - now you can pass in :border => {:style => :thin, :color =>"0000FF"} instead of creating a border object and border parts manually each time. - Support for tables added in - Note: Pre 2011 versions of Mac office do not support this feature. - + - Support for splatter charts added + - Major performance updates. - ** March.5.12**: 1.0.18 release https://github.com/randym/axlsx/compare/1.0.17...1.0.18 - bugfix custom borders are not properly applied when using styles.add_style |