ReadExcel data with headers not on row 1

[Burtan]

Hey,
how to read excel tables that don't have their headers on the first row? Many scientific applications export their data with printing device information into the first rows and then following with the actual data.

[koperagen]

Hi! readExcel API doesn't support this right now. Would skipRows: Int = 0 parameter work for you? For skipRows = 1 it'll read headers from the second row.

[koperagen]

Btw, what application do you use? Would be interesting to better understand the use cases :)

[Burtan]

A skipRows function would help. It's qPCR data from a thermo scientific machine. I'm testing some code to automate data evaluation in a pathology context.

[koperagen]

Hi! Try 0.9.0-dev-1079 with the fix

[Burtan]

Hey,
it now correctly skips the given rows, but only takes the columns which are also present in the first row. Here is an example of my sheet. It now only reads Well and Well Position as headers.

<style> </style>

Block Type	96-Well 0.2-mL Block
Calibration Background is expired	No
...
Stage/ Cycle where Ct Analysis is performed	Stage1, Step1
User Name
Well	Well Position	Omit	Sample Name	Target Name	Task	Reporter	Quencher

[koperagen]

Oh, i see. You can specify column range as a workaround for now. readExcel(columns = "A:H") Meanwhile, ill commit the fix and hopefully it'll be published soon :)

[Burtan]

Thanks, this works!

[Burtan]

I think the first row after the header is skipped?

[koperagen]

I think the first row after the header is skipped?

Can't reproduce in a test. Can you send a minified example + code that reads it?

[Burtan]

Please try this project. The link expires after 7 days. Thanks!
https://cloud.frederik-bertling.de/f/6ebb5bb52031407f9809/

[koperagen]

Hi!I'm not sure what's going on, but i can't even read this file. Also, when i open it in google sheets / libreoffice calc, i see this:

edit.
Nevermind, file manager messed up files while unarchiving this rar

[Burtan]

I can confirm, it works now. Thanks!