excel-tools

"use strict";
Object.defineProperty(exports, "__esModule", { value: true });
exports.toolsProvider = toolsProvider;
const data_1 = require("./tools/data");
const sheets_1 = require("./tools/sheets");
const formatting_1 = require("./tools/formatting");
const charts_1 = require("./tools/charts");
const vba_1 = require("./tools/vba");
const analysis_1 = require("./tools/analysis");
async function toolsProvider(_ctl) {
    return [
        ...(0, data_1.getDataTools)(), // 12 tools: read, write, append, filter, sort, delete, update, merge, find/replace, dedup, rename cols, add col
        ...(0, sheets_1.getSheetTools)(), //  7 tools: list, create, delete, rename, copy, move, copy rows between
        ...(0, formatting_1.getFormattingTools)(), //  7 tools: format cells, conditional format, freeze, dimensions, data validation, comment, hyperlink
        ...(0, charts_1.getChartTools)(), //  1 tool:  create chart (real Excel XML — bar, barh, line, area, pie, doughnut, scatter)
        ...(0, vba_1.getVbaTools)(), //  1 tool:  read VBA from .xlsm
        ...(0, analysis_1.getAnalysisTools)(), //  7 tools: summarize, pivot, diff, validate, query, split sheet, info
    ];
    // Total: 35 tools
}
//# sourceMappingURL=toolsProvider.js.map