The Vtiful\Kernel\Excel class

(PECL xlswriter >= 1.2.1)

Introduction

Create xlsx files and set cells and output xlsx files

Class synopsis

classVtiful\Kernel\Excel {
public__construct(array$config)
publicaddSheet(string$sheetName)
publicautoFilter(string$scope)
publicconstMemory(string$fileName, string$sheetName = ?)
publicdata(array$data)
publicfileName(string$fileName, string$sheetName = ?)
publicgetHandle()
publicheader(array$headerData)
publicinsertFormula(int$row, int$column, string$formula)
publicinsertImage(int$row, int$column, string$localImagePath)
publicinsertText(
    int$row,
    int$column,
    int|float|string$data,
    string$format = ?
)
publicmergeCells(string$scope, string$data)
publicoutput()
publicsetColumn(string$range, float$width, resource$format = ?)
publicsetRow(string$range, float$height, resource$format = ?)
}

Table of Contents

To Top