Module: RubyXL::LegacyWorkbook
Constant Summary collapse
- SHEET_NAME_TEMPLATE =
'Sheet%d'
- APPLICATION =
'Microsoft Macintosh Excel'
- APPVERSION =
'12.0000'
Instance Attribute Summary collapse
-
#calculation_chain ⇒ Object
Returns the value of attribute calculation_chain.
-
#chart_rels ⇒ Object
Returns the value of attribute chart_rels.
-
#charts ⇒ Object
Returns the value of attribute charts.
-
#chartsheet_rels ⇒ Object
Returns the value of attribute chartsheet_rels.
-
#content_types ⇒ Object
Returns the value of attribute content_types.
-
#core_properties ⇒ Object
Returns the value of attribute core_properties.
-
#document_properties ⇒ Object
Returns the value of attribute document_properties.
-
#drawings ⇒ Object
Returns the value of attribute drawings.
-
#drawings_rels ⇒ Object
Returns the value of attribute drawings_rels.
-
#external_links ⇒ Object
Returns the value of attribute external_links.
-
#external_links_rels ⇒ Object
Returns the value of attribute external_links_rels.
-
#filepath ⇒ Object
Returns the value of attribute filepath.
-
#macros ⇒ Object
Returns the value of attribute macros.
-
#media ⇒ Object
Returns the value of attribute media.
-
#printer_settings ⇒ Object
Returns the value of attribute printer_settings.
-
#relationship_container ⇒ Object
Returns the value of attribute relationship_container.
-
#root_relationship_container ⇒ Object
Returns the value of attribute root_relationship_container.
-
#shared_strings_container ⇒ Object
Returns the value of attribute shared_strings_container.
-
#stylesheet ⇒ Object
Returns the value of attribute stylesheet.
-
#theme ⇒ Object
Returns the value of attribute theme.
-
#thumbnail ⇒ Object
Returns the value of attribute thumbnail.
-
#worksheet_rels ⇒ Object
Returns the value of attribute worksheet_rels.
-
#worksheets ⇒ Object
Returns the value of attribute worksheets.
Instance Method Summary collapse
-
#[](ind) ⇒ Object
Finds worksheet by its name or numerical index.
-
#add_worksheet(name = nil) ⇒ Object
Create new simple worksheet and add it to the workbook worksheets.
-
#borders ⇒ Object
Stylesheet should be pre-filled with defaults on initialize().
-
#cell_xfs ⇒ Object
Stylesheet should be pre-filled with defaults on initialize().
- #date_to_num(date) ⇒ Object
- #each ⇒ Object
-
#fills ⇒ Object
Stylesheet should be pre-filled with defaults on initialize().
-
#fonts ⇒ Object
Stylesheet should be pre-filled with defaults on initialize().
- #get_fill_color(xf) ⇒ Object
- #initialize(worksheets = [], filepath = nil, creator = nil, modifier = nil, created_at = nil, company = '', application = APPLICATION, appversion = APPVERSION, date1904 = 0) ⇒ Object
- #modify_alignment(style_index, is_horizontal, alignment) ⇒ Object
- #modify_border(style_index, direction, weight) ⇒ Object
- #modify_fill(style_index, rgb) ⇒ Object
- #modify_text_wrap(style_index, wrap = false) ⇒ Object
- #num_to_date(num) ⇒ Object
- #register_new_fill(new_fill, old_xf) ⇒ Object
- #register_new_font(new_font, old_xf) ⇒ Object
- #register_new_xf(new_xf, old_style_index) ⇒ Object
-
#write(filepath = @filepath) ⇒ Object
filepath of xlsx file (including file itself).
Instance Attribute Details
#calculation_chain ⇒ Object
Returns the value of attribute calculation_chain.
11 12 13 |
# File 'lib/rubyXL/workbook.rb', line 11 def calculation_chain @calculation_chain end |
#chart_rels ⇒ Object
Returns the value of attribute chart_rels.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def chart_rels @chart_rels end |
#charts ⇒ Object
Returns the value of attribute charts.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def charts @charts end |
#chartsheet_rels ⇒ Object
Returns the value of attribute chartsheet_rels.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def chartsheet_rels @chartsheet_rels end |
#content_types ⇒ Object
Returns the value of attribute content_types.
11 12 13 |
# File 'lib/rubyXL/workbook.rb', line 11 def content_types @content_types end |
#core_properties ⇒ Object
Returns the value of attribute core_properties.
11 12 13 |
# File 'lib/rubyXL/workbook.rb', line 11 def core_properties @core_properties end |
#document_properties ⇒ Object
Returns the value of attribute document_properties.
11 12 13 |
# File 'lib/rubyXL/workbook.rb', line 11 def document_properties @document_properties end |
#drawings ⇒ Object
Returns the value of attribute drawings.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def drawings @drawings end |
#drawings_rels ⇒ Object
Returns the value of attribute drawings_rels.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def drawings_rels @drawings_rels end |
#external_links ⇒ Object
Returns the value of attribute external_links.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def external_links @external_links end |
#external_links_rels ⇒ Object
Returns the value of attribute external_links_rels.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def external_links_rels @external_links_rels end |
#filepath ⇒ Object
Returns the value of attribute filepath.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def filepath @filepath end |
#macros ⇒ Object
Returns the value of attribute macros.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def macros @macros end |
#media ⇒ Object
Returns the value of attribute media.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def media @media end |
#printer_settings ⇒ Object
Returns the value of attribute printer_settings.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def printer_settings @printer_settings end |
#relationship_container ⇒ Object
Returns the value of attribute relationship_container.
11 12 13 |
# File 'lib/rubyXL/workbook.rb', line 11 def relationship_container @relationship_container end |
#root_relationship_container ⇒ Object
Returns the value of attribute root_relationship_container.
11 12 13 |
# File 'lib/rubyXL/workbook.rb', line 11 def root_relationship_container @root_relationship_container end |
#shared_strings_container ⇒ Object
Returns the value of attribute shared_strings_container.
11 12 13 |
# File 'lib/rubyXL/workbook.rb', line 11 def shared_strings_container @shared_strings_container end |
#stylesheet ⇒ Object
Returns the value of attribute stylesheet.
11 12 13 |
# File 'lib/rubyXL/workbook.rb', line 11 def stylesheet @stylesheet end |
#theme ⇒ Object
Returns the value of attribute theme.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def theme @theme end |
#thumbnail ⇒ Object
Returns the value of attribute thumbnail.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def thumbnail @thumbnail end |
#worksheet_rels ⇒ Object
Returns the value of attribute worksheet_rels.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def worksheet_rels @worksheet_rels end |
#worksheets ⇒ Object
Returns the value of attribute worksheets.
7 8 9 |
# File 'lib/rubyXL/workbook.rb', line 7 def worksheets @worksheets end |
Instance Method Details
#[](ind) ⇒ Object
Finds worksheet by its name or numerical index
68 69 70 71 72 73 |
# File 'lib/rubyXL/workbook.rb', line 68 def [](ind) case ind when Integer then worksheets[ind] when String then worksheets.find { |ws| ws.sheet_name == ind } end end |
#add_worksheet(name = nil) ⇒ Object
Create new simple worksheet and add it to the workbook worksheets
78 79 80 81 82 83 84 85 86 87 88 89 90 |
# File 'lib/rubyXL/workbook.rb', line 78 def add_worksheet(name = nil) if name.nil? then n = 0 begin name = SHEET_NAME_TEMPLATE % (n += 1) end until self[name].nil? end new_worksheet = Worksheet.new(:workbook => self, :sheet_name => name || get_default_name) worksheets << new_worksheet new_worksheet end |
#borders ⇒ Object
Stylesheet should be pre-filled with defaults on initialize()
259 260 261 |
# File 'lib/rubyXL/workbook.rb', line 259 def borders # Stylesheet should be pre-filled with defaults on initialize() stylesheet.borders end |
#cell_xfs ⇒ Object
Stylesheet should be pre-filled with defaults on initialize()
247 248 249 |
# File 'lib/rubyXL/workbook.rb', line 247 def cell_xfs # Stylesheet should be pre-filled with defaults on initialize() stylesheet.cell_xfs end |
#date_to_num(date) ⇒ Object
145 146 147 |
# File 'lib/rubyXL/workbook.rb', line 145 def date_to_num(date) date && (date.ajd - base_date().ajd).to_f end |
#each ⇒ Object
92 93 94 |
# File 'lib/rubyXL/workbook.rb', line 92 def each worksheets.each{|i| yield i} end |
#fills ⇒ Object
Stylesheet should be pre-filled with defaults on initialize()
255 256 257 |
# File 'lib/rubyXL/workbook.rb', line 255 def fills # Stylesheet should be pre-filled with defaults on initialize() stylesheet.fills end |
#fonts ⇒ Object
Stylesheet should be pre-filled with defaults on initialize()
251 252 253 |
# File 'lib/rubyXL/workbook.rb', line 251 def fonts # Stylesheet should be pre-filled with defaults on initialize() stylesheet.fonts end |
#get_fill_color(xf) ⇒ Object
153 154 155 156 157 158 |
# File 'lib/rubyXL/workbook.rb', line 153 def get_fill_color(xf) fill = fills[xf.fill_id] pattern = fill && fill.pattern_fill color = pattern && pattern.fg_color color && color.rgb || 'ffffff' end |
#initialize(worksheets = [], filepath = nil, creator = nil, modifier = nil, created_at = nil, company = '', application = APPLICATION, appversion = APPVERSION, date1904 = 0) ⇒ Object
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 64 65 |
# File 'lib/rubyXL/workbook.rb', line 18 def initialize(worksheets=[], filepath=nil, creator=nil, modifier=nil, created_at=nil, company='', application=APPLICATION, appversion=APPVERSION, date1904=0) super() # Order of sheets in the +worksheets+ array corresponds to the order of pages in Excel UI. # SheetId's, rId's, etc. are completely unrelated to ordering. @worksheets = worksheets add_worksheet if @worksheets.empty? @filepath = filepath @creator = creator @modifier = modifier self.date1904 = date1904 > 0 @media = RubyXL::GenericStorage.new(File.join('xl', 'media')).binary @external_links = RubyXL::GenericStorage.new(File.join('xl', 'externalLinks')) @external_links_rels = RubyXL::GenericStorage.new(File.join('xl', 'externalLinks', '_rels')) @drawings = RubyXL::GenericStorage.new(File.join('xl', 'drawings')) @drawings_rels = RubyXL::GenericStorage.new(File.join('xl', 'drawings', '_rels')) @charts = RubyXL::GenericStorage.new(File.join('xl', 'charts')) @chart_rels = RubyXL::GenericStorage.new(File.join('xl', 'charts', '_rels')) @worksheet_rels = RubyXL::GenericStorage.new(File.join('xl', 'worksheets', '_rels')) @chartsheet_rels = RubyXL::GenericStorage.new(File.join('xl', 'chartsheets', '_rels')) @printer_settings = RubyXL::GenericStorage.new(File.join('xl', 'printerSettings')).binary @macros = RubyXL::GenericStorage.new('xl').binary @thumbnail = RubyXL::GenericStorage.new('docProps').binary @theme = RubyXL::Theme.new @shared_strings_container = RubyXL::SharedStringsTable.new @stylesheet = RubyXL::Stylesheet.default @document_properties = RubyXL::DocumentProperties.new @core_properties = RubyXL::CoreProperties.new @content_types = RubyXL::ContentTypes.new @relationship_container = RubyXL::WorkbookRelationships.new @root_relationship_container = RubyXL::RootRelationships.new @calculation_chain = nil self.company = company self.application = application self.appversion = appversion begin @created_at = DateTime.parse(created_at).strftime('%Y-%m-%dT%TZ') rescue @created_at = Time.now.strftime('%Y-%m-%dT%TZ') end @modified_at = @created_at end |
#modify_alignment(style_index, is_horizontal, alignment) ⇒ Object
209 210 211 212 213 214 215 |
# File 'lib/rubyXL/workbook.rb', line 209 def modify_alignment(style_index, is_horizontal, alignment) xf = cell_xfs[style_index].dup xf.alignment = RubyXL::Alignment.new(:apply_alignment => true, :horizontal => is_horizontal ? alignment : nil, :vertical => is_horizontal ? nil : alignment) register_new_xf(xf, style_index) end |
#modify_border(style_index, direction, weight) ⇒ Object
226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 |
# File 'lib/rubyXL/workbook.rb', line 226 def modify_border(style_index, direction, weight) old_xf = cell_xfs[style_index].dup new_border = borders[old_xf.border_id].dup new_border.set_edge_style(direction, weight) new_xf = old_xf.dup unless borders[old_xf.border_id].count == 1 && old_xf.border_id > 0 # If the old border not used anymore, just replace it new_xf.border_id = borders.find_index { |x| x == new_border } # Use existing border, if it exists new_xf.border_id ||= borders.size # If this border has never existed before, add it to collection. end borders[old_xf.border_id].count -= 1 new_border.count += 1 borders[new_xf.border_id] = new_border new_xf.apply_border = true register_new_xf(new_xf, style_index) end |
#modify_fill(style_index, rgb) ⇒ Object
217 218 219 220 221 222 223 224 |
# File 'lib/rubyXL/workbook.rb', line 217 def modify_fill(style_index, rgb) xf = cell_xfs[style_index].dup new_fill = RubyXL::Fill.new(:pattern_fill => RubyXL::PatternFill.new(:pattern_type => 'solid', :fg_color => RubyXL::Color.new(:rgb => rgb))) new_xf = register_new_fill(new_fill, xf) register_new_xf(new_xf, style_index) end |
#modify_text_wrap(style_index, wrap = false) ⇒ Object
203 204 205 206 207 |
# File 'lib/rubyXL/workbook.rb', line 203 def modify_text_wrap(style_index, wrap = false) xf = cell_xfs[style_index].dup xf.alignment = RubyXL::Alignment.new(:wrap_text => wrap, :apply_alignment => true) register_new_xf(xf, style_index) end |
#num_to_date(num) ⇒ Object
149 150 151 |
# File 'lib/rubyXL/workbook.rb', line 149 def num_to_date(num) num && (base_date + num) end |
#register_new_fill(new_fill, old_xf) ⇒ Object
160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 |
# File 'lib/rubyXL/workbook.rb', line 160 def register_new_fill(new_fill, old_xf) new_xf = old_xf.dup unless fills[old_xf.fill_id].count == 1 && old_xf.fill_id > 2 # If the old fill is not used anymore, just replace it new_xf.fill_id = fills.find_index { |x| x == new_fill } # Use existing fill, if it exists new_xf.fill_id ||= fills.size # If this fill has never existed before, add it to collection. end fills[old_xf.fill_id].count -= 1 new_fill.count += 1 fills[new_xf.fill_id] = new_fill new_xf.apply_fill = true new_xf end |
#register_new_font(new_font, old_xf) ⇒ Object
176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 |
# File 'lib/rubyXL/workbook.rb', line 176 def register_new_font(new_font, old_xf) new_xf = old_xf.dup unless fonts[old_xf.font_id].count == 1 && old_xf.font_id > 1 # If the old font is not used anymore, just replace it new_xf.font_id = fonts.find_index { |x| x == new_font } # Use existing font, if it exists new_xf.font_id ||= fonts.size # If this font has never existed before, add it to collection. end fonts[old_xf.font_id].count -= 1 new_font.count += 1 fonts[new_xf.font_id] = new_font new_xf.apply_font = true new_xf end |
#register_new_xf(new_xf, old_style_index) ⇒ Object
192 193 194 195 196 197 198 199 200 201 |
# File 'lib/rubyXL/workbook.rb', line 192 def register_new_xf(new_xf, old_style_index) new_xf_id = cell_xfs.find_index { |xf| xf == new_xf } # Use existing XF, if it exists new_xf_id ||= cell_xfs.size # If this XF has never existed before, add it to collection. cell_xfs[old_style_index].count -= 1 new_xf.count += 1 cell_xfs[new_xf_id] = new_xf new_xf_id end |
#write(filepath = @filepath) ⇒ Object
filepath of xlsx file (including file itself)
97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 |
# File 'lib/rubyXL/workbook.rb', line 97 def write(filepath = @filepath) extension = File.extname(filepath) unless %w{.xlsx .xlsm}.include?(extension) raise "Only xlsx and xlsm files are supported. Unsupported extension: #{extension}" end dirpath = File.dirname(filepath) temppath = File.join(dirpath, Dir::Tmpname.make_tmpname([ File.basename(filepath), '.tmp' ], nil)) FileUtils.mkdir_p(temppath) zippath = File.join(temppath, 'file.zip') ::Zip::File.open(zippath, ::Zip::File::CREATE) { |zipfile| theme && theme.add_to_zip(zipfile) calculation_chain && calculation_chain.add_to_zip(zipfile) shared_strings_container && shared_strings_container.add_to_zip(zipfile) document_properties.add_to_zip(zipfile) core_properties.add_to_zip(zipfile) content_types.workbook = self content_types.add_to_zip(zipfile) relationship_container.workbook = root_relationship_container.workbook = self relationship_container.add_to_zip(zipfile) stylesheet.add_to_zip(zipfile) root_relationship_container.add_to_zip(zipfile) self.add_to_zip(zipfile) [ @media, @external_links, @external_links_rels, @drawings, @drawings_rels, @charts, @chart_rels, @printer_settings, @worksheet_rels, @chartsheet_rels, @macros, @thumbnail ].each { |s| s.add_to_zip(zipfile) } @worksheets.each { |sheet| sheet.add_to_zip(zipfile) } } FileUtils.mv(zippath, filepath) FileUtils.rm_rf(temppath) if File.exist?(filepath) return filepath end |