CODEWITHSUNDEEP
javascriptexcelsqlconnectionexceljs
S. Bailey
S. Bailey

Reputation: 1

exceljs way to import file and see connection string

I'm working to create an application that replaces a series of excel files. From looking at exceljs it is easy to import an xlsx file and see some of the workbook properties but I need to save all the connection strings (data > queries & connections > connection properties > connection string and command text (query)).

const ExcelJS = require('exceljs');

var workbook = new ExcelJS.Workbook(); 
workbook.xlsx.readFile('a.xlsx')
    .then(function() {
        console.log('Workbook properties')
        console.log(workbook.getWorksheet(9))
    });

this is where I would go to see the sql database connection in excel: sql connection setting

Upvotes: 0

Views: 114

Answers (0)

Related Questions