vue-json-to-csv-async

A Vue.js 2 component to transform and download a json in csv format https://github.com/nemanjagajic/vue-json-to-csv

Installation

npm install --save vue-json-to-csv-async or yarn add vue-json-to-csv-async

Usage

For vue-cli user:

import VueJsonToCsv from 'vue-json-to-csv-async'

If you just want to use component

import VueJsonToCsv from 'vue-json-to-csv-async/src/JsonToCsv'

For standalone usage:

<script src="vue.min.js"></script>
<!-- must place this line after vue.js -->
<script src="dist/vue-json-to-csv.min.js"></script>
<script type="text/javascript">
  Vue.use(VueJsonToCsv);
</script>

Sample 1 (simple use)

Simple usage: will generate a default button. The csv will include all the labels (name, surname) and the data

<vue-json-to-csv :json-data="[
    { name: 'Joe', surname: 'Roe' },
    { name: 'John', surname: 'Doe' }
  ]">
</vue-json-to-csv>

If you want, you can pass async function which will return an array instead of just passing plain array

<vue-json-to-csv :json-data-generator="getItemsToExport">
</vue-json-to-csv>

Result csv

csv.csv

| name | surname | |----------|------| | Joe | Roe | | John | Doe |

Sample 2 (filter labels)

Selected labels with custom csv title: will generate a custom button as defined at the slot. The csv will include only the "name" label with the "First name" title and the relevant data.

<vue-json-to-csv :json-data="[
    { name: 'Joe', surname: 'Roe' },
    { name: 'John', surname: 'Doe' }
  ]"
  :labels="{ name: { title: 'First name' } }"
  :csv-title="My_CSV"
  >
  <button>
    <b>My custom button</b>
  </button>
</vue-json-to-csv>

Result csv

My_CSV.csv

| First name | |----------| | Joe | | John |

Sample 3 (handle success/error, custom button, configure labels)

Handle success/error with custom button, returns specific labels with custom title: use of custom methods on success or error.

<vue-json-to-csv :json-data="[
    { name: 'John', surname: 'Doe', age: 20, salary: 20.000, hours: 37.4 },
    { name: 'John', surname: 'Roe', age: 40, salary: 40.000, hours: 35.2 },
    { name: 'Jane', surname: 'Woe', age: 50, salary: 52.000, hours: 30.4 }
  ]"
  :labels="{
    name: { title: 'First name' },
    salary: { title: 'Annual salary' },
    hours: { title: 'Hours/week' }
  }"
  @success="val => handleSuccess(val)"
  @error="val => handleError(val)">
  <button>
    <b>My custom button</b>
  </button>
</vue-json-to-csv>

Configuration

| Prop | Details | |----------|------| | json-data | Array of the objects which contain the data to display (required). Each key will be a different column at the csv. All the objects should contain the same keys. If empty array an error will be returned. Example: [ { name: 'Joe', surname: 'Roe' }, { name: 'Joe', surname: 'Doe' }]| | show-labels | Boolean. If false the first row of the csv will not contain the labels names. | | labels | An object of the keys of the labels will be displayed. Use to filter the keys to display and modify their label title. For each key we provide the title of the key to displayed. If not defined all the keys will be parsed. Example: { name: { title: 'First name' } }| | csv-title | String. The title of the generated csv. Default: 'csv' | | separator | String. The separator of the columns. Default: ',' | | @update:error | Will be triggered in case of an empty json array, if the labels object has not children or any parsing issue | | @update:success| Will be triggered in case of a successful csv creation |