class XlsxParser::Book

Defined in:

xlsx-parser/book.cr

Constant Summary

TIME_1900 = Time.utc(1899, 12, 30)
TIME_1904 = Time.utc(1904, 1, 1)

Constructors

Instance Method Summary

Constructor Detail

def self.new(file : IO | String, check_file_extension = true) #

Open given file/filename and store shared strings data


[View source]

Instance Method Detail

def base_time #

Return and store base time given from workbookPr http://msdn.microsoft.com/en-us/library/ff530155(v=office.12).aspx


[View source]
def close #

Close previously opened given file/filename


[View source]
def shared_strings : Array(String) #

[View source]
def sheet(name : String) : Sheet | Nil #

Return sheet with given name


[View source]
def sheet_exists?(name : String) #

Return true if sheet with given name exists otherwise return false


[View source]
def sheets #

Return a array of sheets


[View source]
def style_types #

[View source]
def zip : Compress::Zip::File #

[View source]