Changes in version 0.1.0 First release. zuxlsx reads .xlsx workbooks without a system XML, ZIP or cryptography library: it bundles the 'xlsxio' reader and links 'Expat', 'miniz' and 'TF-PSA-Crypto' statically from zuxml, zukomp and zucrypt, so an installed zuxlsx has no run-time dependency on any of them. Reading - Every export is named xlsx_*: xlsx_read(), xlsx_cells(), xlsx_rows(), xlsx_stream_cells(), xlsx_sheets() and xlsx_info(). No name masks a function of readxl or openxlsx2. - xlsx_read() reads a worksheet into a data frame, giving each column the type its cells support: logical, double, character, Date or POSIXct. range takes A1 notation and either corner may name a cell, a column or a row, so "B2:D10", "A:C" and "2:10" are all accepted. - xlsx_cells() returns one row per cell with its position, type, text and numeric value -- the view underneath xlsx_read(), for worksheets that are not rectangular enough for a data frame. - xlsx_rows() returns a worksheet row by row as text, from row 1, padded so that the nth element of each row is the nth column. - xlsx_stream_cells() reads a worksheet a chunk at a time, passing each chunk to a function. Returning FALSE stops the read, which is how a caller finds something near the top of a large worksheet without paying for the rest. - xlsx_sheets() lists worksheets, and xlsx_info() reports the 'xlsxio', 'Expat', 'miniz' and 'TF-PSA-Crypto' versions actually linked in. Workbooks as they are written - Strict OOXML ("Strict Open XML Spreadsheet") reads as transitional OOXML does, part names are matched as OOXML consumers match them -- ignoring case and backslashes -- and ZIP64 archives open. - A shared-string table written with a namespace prefix () is read, an empty string in it no longer shifts every later string by one, and an index written with whitespace around it resolves. Password-protected workbooks - Every reader takes password =, and reads a workbook protected with agile encryption -- what Excel has written since 2013. The workbook is decrypted in memory; neither it nor its plaintext is written to disk, and the plaintext is wiped when the read ends. - The integrity code the file carries is checked before anything is decrypted, so a workbook altered after it was encrypted is refused with zuxlsx_integrity_error rather than read as garbage. - A missing password raises zuxlsx_encrypted_error, and a wrong one zuxlsx_password_error, its subclass. Office 2007's standard encryption, and the other schemes, are refused by name with zuxlsx_unsupported_format_error, never reported as a wrong password. Dates - Both Excel epochs are handled. The workbook's own date1904 setting decides which is used, so a workbook written on a Mac does not read four years out. - The 1900 system's phantom 29 February 1900 is accounted for: serial 1 is 1 January 1900 and serial 61 is 1 March 1900, as Excel shows them, and serial 60 -- a day that never existed -- is NA, as is any time on it. Using a single origin, as is common, puts every date before March 1900 a day early. - A date written as ISO 8601 text (t="d") reads as a date, and a number format is a date only for date and time codes: currency tags such as [$$-en-US] and colours such as [Magenta] are not. The East Asian and Thai built-in date formats are recognised. Errors - Every error is a classed condition under zuxlsx_error: zuxlsx_input_error, zuxlsx_zip_error, zuxlsx_xml_error, zuxlsx_ooxml_error, zuxlsx_sheet_error, zuxlsx_unsupported_format_error, zuxlsx_encrypted_error, zuxlsx_password_error, zuxlsx_integrity_error and zuxlsx_memory_error. See ?"zuxlsx-conditions". - A worksheet that cannot be read in full -- its XML breaks off, it refers to a cell past XFD1048576 or to a shared string that does not exist, its or its compressed data fails its checksum -- is an error, never a shorter sheet. - A part carrying a DOCTYPE is an XML error: no workbook part has one, and an internal subset is how entities are declared. - A file that is a spreadsheet zuxlsx cannot read is reported as such rather than as damage. A legacy .xls is an OLE2 container, not a ZIP, and an .xlsb stores its worksheets as binary records; both raise zuxlsx_unsupported_format_error instead of looking corrupt. - XML that will not parse is distinguished from XML that parses but declares no worksheet, and the message names the part and line.