diff options
| -rw-r--r-- | README.md | 17 | ||||
| -rw-r--r-- | lib/axlsx/workbook/workbook.rb | 6 | ||||
| -rw-r--r-- | lib/axlsx/workbook/worksheet/cell.rb | 1 |
3 files changed, 20 insertions, 4 deletions
@@ -56,6 +56,10 @@ Feature List **12. Auto filtering tables with worksheet.auto_filter +**13. Export using shared strings or inline string + +**14. Output to disk or StringIO + Installing ---------- @@ -258,6 +262,14 @@ To install Axlsx, use the following command: p.validate.each { |e| puts e.message } p.serialize("example.xlsx") + # alternatively, serilaize to StringIO + s = p.to_stream() + File.open('example_streamed.xlsx', 'w') { |f| f.write(s.read) } + +##Using Shared Strings + + p.use_shared_strings = true + p.serialize("shared_strings_example.xlsx") #Documentation -------------- @@ -272,6 +284,11 @@ This gem has 100% test coverage using test/unit. To execute tests for this gem, #Changelog --------- +- ** February.12.12**: 1.0.17 release + https://github.com/randym/axlsx/compare/1.0.16...1.0.17 + - Added in support for serializing to StringIO + - Added in support for using shared strings table. This makes most of the features in axlsx interoperable with iWorks Numbers + - ** February.2.12**: 1.0.16 release https://github.com/randym/axlsx/compare/1.0.15...1.0.16 - Bug fix for schema file locations when validating in rails diff --git a/lib/axlsx/workbook/workbook.rb b/lib/axlsx/workbook/workbook.rb index b9db0a45..e2a8e73e 100644 --- a/lib/axlsx/workbook/workbook.rb +++ b/lib/axlsx/workbook/workbook.rb @@ -96,10 +96,8 @@ require 'axlsx/workbook/shared_strings_table.rb' #end # Creates a new Workbook - # - # @option options [Boolean] date1904. If this is not specified, we try to determine if the platform is bsd/darwin and set date1904 to true automatically. - # @option - # + # The recomended way to work with workbooks is via Package#workbook + # @option options [Boolean] date1904. If this is not specified, we try to determine if the platform is bsd/darwin and set date1904 to true automatically. def initialize(options={}) @styles = Styles.new @worksheets = SimpleTypedList.new Worksheet diff --git a/lib/axlsx/workbook/worksheet/cell.rb b/lib/axlsx/workbook/worksheet/cell.rb index 728bc22f..5ca5b759 100644 --- a/lib/axlsx/workbook/worksheet/cell.rb +++ b/lib/axlsx/workbook/worksheet/cell.rb @@ -24,6 +24,7 @@ module Axlsx class Cell + # An array of available inline styes. INLINE_STYLES = ['value', 'type', 'font_name', 'charset', 'family', 'b', 'i', 'strike','outline', 'shadow', 'condense', 'extend', 'u', |