XLSX.jl
XLSX.jl copied to clipboard
Excel file reader and writer for the Julia language.
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...
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...
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: ``` #...
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...
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...
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