ExcelFiles.jl
ExcelFiles.jl copied to clipboard
queryverse
FileIO.jl integration for Excel files
[DocumentFormat.jl](https://github.com/julia-vscode/DocumentFormat.jl) would suggest these formatting changes
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "github-actions[bot] avatar"){kind=avatar}
This pull request changes the compat entry for the `XLSX` package from `0.4.1, 0.5, 0.6, 0.7, 0.8, 0.9` to `0.4.1, 0.5, 0.6, 0.7, 0.8, 0.9, 0.10`. This keeps the compat...
Compat in Project.toml is: ``` XLSX = "≥ 0.4.1" ``` But in [General](https://github.com/JuliaRegistries/General/blob/master/E/ExcelFiles/Compat.toml), Compat.toml has `XLSX = "0.4.1-0.7"` (presumably because when v1 was registered XLSX 0.7 was the latest version?)....
This pull request changes the compat entry for the `ExcelReaders` package from `0.11` to `0.11, 0.12`. This keeps the compat entries for earlier versions. Note: I have not tested your...
julia: 1.7.2 python: 3.10 ```julia using ExcelFiles, DataFrames df = DataFrame(load("result.xlsx", "result")) ``` ```julia PyError ($(Expr(:escape, :(ccall(#= /home/wangxl/.julia/packages/PyCall/L0fLP/src/pyfncall.jl:43 =# @pysym(:PyObject_Call), PyPtr, (PyPtr, PyPtr, PyPtr), o, pyargsptr, kw))))) XLRDError('Excel xlsx file;...
I just tried to load an xlsx file using the `load` function. Evidently, since down deep this depends on the python xlrd package, this is no longer supported: There's a...
Main benefit would be that we can get rid of the Python dependency that ExcelReaders.jl brings along and still support both old a new Excel file formats. The Python dependency...
The example for specifying `colnames` describes it as expecting an `Array{String,1}` when the actual function expects an `Array{Symbol,1}`. (Note that the tests also test using an array of Symbols.)
I want to save a DataFrame as Excel: ``` using DataFrames Herd = [1,1,2,2,2,3,3,3,3]; Sire = ["ZA","AD","BB","AD","AD","CC","CC","AD","AD"]; Yield = [110,100,110,100,100,110,110,100,100]; dat = DataFrame(Herd=Herd, Sire = Sire, Yield = Yield); dat...
