JavaScript API: addProperties

CONTENTS

LAYOUTS

SETTINGS

TEMPLATES

OTHERS

addProperties

PREMIUM

TRIAL / ADVANCED

Adds XLSX spreadsheet properties.

Note

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

Description

addProperties (options: OptionsProperties): this

interface OptionsProperties {
    /** Category */
    category?: string;
    /** Company */
    company?: string;
    /** Created date. W3CDTF without time zone */
    created?: string;
    /** Creator */
    creator?: string;
    /** Description */
    description?: string;
    /** Keywords */
    keywords?: string;
    /** Last modified by */
    lastModifiedBy?: string;
    /** Manager */
    manager?: string;
    /** Modified date. W3CDTF without time zone */
    modified?: string;
    /** Revision */
    revision?: string;
    /** Subject */
    subject?: string;
    /** Title */
    title?: string;
}

Code samples

Example #1

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

const xlsx = new CreateXlsx();

// add properties
const properties: OptionsProperties = {
    company: "My company",
    category: "My category",
    creator: "My creator",
    description: "The description could be much longer than this.",
    keywords: "keyword 1, keyword 2, keyword 3",
    manager: "My manager",
    subject: "My subject",
    title: "My title",
};
xlsx.addProperties(properties);

// add date properties
const propertiesDate: OptionsProperties = {
    created: "2016-11-21T09:00:00Z", // force a value
    modified: new Date().toISOString(), // dynamic value
};
xlsx.addProperties(propertiesDate);

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

Release notes

phpxlsx 5.0:
- new method.