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, …

Thanks, I indeed read the doc too quickly! You need to add the infer_eltypes argument to XLSX.readtable

To take advantage of CSV.read’s eltype capabilities (such as conversion to InlineStrings) and other keyword arguments, something similar to this function may be useful: function exceltodf(path, file, sheetname) inp = joinpath(path, file) io = IOBuffer() CSV.write(io, DataFrame(XLSX.read…

XLSX and DataFrame column type

General Usage

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

Check this post and thread.

3 Likes

Topic		Replies	Views
Converting XLSX.Worksheet to DataFrame Data xlsx , excel	5	1260	February 16, 2024
How to directly specify datatype when reading from excel? Matrix{Any} to Vector{Int64} General Usage question , type , excel	4	338	October 18, 2022
How to change field names and types of a DataFrame Data question	14	6908	August 1, 2020
How to coerce types from data loaded via ExcelFiles.jl General Usage	1	350	August 3, 2020
Writing excel from dataframes New to Julia	7	400	March 18, 2025

XLSX and DataFrame column type

Related topics