6.2.1 • Published 9 months ago

dbgate-plugin-excel v6.2.1

Weekly downloads
65
License
GPL-3.0
Repository
github
Last release
9 months ago

styled with prettier NPM version

dbgate-plugin-excel

MS Excel import/export plugin for DbGate

Usage without DbGate

Export from fake object reader into MS Excel file. Fake object file can be replaced with other reader/writer factory functions, as described in dbgate-api package

const dbgateApi = require('dbgate-api');
const dbgatePluginExcel = require("dbgate-plugin-excel");

dbgateApi.registerPlugins(dbgatePluginExcel);


async function run() {
  const reader = await dbgateApi.fakeObjectReader();
  const writer = await dbgatePluginExcel.shellApi.writer({ fileName: 'myfile1.xlsx', sheetName: 'Sheet 1' });
  await dbgateApi.copyStream(reader, writer);
  console.log('Finished job script');
}
dbgateApi.runScript(run);

Factory functions

shellApi.reader

Reads tabular data from one sheet in MS Excel file.

  const reader = await dbgatePluginExcel.shellApi.reader({
    fileName: 'test.xlsx',
    sheetName: 'Album',
    limitRows: null
  });

shellApi.writer

Writes tabular data into MS excel file. There could be more writes into the some file in one script, if property sheetName is different.

  const reader = await dbgatePluginExcel.shellApi.writer({
    fileName: 'test.xlsx',
    sheetName: 'Album',
  });
excelimportexportdbgatedbgatebuiltin
lodashxlsx
@infinitebrahmanuniverse/nolb-dbg@everything-registry/sub-chunk-1453@zalastax/nolb-dbgdbmodeldbgate-servedbgate-serve-premium
6.2.1

9 months ago

6.2.0

10 months ago

6.1.6

10 months ago

6.1.5

10 months ago

6.1.4

10 months ago

6.1.3

11 months ago

6.1.2

11 months ago

6.1.1

11 months ago

6.1.0

12 months ago

6.0.0-alpha.1

12 months ago

6.0.0

12 months ago

5.5.7-alpha.68

12 months ago

5.5.7-alpha.60

1 year ago

5.5.7-alpha.50

1 year ago

5.5.7-alpha.53

1 year ago

5.5.7-alpha.51

1 year ago

5.5.7-alpha.47

1 year ago

5.5.7-alpha.45

1 year ago

5.5.7-alpha.44

1 year ago

5.5.7-alpha.48

1 year ago

5.5.7-alpha.32

1 year ago

5.5.7-alpha.33

1 year ago

5.5.7-alpha.25

1 year ago

5.5.7-alpha.29

1 year ago

5.5.7-alpha.28

1 year ago

5.5.7-alpha.27

1 year ago

5.5.7-alpha.26

1 year ago

5.5.7-alpha.16

1 year ago

5.5.6

1 year ago

5.4.5-alpha.5

1 year ago

5.4.5-alpha.3

1 year ago

5.4.5-alpha.4

1 year ago

5.4.4

1 year ago

5.4.3

1 year ago

5.4.2

1 year ago

5.4.1

1 year ago

5.4.0

1 year ago

5.5.4-alpha.3

1 year ago

5.5.4-alpha.4

1 year ago

5.5.4-alpha.7

1 year ago

5.5.4-alpha.8

1 year ago

5.5.4-alpha.1

1 year ago

5.5.4-alpha.2

1 year ago

5.5.5

1 year ago

5.5.4

1 year ago

5.5.3

1 year ago

5.5.2

1 year ago

5.5.1

1 year ago

5.3.4

1 year ago

5.3.3

1 year ago

5.3.1

1 year ago

5.3.0

1 year ago

5.2.9

2 years ago

5.2.8

2 years ago

5.2.7

2 years ago

5.2.7-alpha.1

2 years ago

5.2.6

3 years ago

5.2.5

3 years ago

5.2.4-alpha.1

3 years ago

5.2.4

3 years ago

5.2.3

3 years ago

5.1.7-alpha.13

3 years ago

5.1.7-alpha.14

3 years ago

5.2.2-alpha.13

3 years ago

5.2.2-alpha.12

3 years ago

5.2.2-alpha.11

3 years ago

5.2.2

3 years ago

5.2.1

3 years ago

5.2.0

3 years ago

5.1.5

3 years ago

5.1.4

3 years ago

5.1.6

3 years ago

5.1.3

3 years ago

5.1.2

3 years ago

5.1.1

3 years ago

5.1.0

3 years ago

5.0.9

3 years ago

5.0.8

3 years ago

5.0.7

3 years ago

5.0.6

3 years ago

5.0.6-alpha.2

3 years ago

5.0.4-alpha.2

3 years ago

5.0.4-alpha.7

3 years ago

5.0.4-alpha.8

3 years ago

5.0.0-alpha.1

4 years ago

5.0.5

3 years ago

5.0.3

3 years ago

5.0.2

4 years ago

5.0.1

4 years ago

5.0.0

4 years ago

4.8.8

4 years ago

4.8.5

4 years ago

4.8.4

4 years ago

4.8.7

4 years ago

4.8.6

4 years ago

4.7.4-alpha.12

4 years ago

4.7.4-alpha.10

4 years ago

4.7.4-alpha.15

4 years ago

4.7.4-alpha.16

4 years ago

4.7.4-alpha.14

4 years ago

4.7.2

4 years ago

4.7.4

4 years ago

4.7.3

4 years ago

4.7.4-alpha.1

4 years ago

4.7.4-alpha.3

4 years ago

4.7.4-alpha.2

4 years ago

4.7.4-alpha.8

4 years ago

4.7.4-alpha.7

4 years ago

4.8.1

4 years ago

4.8.0

4 years ago

4.8.3

4 years ago

4.8.2

4 years ago

4.7.3-alpha.3

4 years ago

4.7.3-alpha.5

4 years ago

4.7.3-alpha.2

4 years ago

4.7.1

4 years ago

4.6.3

4 years ago

4.6.2

4 years ago

4.4.4

4 years ago

4.5.0

4 years ago

4.7.0

4 years ago

4.6.1

4 years ago

4.4.3

4 years ago

4.6.0

4 years ago

4.5.1

4 years ago

4.4.2

4 years ago

4.4.5-alpha.1

4 years ago

4.4.1

4 years ago

4.4.0

4 years ago

4.4.0-alpha.2

4 years ago

4.3.4

4 years ago

4.4.0-alpha.1

4 years ago

4.3.3

4 years ago

4.3.2

4 years ago

4.3.1

4 years ago

4.3.0

4 years ago

4.2.8

4 years ago

4.2.7

4 years ago

4.2.6

4 years ago

4.2.5

4 years ago

4.2.4

4 years ago

4.1.9

5 years ago

4.2.3

5 years ago

4.2.2

5 years ago

4.1.10

5 years ago

4.1.11

5 years ago

4.2.1

5 years ago

4.2.0

5 years ago

4.1.12

5 years ago

4.1.8

5 years ago

4.1.7

5 years ago

4.1.4

5 years ago

4.1.3

5 years ago

4.1.6

5 years ago

4.1.5

5 years ago

4.1.1

5 years ago

1.0.8

5 years ago

1.0.7

5 years ago

1.0.6

5 years ago

1.0.5

5 years ago

1.0.4

5 years ago

1.0.3

5 years ago