yidas / phpspreadsheet-helper Goto Github PK

src/phpSpreadsheet/Helper.php

just add the STYLE condition into merge condition

for example
$rows->getRow()
work like
$amount= $rows->getRow('amout')
??

The helper method getRows ignores the defined offset if lesser than defined rows exists. The purpose of this method is to skip rows (e.g. the title rows when importing data). Instead of ignoring it an empty result should be returned.

Can you supported % and thousand cell style ?

How to setDelimiter CSV?

I want export my user table, it has a nickname field

example:

$xls = Helper::newSpreadsheet();
$xls->addRow(['=^･ω･^=']);
$xls->save('test.xlsx');

then report an error:

[PhpOffice\PhpSpreadsheet\Calculation\Exception]
Worksheet!A1 -> Formula Error: Unexpected operator '^'

Is this a BUG? Or is my usage wrong?

It possible set cell format to percent ?
And set some color or border to cell or cell group?

i tried below code to add a new line inside cell, but it not working.
$time_till.'\n'.$request['time_till']

Its possible set chart?