"Skip" parameter XLSX package

New to Julia
, ,
1

Hi everyone,

I am basically “translating” a R code into a Julia code, here is one of the line of the R code :

read_excel(‘Results.xlsx’, sheet = ‘x’, col_names = FALSE, col_types = “numeric”, na = “”, skip = 0)

To do the same thing in Julia I am using XLSX.readtable, is there a parameter like “skip” with this package ?

Thank you,

2

Check the parameter first_row in XLSX.gettable(). See syntax here.

using DataFrames, XLSX

df = XLSX.openxlsx("myfile.xlsx") do xf
     DataFrame(XLSX.gettable(xf["mysheet"])...)
end
1 Like
3

Thanks !