How to ignore header line.

[mnosuk]

Hi folk. we are using "json-to-csv-export": "^2.1.1"

here is an example of json.

[
    {
        "A": "TEST",
        "B": "sdd",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    },
    {
        "A": "",
        "B": "",
        "C": "",
        "D": "",
        "E": "",
        "F": "",
        "G": "",
        "H": "",
        "I": "",
        "J": ""
    }
]


csvDownload({
            data: e,
            filename: "Grid_Data",
            delimiter: ",",
            headers: []
        })

the expected behavior is, I want data to start at first row like this.

but actual behavior is

I also tried with undefined header (and also remove it out), the result is

Any misconfiguration? please advice.

[coston]

Hey @mnosuk! Having no headers is not supported by this package. In most cases it's a bad practice to exclude headers, so there is nothing to simplify that process here.

You probably have a very valid reason to exclude them, so in this case, I would provide empty labels to the headers prop. This will achieve what you're aiming to do.

() => {
  const mockData = [
    {
      id: 1,
      firstName: "Sarajane",
      lastName: "Wheatman",
      email: "[email protected]",
      language: "Zulu",
      ip: "40.98.252.240",
    },
    {
      id: 2,
      firstName: "Linell",
      lastName: "Humpherston",
      email: "[email protected]",
      language: "Czech",
      ip: "82.225.151.150",
    },
  ];

  const headers = [
    { key: "id", label: "" },
    { key: "firstName", label: "" },
    { key: "lastName", label: "" },
    { key: "email", label: "" },
    { key: "language", label: "" },
    { key: "ip", label: "" },
  ];

  return (
    <button onClick={() => jsonToCsvExport({ data: mockData, headers })}>
      Download Data
    </button>
  );
};

[mnosuk]

Hi. @coston using const headers = [ { key: "id", label: "" }, { key: "firstName", label: "" }, { key: "lastName", label: "" }, { key: "email", label: "" }, { key: "language", label: "" }, { key: "ip", label: "" }, ];

will be the same result as

headers = [];

we still get the empty first line that I actually want to remove that line.

is it possible to add for changes?

[coston]

Ahh, @mnosuk, sorry for overlooking that detail. It would be nothing to add something like an omitHeaders option to do what you are looking for.

jsonToCsvExport({ data, omitHeaders: true })}

Would you like to contribute this feature?