dbgate-plugin-excel

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',
  });

Changelog

4.6.1

• ADDED: Ability to configure SSH tunnel over environment variables #210 (for docker container)
• ADDED: XML export and import
• ADDED: Archive file - show and edit source text file
• ADDED: Window title shows current tab and database
• ADDED: DbGate documentation
• ADDED: Introduced application layers
• ADDED: Virtual foreign key editor
• ADDED: Application commands (SQL scripts related to database)
• ADDED: Theme can be implemented in plugin
• CHANGED: Dictionary description is stored in app
• FIXED: Unique and index editor
• FIXED: Posibility to edit UNIQUE index flag
• CHANGED: UX improvements of table editor