Stack Overflow
Stack Overflow

Questions tagged [spout]

Spout is a PHP library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way.

Spout is developed by Box. See https://github.com/box/spout.

31 questions
0
votes
0 answers

Excel file created from box/spout library is not editable in microsoft excel

I just recently implemented box/spout library replacing the phpspreadsheet library in favour of memory efficiency. I am also able to produce the excel file using it. But after opening the excel file using ms office 2019, I cannot edit the cells at…
FerdousTheWebCoder
  • 218
  • 3
  • 13
0
votes
0 answers

Import data from file excel and insert in database

I have to import the data from excel to SQL database, I use a library box/spout for read a file excel, I installed it in my themes with composer We will create a form to upload an excel sheet, So create a code in my custom plugin. Here is the…
kenza
  • 11
  • 2
0
votes
1 answer

I download excel using Box spout error , can not be download

I use box spout to export excel file. Version box spout : 3.3. I use $writer->openToBrowser($linkFile); let it download automatically, but it doesn't download, error like…
json
  • 67
  • 4
  • 15
0
votes
1 answer

Box Spout format cell type to Number

Is it possible to change cell type to Number in Box Spout? For the moment when I export an excel file all cells type are General . Thanks, Florida
Florida
  • 3
  • 2
0
votes
0 answers

Run curl for 20k in a sequence and save data in excel: fails

I need to run around 20K curl request, fetch the data from the request and save it in excel using Spout. Important is that I need to be run in sequence and save data in sequence. I have set the PHP timeout to 0, but it still fails. Shows an empty…
kannu
  • 129
  • 2
  • 8
0
votes
0 answers

Spout and undefined offset error during read of a xlsx file

I've a strange problem using SPOUT xlxs reader plugin. I get error Notice: Undefined offset: 19 In my test.xlsx at row 17. I don't know why. If I insert some text it is ok...but if it is empty I get error.....the strange thing is that all columns…
Giuseppe Lodi Rizzini
  • 1,045
  • 11
  • 33
0
votes
1 answer

JSON Kafka spout in Apache Storm

I am building a Storm topology with Kafka spout. I am consuming from Kafka (without Zookeeper) in a JSON format, and Storm should output it. How can I define proper schema for JSON data type? Currently, I have such code base with basic spout…
Cassie
  • 2,941
  • 8
  • 44
  • 92
0
votes
1 answer

File Format or File Extension is not valid using Spout PHP In Linux CentOS

I am facing problem in export xlsx format using spout library. I don't know where is the issue in my code. I don't know much about spout library. I have tried many times but the same error occurs again and again when I tried opening the exported…
Bala Vasudevan
  • 1
  • 3
0
votes
1 answer

Cannot figure out How run box\Spout with Windows Subsystem for Linux and composer

I have installed apache2, and php 7.3 sucefully and composer as well, However the apache2 error.log throws this error: [php7:error] [pid 24562] [client ::1:60764] PHP Fatal error: Uncaught Error: Class …
stan chacon
  • 768
  • 1
  • 6
  • 19
0
votes
1 answer

PHPSpreadsheet to Read Passworded XLSX

I've spent all day searching both the documentation and the web but there doesn't seem to be a way to programmatically open a passworded spreadsheet with phpspreadsheet; and spout library for that matter. In Phpspreadsheet, I'm interested in the…
user1729972
  • 712
  • 2
  • 9
  • 29
0
votes
1 answer

Box/Spout not writing full row

I'm trying to write data to an excel sheet using Box/Spout, using a writer I pass an array to the addrow() function, but when the excel file is done it is missing columns of data on the sheet... The array has exactly the data I need and I var_dump()…
Pixelknight1398
  • 537
  • 2
  • 10
  • 33
0
votes
1 answer

How to send multiple (different) tuples from one KafkaSpout at once to the bolt?

I am a novice in Apache Storm. I am trying to develop a real-time stream processing system using Apache Kafka, Storm and ESPER CEP engine. For that, I am having one KafkaSpout that will emit streams to Bolts(which has my CEP queries) to filter the…
tank
  • 465
  • 8
  • 22
0
votes
1 answer

Failed opening 'spout-2.4.3\spout-2.4.3\src\Spout\Autoloader\autoload.php'

PHP Warning: include_once(): Failed opening 'spout-2.4.3\spout-2.4.3\src\Spout\Autoloader\autoload.php' for inclusion (include_path='.:/opt/alt/php71/usr/share/pear') I uploaded my site online and I am getting that error. I am uploading a xlsx…
Jes
  • 27
  • 7
0
votes
3 answers

Insert large Excel file into database

I'm using Spout for reading an Excel file of over 500.000 records (with 7 columns each, not too much info). The problem is my script is getting timmed out. I've tried uploading this limits and it gets better, but so far I couldn't make a complete…
Julieta Raggio
  • 1
  • 1
-1
votes
1 answer

Storm UI- Error on Spout when submitting topology

I'm quite new to all of this. I am trying to run a topology from RIOT benchmark on storm UI but when I submit the topology I get this error error msg in image on spout. I am unable to understand it please help me with this.I already run the word…
Faiza Akram
  • 1
  • 1
1
2
3