Stack Overflow
Stack Overflow

Questions tagged [phpoffice-phpspreadsheet]

70 questions
0
votes
0 answers

phpspreadsheet retrieve cell value as unformatted text

Collect necessary rows into array ->toArray() unseccessfully try to get unformatted text value from cell. Made the following: $reader->setReadDataOnly(true); and ->rangeToArray( 'A1:Q11', // The worksheet range that we want to retrieve …
Bigata
  • 1
0
votes
0 answers

Phpoffice library cannot write more than 14 digit numbers

$sheet->setCellValue("H221", $task->amount); //42.1234567894123 But writes "42.123456789412" Excell cell image
Nicat Quliyev
  • 1
  • 1
0
votes
0 answers

Could not find package phpoffice/phpspreadsheet

[InvalidArgumentException] Could not find package phpspreadsheet. Did you mean one of these? portphp/spreadsheet phpoffice/phpspreadsheet ideea/excel phpoffice/phpexcel codeplex/phpexcel I was follow the…
Gino
  • 13
  • 3
-1
votes
1 answer

laravel queue worker subdirectory

I have a laravel queue worker setup where i create a spreadsheet file with phpoffice and save it 2 levels below the root directory ../../directory_name. Saving the file works fine when i call the save method myself. but when it's called by the…
johnex74
  • 9
  • 4
-1
votes
0 answers

How to display images in Excel output using the phpspreadsheet library

I have developed a function to output a series of information in WordPress and I use the phpspreadsheet library to output the information. I followed the documentation of the phpspreadsheet site, but I am facing this error: Fatal error: Uncaught…
persis collection
  • 13
  • 4
-1
votes
1 answer

Laravel : (1 m) Bulk data upload to the mysql with optimization

i am using laravel and i need to upload bulk (~ 1 million) of data (in .xlsx file) to the mysql using laravel.... currently i am uploading data near 200k and it is uploading to the mysql with phpoffice-phpspreadsheet package.... Here is my code to…
Yash Bohra
  • 140
  • 7
-1
votes
1 answer

Currency cells and PHPSpreadsheet: How to read the currency from it?

I have an Excel (XLSX) file with a column containing values in different currencies, e.g. "CAD 4711.00", "NOK 56.78", "CHF 123.45". Now I try to read data from these cells and I just cannot get the currencies. The best I can do is get the value…
Ralf Jahr
  • 312
  • 2
  • 18
-1
votes
1 answer

PhpSpreadsheet fatal errro when i tried add graphic

Fatal error: Uncaught PhpOffice\PhpSpreadsheet\Calculation\Exception: Formula Error: An unexpected error occurred in C:\xampp\htdocs\graficas_excel\vendor\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Calculation\Calculation.php:5224 Stack…
Juna
  • 1
  • 1
-2
votes
1 answer

Class 'PhpOffice\phpspreadsheet\src\PhpSpreadsheet\Spreadsheet' not found in Laravel

In my Laravel project I have used the PhpOffice Spreadsheet for downloading data as excel format from a datatable. For doing that I need to add code in my controller, route and view. Controller I have used below namespaces in my controller
Arafat Rahman
  • 993
  • 5
  • 19
  • 46
-3
votes
1 answer

Fatal error: Uncaught Error: Call to a member function format() on bool on line 58

I must retrieve data from a CSV file and to show the month and year from a date written in string format.I run the code and it shows the A non well formed numeric value encountered error.I also tried other ways to convert the date and I get the year…
Madalinaxyz
  • 1
  • 2
1 2 3 4
5