dbgate-plugin-excel
Advanced tools
MS Excel import/export plugin for 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);
Reads tabular data from one sheet in MS Excel file.
const reader = await dbgatePluginExcel.shellApi.reader({
fileName: 'test.xlsx',
sheetName: 'Album',
limitRows: null
});
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',
});
4.6.1
FAQs
MS Excel import/export plugin for DbGate
The npm package dbgate-plugin-excel receives a total of 942 weekly downloads. As such, dbgate-plugin-excel popularity was classified as not popular.
We found that dbgate-plugin-excel demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 0 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
A threat actor's playbook for exploiting the npm ecosystem was exposed on the dark web, detailing how to build a blockchain-powered botnet.
Security News
NVD’s backlog surpasses 20,000 CVEs as analysis slows and NIST announces new system updates to address ongoing delays.
Security News
Research
A malicious npm package disguised as a WhatsApp client is exploiting authentication flows with a remote kill switch to exfiltrate data and destroy files.