Global

Members

WDataCsv

Description:

• 讀寫CSV檔

Source:

• WDataCsv.mjs, line 363

Example

import wdc from './src/WDataCsv.mjs'

let fpIn = './g-test-in.csv'
wdc.readCsv(fpIn)
    .then((ltdtIn) => {
        console.log(ltdtIn)
        // => [ { NAME: 'Daffy Duck', AGE: '24' }, { NAME: 'Bugs 邦妮', AGE: '22' } ]
    })
    .catch((err) => {
        console.log(err)
    })

let ltdtOut = [{ name: '大福 Duck', value: 2.4 }, { name: 'Bugs 邦妮', value: '2.2' }]
let fpOut = './g-test-out.csv'
wdc.writeCsv(fpOut, ltdtOut)
    .then((res) => {
        console.log(res)
        // => finish
    })
    .catch((err) => {
        console.log(err)
    })

Methods

(async) parseCsv(inp, optopt) → {Promise}

Description:

• 解析CSV字串

Source:

• WDataCsv.mjs, line 128

Example

import wdc from './src/WDataCsv.mjs'

let fp = './g-test-in.csv'

let c = fs.readFileSync(fp, 'utf8')

await wdc.parseCsv(c)
    .then((ltdt) => {
        console.log(ltdt)
        // => [ { NAME: 'Daffy Duck', AGE: '24' }, { NAME: 'Bugs 邦妮', AGE: '22' } ]
    })
    .catch((err) => {
        console.log(err)
    })

await wdc.parseCsv(c, { mode: 'mat' })
    .then((mat) => {
        console.log(mat)
        // => [ [ 'NAME', 'AGE' ], [ 'Daffy Duck', '24' ], [ 'Bugs 邦妮', '22' ] ]
    })
    .catch((err) => {
        console.log(err)
    })

Parameters:

Returns:

Type

Promise

(async) readCsv(fp, optopt) → {Promise}

Description:

• 讀取CSV檔，自動清除BOM

Source:

• WDataCsv.mjs, line 186

Example

import wdc from './src/WDataCsv.mjs'

let fp = './g-test-in.csv'

wdc.readCsv(fp)
    .then((ltdt) => {
        console.log(ltdt)
        // => [ { NAME: 'Daffy Duck', AGE: '24' }, { NAME: 'Bugs 邦妮', AGE: '22' } ]
    })
    .catch((err) => {
        console.log(err)
    })

wdc.readCsv(fp, { mode: 'mat' })
    .then((mat) => {
        console.log(mat)
        // => [ [ 'NAME', 'AGE' ], [ 'Daffy Duck', '24' ], [ 'Bugs 邦妮', '22' ] ]
    })
    .catch((err) => {
        console.log(err)
    })

Parameters:

Returns:

Type

Promise

(async) writeCsv(fp, data, optopt) → {Promise}

Description:

• 輸出數據至CSV檔案

Source:

• WDataCsv.mjs, line 230

Example

import wdc from './src/WDataCsv.mjs'

let ltdt = [{ name: '大福 Duck', value: 2.4 }, { name: 'Bugs 邦妮', value: '2.2' }]

let fp = './g-test-out.csv'

wdc.writeCsv(fp, ltdt)
    .then((res) => {
        console.log(res)
        // => finish
    })
    .catch((err) => {
        console.log(err)
    })

Parameters:

Returns:

Type

Promise