PhpSpreadsheet is a library written in pure PHP and providing a set of classes that allow you to read from and to write to different spreadsheet file formats, like Excel and LibreOffice Calc.
I fill out a spreadsheet with the information of a person, however, names like D'anna generate a problem in xlsx. D'anna has a square box in place of the apostrophe '.
The form of writing that I use is this:
$writer =…
I'm working on a Drupal module that imports a Xlsx file and inserts the rows to database. Everything works fine, except PhpSpreadsheet throws the error "PHP message: Uncaught PHP Exception InvalidArgumentException: "File "" does not exist." at…
I'm trying to create a single series bar or line chart in Excel using PhpSpreadsheet. I can't get the Y Axis in the right spot. Whether it's a line or bar chart, the Y Axis shows up at random spots in the chart. Here's my code, taken primarily…
I need to write in a .xlsx file about 111.100 rows, using fromArray() but I have a strange error
I use phpspreadsheet library
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$columnLetter = 'A';
…
I have OpenCart 2.3.0.2 installed on localhost, I want to use PhpSpreadsheet library for my OpenCart project. Does anyone here have used them? I confuse on how to call the library. I want to upload Excel data for a product. This Excel data will be…
The server (maddogdomains) throws error 503, when the phpspreasheet plugin loads an Excel of 22MB and more than 40,000 records, see line 10 ($reader->load($inputFileName)) of the following code:
$data = array(
'upload_data' =>…
I have this kind of Excel document and the file type is .xls. At least Excel complains about the file type that it doesn't match to the contents. Anyway, any idea how to import this with PhpSpreadsheet and what should be defined as a file type? I've…
I am developing a Laravel web application that uses the library PHPSpreadsheet. It creates a new workbook and then generates a graph inside the workbook. This is my code.
use PhpOffice\PhpSpreadsheet\Spreadsheet;
class MakeCertificates
{
…
I haven't access to my mySQL server, cannot install anything there with composer.
That's why I've downloaded PhpSpreadsheet files from here https://php-download.com/package/phpoffice/phpspreadsheet and packed to my local php directory.
But also the…
Im trying to read 2 excel file and save in db.. Im using PHPSpreadSheet to read the excel file.
Manage to insert the 1st file but unable to insert both files.
public function import_excel_files()
{
$this->load->helper('url_helper');
…
How do I convert excel file to pdf file. I have phpspreadsheet and tcpdf installed. But How do I make phpspreadsheet use Tcpdf . Am getting this error
Fatal error: Class 'TCPDF' not found in
…
I set in my excell file for format date like 09/01/19 (dd/mm/yy)
my function to get format date in excell like this
$form = $sheet->getCellByColumnAndRow($j, $i)->getStyle()->getNumberFormat()->getFormatCode();
but when im try to call with format…
Im create dynamic reporting using phpspreadsheet, when im create single worksheet with chart the output give the fine result.
when im create multiple worksheet with chart, the output saying "The file corupted", im trying find the answer on here ,…
Im trying to make new worksheet from data array
$tempspreadsheet = new Spreadsheet();
$i=1; foreach($arr_excel_temp as $Temporary) {
$tempspreadsheet->setActiveSheetIndex(0)
->setCellValue('A'. $i,…
I'm having some issues regarding this php library which is not working as i want to, i hope you can help me out with this one.
My program first calls a service through ajax which returns a .json.Then with the given.json i need to save it in a xls…
