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
5
votes
2 answers

Get field data when using Spout to read an Excel file

I'm using Spout to read an Excel file. Here is what my Excel looks like: I tried doing this with some basic code from the Spout documentation: $filePath = '/Users/nhathao/Desktop/employee-test.xlsx'; $reader =…
Tomato
  • 759
  • 2
  • 14
  • 26
4
votes
1 answer

box/spout - Massive memory usage when using hex color vs pre-defined colors

I'm using the Box/Spout library and it seems that using StyleBuilder with a custom hex color (e.g. 0000FF for blue) uses a ton of memory compared to using pre-defined colors such as Color::BLUE. Why would that be? Relevant snippet: //LOW…
Jon
  • 452
  • 4
  • 23
3
votes
1 answer

How to set Excel sheet title with PHP Spout library

I am exporting Excel work book with more than 1 sheet using PHP Spout library. How do I set the title for each sheet? By default it is giving sheet1 sheet2 etc. And I need to provide hyperlink from sheet2 cells to sheet1 cells. How do I set…
Chandra Sekar
  • 302
  • 1
  • 13
2
votes
1 answer

Box/Spout documentation not matching composer install?

I have been using the box/spout PHP spreadsheet library for quite some time now. An issue came up for me when I moved directories and reinstalled box/spout via typing: composer require box/spout Installation went fine, but a problem showed up when…
Pixelknight1398
  • 537
  • 2
  • 10
  • 33
2
votes
1 answer

File extension or file is not valid at the time export excel using spout library in php

I am facing problem in export excel 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. Please guide me where is the…
Mohd Atiq
  • 151
  • 1
  • 13
1
vote
0 answers

Embed SpoutGL receiver in Qt widget

I'm trying to embed a SpoutGL (link to bindings) program that receives graphics into a Qt (PySide6) window. How can I do that? The only example I have found uses PyGame to create a surface and then a image of it is converted into a QImage, but that…
Jaime02
  • 299
  • 7
  • 21
1
vote
0 answers

CellAlignment right based on specific data "FAST EXCEL LARAVEL"

im trying to cellAlignment right for number_format data only Total Share,Total Contribution and Monthly Contribution not all data at once, how i to make it? this is my code : public function generateExcel(){ return…
Safwan Azman
  • 11
  • 3
1
vote
0 answers

Apache storm spout is not emitting tuples to all executors of the bolt

storm v1.2.2 I have an environment with 6 node cluster each 16 cores. I have deployed a sample topology which reads messages from a kafka topic which has 12 partitions. Configurations Max spout pending is 15. Topology message timeout is 300…
Soman
  • 21
  • 2
1
vote
1 answer

How to read a uploaded file ($_FILE) with Spout

I am trying to make a page where the user can upload a correctly formatted Excel file (described in the manual) and let the file be inserted into the database. I think I am able to insert the file into the database once Spout can read it but that…
TeaDrinkingProgrammer
  • 43
  • 1
  • 8
1
vote
1 answer

(need explanation) spout reader documentation

can someone help me with this spout documentation, use Box\Spout\Reader\Common\Creator\ReaderEntityFactory; $reader = ReaderEntityFactory::createReaderFromFile('/path/to/file.ext'); $reader->open($filePath); foreach ($reader->getSheetIterator()…
owf
  • 245
  • 1
  • 9
  • 26
1
vote
1 answer

Box Spout cell height width increase/decrease?

Box Spout cell height width increase/decrease ?? basically want to cell width and height increase. read full Box spout documentation. but unable to find solution. Doc Link : http://opensource.box.com/spout/docs/#styling-cells Below my…
Amit Anand
  • 11
  • 1
  • 3
1
vote
1 answer

SpreadsheetReader Object creation failing without exception

I am trying to upload my excel file to MySQL database and using Spout to do that. Here is my code for HTML and PHP. Excel Uploading PHP
Mahadev
  • 856
  • 1
  • 17
  • 44
1
vote
2 answers

Taking too long to export excel using spout library with php & mysqli?

I am facing a problem at the time of generating excel using spout library. It is taking forever to complete. I have a large amount of data to export. This is going to generate at least 600 rows and 98 columns in excel. require(APPPATH…
Mohd Atiq
  • 151
  • 1
  • 13
1
vote
1 answer

Speeding up Storm Topology

We have an application that moves csv files from HDFS to Hive. We are using Storm Topology for that process. 8 machines have been using. Each of them has 22 cores and 512 GB RAM. However, our code runs really slow. It takes 10 minutes to finish to…
Jungleman
  • 286
  • 2
  • 6
  • 20
0
votes
0 answers

Using Spout to edit a existing excel doc, and keep formatting

I'm looking at using Spout instead of PhpSpreadsheet. Spout is more compact and doesn't have over a thousand interlinked files, most never used, to do a few simple tasks, unlike PhpSpreadSheet. All I need to do is open an existing spreadsheet,…
user2767007
  • 41
  • 1
1
2 3