Contents

# frozen_string_literal: true
module Saxlsx
  class Workbook
    DATE_SYSTEM_1900 = DateTime.new(1899, 12, 30)
    DATE_SYSTEM_1904 = DateTime.new(1904, 1, 1)

    attr_accessor :date1904
    attr_reader :auto_format

    def self.open(*args)
      begin
        workbook = self.new(*args)
        yield workbook
      ensure
        workbook.close if workbook
      end
    end

    def initialize(filename, auto_format: true)
      @file_system = FileSystem.new filename
      @auto_format = auto_format
    end

    def close
      @file_system.close
    end

    def sheets(name=nil)
      @sheets ||= SheetCollection.new(@file_system, self).to_a
      name.nil? ? @sheets : @sheets.detect { |s| s.name == name }
    end

    def sheet_names
      sheets.map(&:name)
    end

    def shared_strings
      @shared_strings ||= SharedStringCollection.new(@file_system).to_a
    end

    def number_formats
      @number_formats ||= StyleCollection.new(@file_system).to_a
    end

    def base_date
      @base_date ||= date1904 ? DATE_SYSTEM_1904 : DATE_SYSTEM_1900
    end

    def to_csv(path)
      sheets.each { |s| s.to_csv path }
    end

  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
saxlsx-1.9.0	lib/saxlsx/workbook.rb
saxlsx-1.8.0	lib/saxlsx/workbook.rb
saxlsx-1.7.1	lib/saxlsx/workbook.rb
saxlsx-1.7.0	lib/saxlsx/workbook.rb