XLSX.jl icon indicating copy to clipboard operation
XLSX.jl copied to clipboard

Excel file reader and writer for the Julia language.

Results 73 XLSX.jl issues
Sort by recently updated
recently updated
newest added

``` julia> xlsx = XLSX.readxlsx("Test.xlsx"); julia> sheet = xlsx["Sheet1"]; julia> length(XLSX.eachrow(sheet)) ERROR: MethodError: no method matching length(::XLSX.WorksheetCache{XLSX.SheetRowStreamIterator}) Closest candidates are: length(::XLSX.CellRange) at /Users/mzgubic/.julia/packages/XLSX/A7wWu/src/cellref.jl:337 length(::ExponentialBackOff) at error.jl:259 length(::XLSX.ColumnRange) at /Users/mzgubic/.julia/packages/XLSX/A7wWu/src/cellref.jl:310 ......

enhancement

I want to write excel file for reading in AMPL. I read the AMPL documentation and it seems to be able to only load named ranges. Is it possible to...

enhancement

I consistently get a segfault when trying to call `readtable()` as below. The file used can be [downloaded here](https://www.icos-cp.eu/global-carbon-budget-2019). It's the second url in the Download section, the one called...

I am trying to write large excel file (.xlsx). It is supposed to have 4.3 MB. Excel data size is within excel column and row limits. Smaller excels write ok...

bug
windows

Is there anyway to add plotted figures to existing excel file? I would like to read data from excel file, plot figure by Julia and then put the plotted figure...

Use case: Excel file inside a Zip or Gzip file.

enhancement

https://github.com/bcbi/CompatHelper.jl would remove need for manual PRs like https://github.com/felipenoris/XLSX.jl/pull/129.

Is it possible to write a cell.formula?

It would be nice to support custom missing strings, e.g. like `missingstring=` keyword argument in `CSV.jl`.

enhancement