Hello everyone :grin:, I want to load an excel file with the XLSX.jl package and then convert it to DataFrame with DataFrame.jl with the following code: data = DataFrame(XLSX.readtable(path_data, "Sheet1")) However, the type of all columns is automatically set to Any. This is very annoying when, …

XLSX and DataFrame column type

rafael.guerra February 25, 2024, 4:34pm 2

Check this post and thread.

3 Likes

Topic		Replies	Views
DataFrame : eltypes with variable length Data data	2	1007	September 21, 2017
Converting XLSX.Worksheet to DataFrame Data xlsx , excel	5	1008	February 16, 2024
How to coerce types from data loaded via ExcelFiles.jl General Usage	1	318	August 3, 2020
How to directly specify datatype when reading from excel? Matrix{Any} to Vector{Int64} General Usage question , type , excel	4	297	October 18, 2022
Converting XLSX to DataFrame General Usage dataframes , xlsx	2	1117	November 8, 2021