* Add `newxlsx()` and `opentemplate()` and `CellRef` to docs * A few typos * Add row ranges to formatting functions. * Update CI * Add `normalizenames` keyword to `XLSX.readtable` (felipenoris#260) * Add three functions for merged cells (no tests yet) to address felipenoris#241 * Functions to add Defined Names (more work to do) * Add more support for non-contiguous ranges in defined names. * Add fix to felipenoris#239 in writetable!() function * More updates to support non-contiguous cell ramges * Preparing to write definedNames in `xlsxwrite()` * Bug fixing new code with existing tests * Support `getdata()` for row ranges * Handle apostrophes in sheet names in `definedNames` * Write new `definedNames` out to a new XLSXFile * Handle apostrophes correctly in sheetname part of `definedNames` * Minor row range fixes * Begin adding some tests * Add new functions to API docs * Add more tests * Minor changes to docstrings... * Missing line in CI * Try again. :-( * Bump to julia 1.8 and above * New branch for bug fixing post PR felipenoris#289 * Add 'lts' to CI per @Eben60 review * Fix to bug highlighted when `Node.depth` bug in XML was itself fixed (as yet untested). * Previous fix but now with actual change!! * Update CI to include `aarch64` for MacOS-latest * Include versions in CL for MacOS aarch64 * Now with all julia versions specified for aarch64, too. (is this right???) * Add test for `setOutsideBorder` * Fix the two node depth tests to `XML.depth==2` (XML uses 1-based counting whereas EzXML used 0-based) * Begin to introduce support for a few named colors * Add support for named colors from Colors.jl * Revert to XML.escape with XML.jl 0.3.5 * Integrate `setOutsideBorder` into `setBorder` * Minor tweaks! * Fix `getBorder()` for diagonal borders * Add examples of named colors in docstrings * Update tests for changes to getBorder Fix behaviour of `setUniformFormat()` * Replace `@assert` with `throw()` (felipenoris#190) * Row and/or column indexing with vectors of Ints (felipenoris#276) * Address felipenoris#258 as proposed... * Address issue felipenoris#147 Also remove dependency of `getcellrange()` functions on `eachrow()` * Update tests for changes to `getcellranges` * Change `error()` to `throw(XLSXError())` * Extend indexing options for `setdata!()` * Extend indexing for `setAttribute` family of cell formatting functions. * Add to docstrings. * Fix indexing issues * Split cellformat-helpers.jl into separate file * Tweak docstrings... * Add some tests for indexing `setAttribute` functions * Fix `setUniformAttribute` call error * A few more tests... * Add another set of tests. * More tests * Test valid range names * Fix logic error. * Include changes proposed in felipenoris#287 Thought I'd done this a while ago (my bad!) * Single cell range of one empty cell * Remove most string interpolation outside `throw()` * Clarify use of `definedNames` * Typo! * Address issue felipenoris#88 Allow indexing a `sheetrow` or `tablerow` with either a `UnitRange` or a vector of integers. * Updated to fix issue in felipenoris#292 * Updated with tests for felipenoris#292 * Support merging of cells (felipenoris#241 & felipenoris#184) * Typo! * Improved handling of non-contiguous ranges * Couple of overlooked changes! * Handle non-contiguous ranges for `setUniformAttribute()` functions * Small change to docs. * Fix behavior of `getFormat` when no keywords given. * Add `StepRange` to indexing options. * Detect Excel `.xltx` template files and throw (felipenoris#293). Also rationalise `cellformat-helpers` * Address felipenoris#155 and felipenoris#52 * Filename typo! * Try again! * Take out recalcitrant file. * ... and replace it! * Minor typos * Add ability to delete a worksheet (felipenoris#80) * Add tests for `deletesheet()` * Revisions to docs * Begin to add some dynamic conditional formatting * Add some docs for `colorScale` conditional formats * Adding tests to improve code coverage * A bunch more tests for coverage. * Continue adding tests for coverage... * Now over 90% code-cov according to Coverage.jl! * Small changes * Additions to formatting guide * Finish first version of `colorscale` conditional formatting * Tweaks * Remove stray `=` following conflict resolution * Typo in file name in runtests.jl * Correct type in runtests.jl * Begin to add `:cell` type conditional formats * `:cell` type now basically working * Further work on `:cell` type conditional formats * All conditional formats except `dataBars` and `iconSets`. Still need to add tests and examples. * Minor revisions to docs. * Unify priority to allow overlapping conditional formats * Add tp formatting.md * More documentation. * More minor changes to docstrings * More docs! * Trying to finish docs! * Start adding some tests * Add more tests for conditional formats * Escape formulas properly * Change compats but I don't fully umderstand the compat system! * Changed for Random as well as Distributions! * Add `expression` to the list of supported types for conditional formats * Add `iconSets` (no tests yet) * Add tests for `:iconSet` conditional formats * Fix compats on UUIDs * Tweaks to docs * Add `dataBar` conditional formatting (with tests) * Update `ci.yml` to match xlsx master * Reinstate 'lts' * Minor tweaks to docs * take timer out of tests * Tweaks and tidy-up * Update README.md * Eliminate statements like `XML.parse(XML.Node, XML.write(node))` * Remove some dead code. * Remove some dead code. * Use new `copynode(::Node)` instead of `deepcopy()` * Pack conditional format keywords into a Dict to improve compilation time. Reduce number of xalls to `find_all_nodes()` to improve performance. * Rationalise some function calls. * Generate a new uuid when adding a new worksheets. * Add `copysheet!` with docs and tests. Also include code from felipenoris#300 and felipenoris#302 * Restructured docs a bit * Restructure `eachrow` iterator. Separate stream interator from cache iterator * Replace `eachrow` with direct cache access (sometimes). * Add minor test to worksheet `dimension` * Minor tidy-up! * Fix felipenoris#250 and add tests for same. * Add mmap support for files too big for memory. Also add `PrecompileTools` (felipenoris#277) * Relax compat limits on `Mmap.jl` * Work around XML.jl issue 43 (JuliaComputing/XML.jl#43) and allow cells containing only spaces retain their value. * Improve work around issue 43 in XML.jl (JuliaComputing/XML.jl#43) Can now write cells containing only whitespage characters or with leading or trailing whitespace. Cannot see these things in cells read in from existing Excel files - XML removes leading whitespace even if `xml:space="preserve"` is specified. Thus a cell containing " " will be read in as missing. A cell containing " hello" will become "hello". * Fix failing line! * Properly unescape strings in `getdata` * Add a `savexlsx` function with docs and tests. * Address felipenoris#243 * Remove need to write to a string on reading (again) * Generalise `readto` to support StructArray as sink (mirrors CSV.jl) * `readdf` -> `readto` in tests * Update API documentation to `readto` * And again in docs :-( * Minor performance changes * Add streaming based on `fileArray`. Based on code first suggested by Fabian Gans here: https://discourse.julialang.org/t/struggling-to-use-mmap-with-ziparchives/129839/17 and developed for ZipArchives by Nathan Zimmerberg here: https://discourse.julialang.org/t/struggling-to-use-mmap-with-ziparchives/129839/21 * Small changes, mainly comments. * Tidy-up * comments * Minor changes to docs. * Add tests for when felipenoris#303 is fixed (currently commented) Depends on fix of issue 43 in XML.jl: JuliaComputing/XML.jl#43 * Escape formulae on write, extending felipenoris#302. * Revise [compats] * Restore eager filling of cache only in write mode * Rudimentary fix for felipenoris#159 (feedback welcome!) * Begin to understand felipenoris#159 * Try to prevent orphaned FormulaReference cells * Finish resolving felipenoris#159 - I hope! No tests yet. * Now with added tests for felipenoris#159 * Manage cell references during `deletedheet!` * Fix felipenoris#312 and update to XML.jl 0.3.6 to fix felipenoris#303 * Separate <row> and <sst> elements for speed-up * Change noDim test to be less brittle * Minor optimizations. * Multi-threaded reading of <row> XML elements * Reading sst table now multi-threaded, too. * Reading files (in write mode) now multi-threaded * Small tweaks * Remove some redundant lines * Add simple test for stream iterator.

Another case of non-simple node that errs in getcell #303

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions