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
markosko
@markosko
change to openToFile
Drevendy Harianto
@drevendy_gitlab
okay will do
markosko
@markosko
https://docs.aws.amazon.com/sdk-for-php/v3/developer-guide/s3-transfer.html and about upload at most i can point to something like this
Drevendy Harianto
@drevendy_gitlab
@markosko hi, how are you? i am here to ask more about box/spout
    $writer->openToFile('/test.csv');

i am using this code to try to export the data. however, i got this error

fopen(/test.csv): failed to open stream: Read-only file system

image.png

but when i tried to change the default directory,

$writer->setTempFolder($customTempFolderPath);

it says like the pictures i uploaded. any help?

i am using CSV format
what i wanna do is i want to generate the file to my folder, and access it to upload to s3.
markosko
@markosko
/ means root folder on unix systems
@drevendy_gitlab
try __DIR_ . "/test.csv"
Drevendy Harianto
@drevendy_gitlab
i got it
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?