Here is my code snipped, for an excel file, where the first line with data starts at line number 4 and I know that in column one is the time and in column 2 the H2-flow:
fn_sel = "yourfilename.xlsx"
t_vec = Vector{Float64}(undef, 0)
ΦH2 = Vector{Float64}(undef, 0)
XLSX.openxlsx(fn_sel, enable_cache = false) do xf
name_sheet1 = XLSX.sheetnames(xf)[1]
sheet = xf[name_sheet1]
for i_sr in XLSX.eachrow(sheet) # sr = sheet raw
rownum = XLSX.row_number(i_sr)
if rownum > 3
# println("t: ", i_sr["A"], " s")
if ~isempty(i_sr["A"]) && ~isempty(i_sr["B"])
push!(t_vec, i_sr["A"])
push!(ΦH2, i_sr["B"])
end
end
end
end
thanks, trying this solution now. A bit strange that I haven’t found a reliable way to programmaticaly import and read a bunch of excel files for analysis in Julia.