excel-xvba
TypeScript icon, indicating that this package has built-in type declarations

1.0.3-b • Public • Published

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

Info - Edit vba on VSCode with XVBA:

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!

Package Sidebar

Install

npm i excel-xvba

Homepage

www.xvba.dev

Weekly Downloads

4

Version

1.0.3-b

License

MIT

Unpacked Size

25.6 kB

Total Files

14

Last publish

Collaborators

  • aeraphe