JavaScript API: removeVariableText

CONTENTS

addBreak
addCell
addFunction
addImage
addLink
addSheet
getCell
removeCell
setCellValue

LAYOUTS

getActiveSheet
getCellPositions
setActiveSheet
setRtl

SETTINGS

addProperties
setColumnSettings
setRowSettings
setSheetSettings
setWorkbookSettings

TEMPLATES

getTemplateVariables
openTemplate
removeVariableImage
removeVariableText
replaceVariableImage
replaceVariableText
setTemplateSymbols

OTHERS

convertMeasuringUnit
save

removeVariableText

PREMIUM

TRIAL / ADVANCED

Removes text variables.

Note

You are reading the JavaScript API documentation. For the PHP API method please go to removeVariableText.

Description

removeVariableText (variables: string[], target: Target = "sheets"): this

type Target = "sharedStrings" | "sheets" | "workbook";

Code samples

import { CreateXlsx } from "build";
import * as fs from "fs";

const xlsxTemplate = fs.readFileSync("template.xlsx").buffer;

const xlsx = new CreateXlsx();
xlsx.openTemplate(xlsxTemplate).then(xlsx => {
    const variables = ["VAR_1", "VAR_2"];
    xlsx.removeVariableText(variables, "sheets");

    xlsx.save().then(contents => {
        fs.writeFileSync("removeVariableText_1.xlsx", Buffer.from(contents));
    });
});

Release notes

phpxlsx 5.0:
- new method.