CSV

CSV is a common data exchange format that stores tabular data in a plain text file. A CSV file stores the data in a delimited text file that uses commas to separate the values.

Since version 0.16.5, th following code returns a null worksheet:
XLSX.utils.json_to_sheet([], {header: columns})

Is it now working as it is wanted? If so, how could we create an empty worksheet? In my case it is expected that sometimes the data is an empty array. And an empty worksheet only with headers is expected.

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

@dimitri

Originally posted by @dimitri in https://github.com/dimitri/pgloader/timeline

That's good thinking, and I think that's relevant for another PR. The PR introducing the statistics singleton should also take care of the following bits of refactoring of the code:

the singleton is named “state” as I initially though I would update the global state of the migration to be able to know

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.

Jul	AUG	Sep
	24
2019	2020	2021

CSV

Here are 4,367 public repositories matching this topic...

SheetJS / sheetjs

d2-projects / d2-admin

mholt / PapaParse

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:

Maatwebsite / Laravel-Excel

modood / Administrative-divisions-of-China

harelba / q

BurntSushi / xsv

dbohdan / structured-text-tools

asmuth / clip

mledoze / countries

ServiceStack / ServiceStack

tabulapdf / tabula

simonw / datasette

box / spout

dimitri / pgloader

adaltas / node-csv

thephpleague / csv

johnkerl / miller

mbloch / mapshaper

cube2222 / octosql

antonycourtney / tad

django-import-export / django-import-export

tobegit3hub / tensorflow_template_application

Cleveroad / AdaptiveTableLayout

Keyang / node-csvtojson

kantord / just-dashboard

codingforentrepreneurs / 30-Days-of-Python

lukes / ISO-3166-Countries-with-Regional-Codes

eBay / tsv-utils

davyxu / tabtoy

Related Topics

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: