phpexcel Questions
5
I'm using PhpSpreadsheet to easily read from a xls document and insert into a DB after some calculations. I succeeded using examples from the documentation, but I find it sooo complicated I'm sure ...
Niobium asked 1/4, 2018 at 9:47
15
Solved
I'm using PHPExcel to export some data to user in an excel file. I would like the script to send the excel file to the user immediately after it's creation. Here is my test code:
try{
/* Some te...
Chook asked 29/1, 2014 at 16:31
3
Solved
I am working on a complex program that deals with Excel, so I am using PHPExcel to search and edit the Excel file from a browser.
My problem comes in the editing portion of the program, so I wrote ...
2
Ok, so i trying to import xlsx file to my Database using Laravel 5.7 and Laravel Excel 3.1. Importing works but unfortunately, I have a file from another source and there are formulas in cells. My ...
6
I am trying to get Date from excel using PHPExcel. But I am not getting date, I am getting string value which is not seconds from 1970 .
Code I have tried is
$InvDate=trim($excel->getActiveSh...
3
Solved
My current CI project is now handling files. I want to upload the xls| xlsx files to the server and then import Excel data into the Database table.
As the first part, the uploaded file was successf...
Bolivar asked 31/12, 2014 at 7:52
8
Solved
hello i am new to phpexcel,
and i was wondering if there is some way send the excel i have created to the clients download without saving it on my server or to delete it right after he downloads i...
Annettaannette asked 19/12, 2011 at 19:11
8
Solved
I'm using a foreach loop to go through the REQUEST array, as I want to have an easy way to utilize the REQUEST array's keys and values.
However, I also want to have a numerical index of how many t...
3
Solved
I am trying PHPExcel and I get an error in output when I perform my script:
Fatal error: 'break' not in the 'loop' or 'switch' context in /opt/lampp/htdocs/Xlsphp/test/Classes/PHPExcel/Calculati...
3
Solved
I have been looking to change the font size of some Excel cells using a PHP library called PHPExcel.
This is what I tried:
$objPHPExcel->getActiveSheet()->getStyle("F1:G1")->getFont()-&...
4
Solved
I'm working in PHPExcel. I'm beginner.When I'm using following code and its working fine.
$phpExcel = new PHPExcel();
$phpExcel->getActiveSheet()->getStyle("A1")->getFont()->setBold(t...
7
Solved
How to center text "test"?
This is my code:
<?php
/** Error reporting */
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_tim...
5
Solved
I have read excel file using PHP excel .
But that excel file contain some date (time format) PHP excel return wrong values for that case
My code is in below
enter code hereinclude 'Classes/PHPE...
2
Solved
I have got my Excel reader to work but there is an annoying problem where I can only find information on how to apply a border to a range of cells, which is useless for my application.
Users uploa...
4
I am using PhpSpreadsheet to modify an existing file and send it to the browser, but every time I download the file excel gives me the following error:
We found a problem with some content in fi...
Lorikeet asked 7/9, 2017 at 9:8
4
Solved
Does anyone know how it's possible to set cell padding in PHPExcel ?
Searched for 30mins and still can't find a proper solution.
There is no useful documentation on this.
Androus asked 20/9, 2012 at 11:56
3
Solved
I'm building a WordPress plugin using PHPExcel to export reports of student attendance. So far, I'm able to successfully take the array of student data (including attendance) and convert and downlo...
4
Default row height in excel is -1 which show 15 in excel.This row height automatically resize to 15.75 after add content.So, I set new default row height,15 for all rows. Still, row height getting ...
Chianti asked 16/4, 2019 at 4:31
2
Solved
Is this possible? or must one use a PHP library such as thephpleague/csv?
Example, according to PhpSpreadsheet's documentation:
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
$spreadsheet ...
Menorrhagia asked 7/2, 2019 at 10:39
5
I am trying to read just one sheet from an xls document and I have this:
$objPHPExcel = $objReader->load('daily/' . $fisierInbound);
$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
fore...
3
Solved
I'm trying to freeze the top row and the first 3 columns in a worksheet, using PHPExcel.
I can freeze the row without any problem:
$objPHPExcel->getActiveSheet()->freezePane('A2');
Or I c...
3
Solved
I'm trying to load an Excel file from a certain source with PHPExcel. I have no control over how these Excel files are generated and they need to be opened automatically with PHPExcel without human...
3
How to generate a password protected spreadsheet from PHP ?
I tried PHPExcel library from http://phpexcel.codeplex.com/
PHPExcel offers 3 levels of “protection”: document security, sheet security...
6
I have the following Excel file:
I read it in by looping over every cell and getting the value with getCell(...)->getValue():
$highestColumnAsLetters = $this->objPHPExcel->setActiveShe...
3
Solved
Hi I'm new to this library called PHPSpreadsheet.
I tried reading it's docs but I can't understand it.
I want to insert a new row on an existing Excel File and
here is what I have so far:
<?php ...
Convention asked 3/10, 2019 at 6:14
1 Next >
© 2022 - 2025 — McMap. All rights reserved.