5.2.7 • Published 7 months ago

dbgate-plugin-excel v5.2.7

Weekly downloads
65
License
MIT
Repository
github
Last release
7 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',
  });
excelimportexportdbgatedbgateplugin
@infinitebrahmanuniverse/nolb-dbg@everything-registry/sub-chunk-1453@zalastax/nolb-dbgdbgate-servedbmodel
5.2.7

7 months ago

5.2.7-alpha.1

8 months ago

5.2.6

12 months ago

5.2.5

1 year ago

5.2.4-alpha.1

1 year ago

5.2.4

1 year ago

5.2.3

1 year ago

5.1.7-alpha.13

1 year ago

5.1.7-alpha.14

1 year ago

5.2.2-alpha.13

1 year ago

5.2.2-alpha.12

1 year ago

5.2.2-alpha.11

1 year ago

5.2.2

1 year ago

5.2.1

1 year ago

5.2.0

1 year ago

5.1.5

2 years ago

5.1.4

2 years ago

5.1.6

1 year ago

5.1.3

2 years ago

5.1.2

2 years ago

5.1.1

2 years ago

5.1.0

2 years ago

5.0.9

2 years ago

5.0.8

2 years ago

5.0.7

2 years ago

5.0.6

2 years ago

5.0.6-alpha.2

2 years ago

5.0.4-alpha.2

2 years ago

5.0.4-alpha.7

2 years ago

5.0.4-alpha.8

2 years ago

5.0.0-alpha.1

2 years ago

5.0.5

2 years ago

5.0.3

2 years ago

5.0.2

2 years ago

5.0.1

2 years ago

5.0.0

2 years ago

4.8.8

2 years ago

4.8.5

2 years ago

4.8.4

2 years ago

4.8.7

2 years ago

4.8.6

2 years ago

4.7.4-alpha.12

2 years ago

4.7.4-alpha.10

2 years ago

4.7.4-alpha.15

2 years ago

4.7.4-alpha.16

2 years ago

4.7.4-alpha.14

2 years ago

4.7.2

2 years ago

4.7.4

2 years ago

4.7.3

2 years ago

4.7.4-alpha.1

2 years ago

4.7.4-alpha.3

2 years ago

4.7.4-alpha.2

2 years ago

4.7.4-alpha.8

2 years ago

4.7.4-alpha.7

2 years ago

4.8.1

2 years ago

4.8.0

2 years ago

4.8.3

2 years ago

4.8.2

2 years ago

4.7.3-alpha.3

2 years ago

4.7.3-alpha.5

2 years ago

4.7.3-alpha.2

2 years ago

4.7.1

2 years ago

4.6.3

2 years ago

4.6.2

2 years ago

4.4.4

2 years ago

4.5.0

2 years ago

4.7.0

2 years ago

4.6.1

2 years ago

4.4.3

2 years ago

4.6.0

2 years ago

4.5.1

2 years ago

4.4.2

2 years ago

4.4.5-alpha.1

2 years ago

4.4.1

2 years ago

4.4.0

2 years ago

4.4.0-alpha.2

3 years ago

4.3.4

3 years ago

4.4.0-alpha.1

3 years ago

4.3.3

3 years ago

4.3.2

3 years ago

4.3.1

3 years ago

4.3.0

3 years ago

4.2.8

3 years ago

4.2.7

3 years ago

4.2.6

3 years ago

4.2.5

3 years ago

4.2.4

3 years ago

4.1.9

3 years ago

4.2.3

3 years ago

4.2.2

3 years ago

4.1.10

3 years ago

4.1.11

3 years ago

4.2.1

3 years ago

4.2.0

3 years ago

4.1.12

3 years ago

4.1.8

3 years ago

4.1.7

3 years ago

4.1.4

3 years ago

4.1.3

3 years ago

4.1.6

3 years ago

4.1.5

3 years ago

4.1.1

3 years ago

1.0.8

3 years ago

1.0.7

3 years ago

1.0.6

3 years ago

1.0.5

3 years ago

1.0.4

3 years ago

1.0.3

3 years ago