python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - phpspreadsheet

How to set the encode in PhpSpreadsheet\Reader\Xlsx?

I want to use PhpSpreadsheet convert xlsx to pdf, it's succeed. But the Chinese word in xlsx is error. And the setInputEncoding method is not found. What can I do? please give me guide $reader = new ...
test-img

shawn

encode

phpspreadsheet

Votes: 0

Answers: 2

Latest Answer

You can set Font Family in file xlsx. $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx(); $spreadsheet = $reader->load($public['root'].'/' . $fileName); $styleArray = array( 'font' => a...
test-img

poppies

is there a way to put placeholders in excel files using phpspreadsheet?

is there any way to get placeholders in my excel file using phpspreadsheet? all I see I can do is using a specific cell to put my data into it eg. setCellValue('A1','John') I want to insert data into ...
test-img

CTD

php

phpexcel

phpspreadsheet

phpoffice-phpspreadsheet

Votes: 0

Answers: 1

Latest Answer

You can try it. $spreadSheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet; $placeholder = 'D' $i = 5; $spreadSheet->getActiveSheet()->setCellValue($placeholder . $i, 'John');
test-img

poppies

Display time range formatted with PhpSpreadsheet

I'm using PHPSpreadsheet to generate an XLS file with report data, and in some situations, display an XLS formatted as HTML on screen. How can I display a formatted time range in an Excel worksheet? I...
test-img

Tom

php

phpspreadsheet

phpoffice-phpspreadsheet

Votes: 0

Answers: 1

Latest Answer

Sometimes time ranges are a bit tricky. The easyer way is: You can make a Time string with plane php and use a text column to store the data.
test-img

Collie-IT Anne K. Frey

Why function getRange in my Apps Script dont work?

Can anyone help me with my problem please? Usually the syntax never error, but from yesterday the "getRange" always error and i dont know why. I made a new files and is still the same. can ...
test-img

Dwicahya Prasetya

google-sheets

google-sheets-api

spreadsheet

phpspreadsheet

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs