Security News
Introducing the Socket Python SDK
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
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.7.3
FAQs
MS Excel import/export plugin for DbGate
The npm package dbgate-plugin-excel receives a total of 314 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.
Security News
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
Security News
Floating dependency ranges in npm can introduce instability and security risks into your project by allowing unverified or incompatible versions to be installed automatically, leading to unpredictable behavior and potential conflicts.
Security News
A new Rust RFC proposes "Trusted Publishing" for Crates.io, introducing short-lived access tokens via OIDC to improve security and reduce risks associated with long-lived API tokens.