While I try to change header titles by passing array of titles to options like below it does not override the headers. Instead it writes new headers first and original data with old headers again from next cell.

I am experiencing the same problem.

In addition, sheets js is mutating the header array passed in, which is not something I would ever expect.

Example:

const head

It would be great to have the option "skip N lines", since CSV files often contain not commented headers. Can this be implemented?
For example:

This is a data file generated by some old software.
Next line will contain a headers of parameters.
Temperature, Humidity, Voltage
22.5, 45.5, 220
23.0, 44.0, 219
...
In such case "skipLines: 2" could be added to con

When creating a dump from OpenEdge (Progress) database, boolean fields will contain the following values:

• "yes" - true
• "no" - false
• "?" - null. I am assuming that everything else than yes/no is null here.

I'm not sure how feasible this may be, but the old logparser program from Microsoft supported queries like

Select * from test.csv

And it would read from test.csv, without needing any config files.