Package Exports

excel-xvba

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (excel-xvba) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

ExcelXvba

Excel Librar for Read, manipulate and write spreadsheet. (With Auto-Completion)
See www.xvba.dev, for more info.

If you want to create your own Windows COM Like this package See xvba-com package

XvbaCom

Info - Edit vba on VSCode with XVBA:

www.xvba.dev

Importing

import {ExcelXvba} from "excel-xvba"

const excel = new ExcelXvba();

excel.Visible();

const  xlPath = path.join(__basedir,"index.xlsb");

const Book: WorkBook = excel.WorkBooks.Open(xlPath);

const sheets = excel.Sheets;

const total = sheets.Count();

const exName = excel.Name();

excel.Quit();

//Close C++ COMs 
Excel.CloseAllCOMWithDelay();

Contributions

Contributions are very welcome!