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
if u set things for csv and remove xlsx and ods writers and so
Drevendy Harianto
@drevendy_gitlab
is it possible to generate csv and upload it to amazone s3? not manually, but by code
markosko
@markosko
u can but i dont know how to upload to amazone but u would find way online
Drevendy Harianto
@drevendy_gitlab
$writer = WriterEntityFactory::createCSVWriter();
$writer->openToBrowser($this->file_name);
    $title = [
        'No',
    ];
    $writer->addRow(WriterEntityFactory::createRowFromArray($title));

    foreach ($this->all_transaction as $index => $r) {
        $row = [
            $index + 1,
        ];
        $writer->addRow(WriterEntityFactory::createRowFromArray($row));
    }

    $writer->close();
here is my code
it will download automatically, what i want to do is i want to get the excel in variable so i can upload it to s3
i didnt see this in box/spout docs, or i missed the docs?
Drevendy Harianto
@drevendy_gitlab
maybe a little explaination can help me. thank you
markosko
@markosko
ah openToBrowser
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 ?