Release v0.4.0

Version for Julia v0.7 and v1.0 .

Release v0.3.0

• Improved parsing of special characters

• Docs website

• Support custom formats and styles

• Support Windows

• openxlsx allows for writing new files and editing existing files

Breaking changes

• openxlsxtemplate was renamed to open_xlsx_template

• rewrite keyword argument was renamed to overwrite

• openxlsx now should be used with do block syntax

Thanks for all contributors!

Release v0.2.2

• new writetable method: writetable(filename::AbstractString, tables::Vector{Tuple{String, Vector{Any}, Vector{String}}}; rewrite::Bool=false)

• pretty print for XLSXFile.

Release v0.2.1

• fix writing empty strings to file

• check for valid XLSX file before opening

Release v0.2.0

• New API to write Excel files.

• new readdata and readtable methods.

Release v0.1.3

• Support for streaming large Excel files

• enable_cache option for XLSX.openxlsx method.

• Add XLSX.eachtablerow method for tabular data iteration.

• definedNames that can't be parsed (external references) are silently ignored.

• fix parsing of negative integer values

• TableRow now stores only cell values and are decoupled from Worksheet struct.

Release v0.1.2

• Bug fix for accessing columns ending with Z

• Bug fix for parsing float numbers with scientific notation

• Support for local worksheet names and constants

• Add stop_in_row_function option to XLSX.gettable method

• Improved columns detection for XLSX.getable method

• Added method XLSX.openxlsx for lazy-loading of Excel file content

• Method XLSX.read is deprecated in favor of XLSX.readxlsx

• A few optimizations

Release v0.1.1

• Add support for queries using Excel's "sheetname!range" syntax, as in xf["mysheet!A2:B4"].

• Add support for queries using named ranges, as in xf["NAMED_CELL"].

• Add support for queries using Column ranges, as in xf["mysheet!A:B"].

• Add stop_in_empty_row option in gettable method.

• Improved tests coverage.

Release v0.1.0

• This package now uses EzXML.jl to parse XML files.

• Cache shared strings table (optimization).

• Cache styles float/datetime inference (optimization).

• Check for unique table columns when using gettable method.

Release v0.0.3

• fix reading Excel files with unsorted sheetIds

• support for str datatype

• make missing behavior of str datatype consistent with sst string

• new gettable method to allow integration with DataFrames.jl.