JavaScript API: getCellPositions

CONTENTS

LAYOUTS

SETTINGS

TEMPLATES

OTHERS

getCellPositions

PREMIUM

TRIAL / ADVANCED

Gets existing cell positions from the active sheet.

Note

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

Description

getCellPositions (): Map<string, string[]>

Code samples

Example #1

import { CreateXlsx, OptionsCellContents } from "build";

const xlsx = new CreateXlsx();

let content: OptionsCellContents = {
    text: "Lorem ipsum dolor sit amet",
};
xlsx.addCell(content, "A1");

content = {
    text: "Lorem ipsum",
};
xlsx.addCell(content, "A2");

console.log(xlsx.getCellPositions());

content = {
    text: "Sed ut perspiciatis unde omnis",
    italic: true,
    underline: "single",
};
xlsx.addCell(content, "B5");

content = {
    text: "At vero eos et accusamus et iusto",
    color: "13775F",
};
xlsx.addCell(content, "F2");

content = {
    text: "Lorem ipsum dolor sit amet",
    bold: true,
    font: "Times New Roman",
    strikethrough: true,
};
xlsx.addCell(content, "AA3");

console.log(xlsx.getCellPositions());

Release notes

phpxlsx 5.0:
- new method.