-
Notifications
You must be signed in to change notification settings - Fork 11
Open
Description
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
I have to use ExcelFiles.save("dat.xlsx",dat) to do it, and save("dat.xlsx",dat) show Errors:
using ExcelFiles
save("dat.xlsx",dat) # Error
ExcelFiles.save("dat.xlsx",dat) # Worked
Error message:
julia> using ExcelFiles
julia> save("dat.xlsx",dat)
ERROR: UndefVarError: save not defined
Stacktrace:
[1] top-level scope at none:0
julia> ExcelFiles.save("dat.xlsx",dat)
My status:
julia> Pkg.status()
Status `C:\Users\Dengfei\.julia\environments\v1.1\Project.toml`
[aae01518] BandedMatrices v0.9.4
[6e4b80f9] BenchmarkTools v0.4.2
[a134a8b2] BlackBoxOptim v0.5.0
[336ed68f] CSV v0.5.9
[324d7699] CategoricalArrays v0.5.5
[3da002f7] ColorTypes v0.8.0
[34da2185] Compat v2.1.0
[8f4d0f93] Conda v1.3.0
[a93c6f00] DataFrames v0.19.1
[1313f7d8] DataFramesMeta v0.5.0
[5721bf48] DataVoyager v0.3.1
[459566f4] DiffEqCallbacks v2.7.0
[01453d9d] DiffEqDiffTools v1.2.0
[0c46a032] DifferentialEquations v6.6.0
[31c24e10] Distributions v0.21.1
[89b67f3b] ExcelFiles v1.0.0
[c04bee98] ExcelReaders v0.11.0
[2fe49d83] Expectations v1.1.0
[442a2c76] FastGaussQuadrature v0.3.3
[1a297f60] FillArrays v0.6.3
[9d5cd8c9] FixedEffectModels v0.7.3
[587475ba] Flux v0.8.3
[f6369f11] ForwardDiff v0.10.3
[38e38edf] GLM v1.1.1
[28b8d3ca] GR v0.41.0
[7073ff75] IJulia v1.19.0
[43edad99] InstantiateFromURL v0.3.0
[a98d9a8b] Interpolations v0.12.2
[b6b21f68] Ipopt v0.5.4
[c9a035f4] JWAS v0.5.4
[4076af6c] JuMP v0.19.2
[5ab0869b] KernelDensity v0.5.1
[b964fa9f] LaTeXStrings v1.0.3
[23fbe1c1] Latexify v0.8.2
[5078a376] LazyArrays v0.9.1
[0fc2ff8b] LeastSquaresOptim v0.7.2
[093fc24a] LightGraphs v1.2.0
[76087f3c] NLopt v0.5.1
[2774e3e8] NLsolve v4.1.0
[429524aa] Optim v0.19.2
[d96e819e] Parameters v0.10.3
[14b8a8f1] PkgTemplates v0.6.1
[91a5bcdd] Plots v0.25.3
[f27b6e38] Polynomials v0.5.2
[92933f4c] ProgressMeter v0.9.0
[d330b81b] PyPlot v2.8.1
[1fd47b50] QuadGK v2.1.0
[fcd29c91] QuantEcon v0.16.1
[1a8c2f83] Query v0.12.0
[612083be] Queryverse v0.3.1
[df47a6cb] RData v0.6.2
[ce6b1742] RDatasets v0.6.3
[d519eb52] RegressionTables v0.2.0
[295af30f] Revise v2.1.6
[f2b01f46] Roots v0.8.1
[90137ffa] StaticArrays v0.11.0
[2913bbd2] StatsBase v0.32.0
[3eaba693] StatsModels v0.5.0
[f3b207a7] StatsPlots v0.11.0
[c3572dad] Sundials v3.6.1
[bd369af6] Tables v0.2.10
[37b6cedf] Traceur v0.3.0
[0ae4a718] VegaDatasets v1.0.0
[112f6efa] VegaLite v0.7.0
[bd07be1c] Winston v0.15.0
[37e2e46d] LinearAlgebra
[9a3f8284] Random
[2f01184e] SparseArrays
[10745b16] Statistics
[8dfed614] Test
Metadata
Metadata
Assignees
Labels
No labels