Questions tagged [phpexcel]
A PHP library to create, read, edit and write spreadsheet files for MS Excel and other spreadsheet programs
phpexcel
3,640
questions
1
vote
0
answers
53
views
Fatal Error - Could not open xlsx for reading PHPspreadsheet
I'm having trouble loading an excel spreadsheet using PHPspreadsheet. I receive the following error...
Fatal error: Uncaught PhpOffice\PhpSpreadsheet\Reader\Exception: Could not open "...
- 123
0
votes
0
answers
31
views
How to set cell color based on value using PHPExcel
I am using PHPExcel to export a MySql select and it's working fine.
I know PHPExcel is deprecate and now there is PHPspreadsheets, but it's an old project with an old php version
Anyway, I'd like to ...
- 23
0
votes
1
answer
18
views
Call an user defined function in PHPExcel
I have an addin in excel which has many user defined function for calculating gas properties etc.
I want to fetch the calculated value from a cell which has a formulae which is user defined. for eg I ...
0
votes
1
answer
45
views
Create Excel matrix with PHPExcel (maatwebsite/excel) and Laravel 9 from Mysql data
I am trying to create an Excel file from my Database that looks like this :
User Name
User Lastname
Group A
Group B
Group X
John
Doe
X
X
Jane
Doe
X
I have 3 tables :
a User table, a Group Table, ...
0
votes
0
answers
55
views
PHPSpreadsheet isn't doing all the calculations after editing some cell values
Using PHPSpreadsheet I am editing an existing spreadsheet. The sheet contains 7 cells that I change the value of. After that I save the spreadsheet to a separate file.
However, after opening the file, ...
- 340
0
votes
0
answers
74
views
PHP Excel, Read excel file with chart and write back but the chart is missing
//load spreadsheet
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load(public_path("default_.xlsx"));
//change it
$sheet = $spreadsheet->...
0
votes
0
answers
31
views
phpexcel chart secondary axis
enter image description here
If you run the code below, a graph will be created like the image above.
What I want is to use the value of B as the auxiliary axis, as shown in the image below.
How can I ...
- 1
0
votes
0
answers
43
views
Library in Python similar to PHPEXCEL library
I need to use Excel's PRICE function in my python code. I searched but only found the PHPEXCEL library to build this function, but in python I couldn't find it.
I tried to convert the PRICE function ...
0
votes
1
answer
100
views
Laravel Excel import - pass variable between sheets
I'm trying to import a two sheet excel file using Laravel Excel.
The excel file contains two sheets, one for the main building and the second one with all the apartments inside, all I need is to pass ...
0
votes
0
answers
23
views
Convert from currency to Integer in PHPExcel [duplicate]
I'm using PHPExcel(@v1.8.0) to read data in order to save it in my database
I can successfully load and read the file but I've encountered a problem when reading a column styled as "currency"...
- 11
0
votes
0
answers
68
views
Excel automated report sheet
I have a data base of over 16k columns.
Each column is identified by an ID.
I am trying to make an automated daily report.
The data is updated every day.
I have 1 sheet which is (data) sheet.
I am ...
0
votes
1
answer
53
views
Maatwebsite, export to XLSX giving currepted data in Laravel
I am using below code to Export into .xlsx using package maatwebsite/excel
$fileName = 'Stats-GroupID_' . $groupId . '-' . time() . '.xlsx';
return Excel::download($statsExport->setGroupId($...
0
votes
1
answer
168
views
how to set different font sizes within in a cell
$rowIndex = 1;
foreach ($request->warehouses as $warehouse) {
$whId = $warehouse['id_warehouse'];
$warehouse = Warehouse::find($whId);
if ($warehouse) {
foreach ($rowDetails ...
- 28
2
votes
1
answer
91
views
Fetch Attached (Embedded) Pdf from Excel in either PHPExcel or PHPSpreadsheet
I have an excel file which contains PDF - embedded (attached) in it.
I am trying to use PHPExcel and PHPSpreadsheet to fetch the data. I am successful in fetching the images but other objects like PDF ...
- 115
2
votes
1
answer
30
views
Browse an excel by columns PHPEXCEL
I need to read an excel file and upload the information to my DB, the structure of the information is the next one.
The idea is to take A1, then B2 to B8, N amoung of times, i make the test with a ...
- 193