antsugdev83/simple-xlsx

There is no license information available for the latest version (1.0.0) of this package.

Simple create file xlsx

Maintainers

Details

github.com/AntsugDev/simple-xlsx

Source

Issues

Installs: 0

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 1

Forks: 0

Open Issues: 0

1.0.0 2025-02-11 16:13 UTC

Requires

Unknown License c1618b1aefd00bbacb6ecb87fc897ac3c4c5c841

  • Antonio Sugamele <antonio.sugamele.woop@gmail.com>

This package is auto-updated.

Last update: 2025-06-18 11:37:01 UTC

README

This project have scope simplify use plugin php spreadsheet.

This project create class for management creation file xlsx; into this class it's possible define:

  • plus sheets
  • header difference by number sheets
  • possibility custom font color and background single colunm
  • possibility custom define (if single sheet) define name single sheet
  • possibility added before table, of information additional
  • possibility create, after creation file xlsx, the zip

Use

Into directory example, they are found example code. In general, from user respect this sequence:

  1. instance class
$xlsx = new \Anton\SimpleXlsx\SimpleXlsx($header,'standard',null,1,null,$pathBase,null,null);
  1. instane headers and sheets
 $row  = $xlsx->setSpreadsheet();

This define initial base row.

  1. Read your data and call method for create body:
 $xlsx->setBodyCell(0,0,$row,$item['name'],$color);
  1. Save file
$xlsx->save();

DETAILS OF ARGUMENTS FROM THE INSTANCE CLASS AND FROM THE PRINCIPAL FUNCTION INTO CLASS

INSTANCE

  1. header: array header file; this array it must be how example:
$headeres = [ [] ]
  1. title : name file
  2. sheets: array one-dimensional and value into this it must be string
  3. default row: this define where it begins table. Default is defined to 1; if greater one, table after the row defined
  4. extra data: this can to be string or array; if is defined and defaultRow greater one, into the file xlsx is positioned before table
  5. pathbase: is directory of save file
  6. len: if defined extradata this represents the columns length
  7. extracolor: array, represents the possibility change color font and background

FUNCTION

setSpreadsheet

This function create header and sheets.

The arguments are:

  1. background: you can to be null, if is defined represents color of background the columns from header
  2. color: you can to be null, if is defined represents color of font the columns from header
  3. name sheet: you can to be null, if is defined only sheet and represents name of sheet

setBodyCell

With this function is created column from the body.

The arguments are:

  • index sheet
  • index column (if zero example A0,B0,ec..)
  • row
  • data
  • boolean value: if true define background column difference ('F2F3F4' or 'EAEDED')
  • position text : left,center or rigth
  • number format data: for this argument it is postponed NumberFormat
  • fill: the possibility custom background color column and bold or not bold text; this is an array

save

This function create file. It's possible call this function with argument ZipArchive; if this is defined the function create zip with file xlsx.

EXAMPLE