by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jan 31 2019 19:55
    alessandrotesoro starred box/spout
  • Jan 31 2019 19:40
    Maxeee09 starred box/spout
  • Jan 31 2019 19:05
    metallurgical starred box/spout
  • Jan 31 2019 13:04
    barryvdh commented #624
  • Jan 31 2019 11:48
    rn1000 starred box/spout
  • Jan 31 2019 11:04
    kruglikdenis starred box/spout
  • Jan 31 2019 10:28
    gjportegies starred box/spout
  • Jan 31 2019 09:06
    guanhui07 starred box/spout
  • Jan 31 2019 08:44
    JingwenTian starred box/spout
  • Jan 31 2019 04:28
    absalomedia starred box/spout
  • Jan 31 2019 02:03
    brnmonteiro starred box/spout
  • Jan 31 2019 02:01
    kaishuizhuyu starred box/spout
  • Jan 31 2019 01:30
    OHOM starred box/spout
  • Jan 31 2019 00:51
    cherryred5959 starred box/spout
  • Jan 31 2019 00:50
    yanghaifeng88 starred box/spout
  • Jan 30 2019 21:43
    barryvdh edited #624
  • Jan 30 2019 21:22
    barryvdh edited #624
  • Jan 30 2019 21:20
    barryvdh commented #616
  • Jan 30 2019 21:19
    barryvdh opened #624
  • Jan 30 2019 21:16
    barryvdh commented #612
Drevendy Harianto
@drevendy_gitlab
thanks
markosko
@markosko
u need to use path to folder which is writeable
ErizZhao
@ericzhao007
How do I merge cells
markosko
@markosko
@ericzhao007 in box/spout not implemented
ErizZhao
@ericzhao007
i know, thank you
burcezhang
@burcezhang
hello
How to turn off automatic download?
markosko
@markosko
@burcezhang what u mean automatic download ?
either save to file or browser but that will be upto browser settings
Tushar Agarwal
@tusharcoder
Hi, is there anyway to edit the spreadsheets online using php much like google sheets... editing the existing spreadsheets
markosko
@markosko
@tusharcoder only way would be open existing and read line by line to new one
Drevendy Harianto
@drevendy_gitlab
hi
how to remove this phpdebugbar?
image.png
markosko
@markosko
@drevendy_gitlab for that u need to look yourself were is problem as i dont eve this debugbar and its not part of this library
Drevendy Harianto
@drevendy_gitlab
it was strange, because i didnt create that debugbar rows.
Tushar Agarwal
@tusharcoder

@tusharcoder only way would be open existing and read line by line to new one

so can we do interactive editing of the spreadsheet by user using php

Percy
@panzk412
can Spout merge cells ?
Percy
@panzk412
@alessandrotesoro can Spout merge cells ?
markosko
@markosko
@panzk412 not implemented yet
@drevendy_gitlab u didnt but probably framework did
Rayhan Yulanda
@RayhanYulanda
is it possible to this library for import 2.000.000 row excel?
markosko
@markosko
@giraam yea its possibpe but would take longer time to read that excel
Some minutes probably @RayhanYulanda
bluemoonfr1
@bluemoonfr1
I have just added some things in Spout for XLSX : vertical alignment, row heights, column widths, hyperlinks. Not sure it could interest anyone, but in case...
markosko
@markosko
maybe put pullrequest but mostly would be on @adrilo if he wants to accept changes
nicoleta-iuliana
@nicoleta-iuliana
Hello everyone, I want to use spout package to stream data in to CSV temporary file but I didn't find any documentation that says I can do that. So, I can do this with spout, or should I find another library ? Thanks.
markosko
@markosko
@nicoleta-iuliana stream as in write to file ?
nicoleta-iuliana
@nicoleta-iuliana
Yes, sorry for the late response.
markosko
@markosko
something like $writer->openToFile("path_to_temp_file"); @nicoleta-iuliana
MrElLeRm
@MrElLeRm
@markosko Hi man! I want to ask about this PR: box/spout#715 Any chance that this PR will be in your library? It's very needle thing!
markosko
@markosko
@MrElLeRm this is not my library so dont know
MrElLeRm
@MrElLeRm
@markosko Thx for reply!
markosko
@markosko
@MrElLeRm library is done by @adrilo but noone forces u to not download lib from PR fork
MrElLeRm
@MrElLeRm
@markosko Yep, this was my second idea, but i'm think @adrilo should implement this thing in him library, because this is very needle thing in libraries kind of this
Valentin Merlet
@ValentinMerlet
Hello everyone, I would like to know if this is possible to with Spout to write a list of values inside a single cell ? Maybe I missed something but I didn't find anything about it in the documentation.
markosko
@markosko
@ValentinMerlet what u mean list of valuse?
in single cell u can put only one value or atmost string containing some values by commas or someting
Valentin Merlet
@ValentinMerlet
I mean this kind of list : https://imgur.com/a/DieuvUz
markosko
@markosko
thats somewhat special thing its from some values defined
LucasBerger
@LucasBerger
hey, is there a website with a documentation for spout v2?
abdallahboodhun
@abdallahboodhun
Hello i am struggling with a piece of how code....I want to get the column.

Hello i am struggling with a piece of how code....I want to get the column.

foreach ($sheet->getRowIterator() as $rowNumber => $row) { foreach($row as $k => $value){ //i want to get column here $rowDetails[] = $value; } }

markosko
@markosko
@abdallahboodhun hello and whats problem ?
abdallahboodhun
@abdallahboodhun
@markosko Hello i have been able to resolve this issue. but now i want to read data from a radio button in an excel...can this be done using spout?
Tomáš Smetka
@smety
Hi, I found this library, thank the authors for the veil :)
Drevendy Harianto
@drevendy_gitlab
can i save it to xls format?
Roger
@rbastida
Hi! I am new to spout library, and I want to do a simple code to write my database data into xls, and permit user to download from browser the result... anybody can help me?
markosko
@markosko
@drevendy_gitlab @rbastida this library works only with newer xlsx
xls is binary format not like xlsx which is zipped archive of xmls files