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

Today I got the "AssertionError: isempty(XML_GLOBAL_ERROR_STACK)" when I tried to export data to an Excel file. My code to do this is (I export a lot of data in different...

I'm currently working on a large project in Julia, and a part of it is generating Excel reports. Ideally, these reports should mark anomalous results by different text & background...

enhancement

hi could anyone tell me why is this happen: ``` using XLSX m = XLSX.readxlsx("test.xlsx") ``` ``` ERROR: AssertionError: isempty(XML_GLOBAL_ERROR_STACK) Stacktrace: [1] macro expansion at C:\Users\duyanran\.julia\packages\EzXML\ZNwhK\src\error.jl:49 [inlined] [2] readxml(::ZipFile.ReadableFile) at...

bug

Opening an Excel file using `XLSX.openxlsx( filename, mode = "rw" )` is unexpectedly slow even for small(ish) files. Is this expected behaviour? The script below illustrates the point: ``` #...

performance
priority

Hi, I have an issue I wanted to bring up here. I'm not sure if the issue is here, or in EzXML (libxml2?) but wanted to open up a discussion....

Is there any way to extract Excels hyperlinks and not only their names?

Currently, it's possible to use the method `writetable(filename::AbstractString, x; kw...)` to write one table (e.g., a DataFrame) to an excel sheet. I think it'd be super useful to implement the...

enhancement

When using **writetable** to create an .xlsx file with multiple sheets, only a single sheet is visible when opened in some applications, for example: Tableau. I believe this is because...

bug

This function could likely be more generic, accepting instead an `AbstractMatrix`, and iterating with `eachindex`. The specific usecase this came up in was writing an `OffsetArray`. https://github.com/felipenoris/XLSX.jl/blob/68a6cf5aff00987e82afb9684a71bb732a89928c/src/write.jl#L352-L360

enhancement