Make large amount of excel filewriting Excel file using PhpSpreadsheetappend Indian currency symbol after export excel sheet using PhpOffice PhpSpreadsheet?How download files on app mobile with PHPSpreadsheet?Export dynamic array to Excel PHPSpreadsheetPHPSpreadsheet saving file in invalid formatReturnDatesAsStrings=>true returns timestamp with decimal & zerosWriting excel file very slow using PhpSpreadSheetRead Xlsx file in PhpSpreadsheetphpspreadsheet: Invalid file extension error using php mysqlDoes PhpSpreadSheet have a function to generate an .xlsx file from a PHP array automatically?

Did Apollo carry and use WD40?

Social leper versus social leopard

What did the controller say during my approach to land (audio clip)?

C# Fastest way to do Array Table Lookup with Integer Index

What are the end bytes of *.docx file format

Do things made of adamantine rust?

Why are Fuji lenses more expensive than others?

Wired to Wireless Doorbell

Paradox regarding phase transitions in relativistic systems

Is there any reason nowadays to use a neon indicator lamp instead of an LED?

Pseudo Game of Cups in Python

Reaction of aqueous sodium carbonate with aluminum foil

How would a native speaker correct themselves when they misspeak?

Apple Developer Program Refund Help

Is there an in-universe reason Harry says this or is this simply a Rowling mistake?

How is underwater propagation of sound possible?

Did HaShem ever command a Navi (Prophet) to break a law?

Applications of mathematics in clinical setting

Can Bless or Bardic Inspiration help a creature from rolling a 1 on a death save?

Should the pagination be reset when changing the order?

Shimano 105 FD-R7000-F front dereailleur chain rub

I feel like most of my characters are the same, what can I do?

Does battery condition have anything to do with macbook pro performance?

What do solvers like Gurobi and CPLEX do when they run into hard instances of MIP



Make large amount of excel file


writing Excel file using PhpSpreadsheetappend Indian currency symbol after export excel sheet using PhpOffice PhpSpreadsheet?How download files on app mobile with PHPSpreadsheet?Export dynamic array to Excel PHPSpreadsheetPHPSpreadsheet saving file in invalid formatReturnDatesAsStrings=>true returns timestamp with decimal & zerosWriting excel file very slow using PhpSpreadSheetRead Xlsx file in PhpSpreadsheetphpspreadsheet: Invalid file extension error using php mysqlDoes PhpSpreadSheet have a function to generate an .xlsx file from a PHP array automatically?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















I need your help,



Hi,



I have to find a solution in php in order to create a large amount of Excel File.



I make a huge amount of variable and put it in a Phpspreadsheet object.



But sometime the time to make only one Excel file is around 20 minutes. SO i need to start this function during the night. But i have a problem of memory and/or execution time .



It's a PHP backend server. It's not for users, only for administrators.



It's a loop with :
- Find the data in the Data Base (it take a lot of time)
- With the data, make the Excel File
- Export it



I would like to make all th request at the same time :)



is There a solution to make asynchronous function in order to make all the Excel file at the same time and save it in the server ? (or a better solution).



Thank you very much for your futur help.










share|improve this question
































    1















    I need your help,



    Hi,



    I have to find a solution in php in order to create a large amount of Excel File.



    I make a huge amount of variable and put it in a Phpspreadsheet object.



    But sometime the time to make only one Excel file is around 20 minutes. SO i need to start this function during the night. But i have a problem of memory and/or execution time .



    It's a PHP backend server. It's not for users, only for administrators.



    It's a loop with :
    - Find the data in the Data Base (it take a lot of time)
    - With the data, make the Excel File
    - Export it



    I would like to make all th request at the same time :)



    is There a solution to make asynchronous function in order to make all the Excel file at the same time and save it in the server ? (or a better solution).



    Thank you very much for your futur help.










    share|improve this question




























      1












      1








      1








      I need your help,



      Hi,



      I have to find a solution in php in order to create a large amount of Excel File.



      I make a huge amount of variable and put it in a Phpspreadsheet object.



      But sometime the time to make only one Excel file is around 20 minutes. SO i need to start this function during the night. But i have a problem of memory and/or execution time .



      It's a PHP backend server. It's not for users, only for administrators.



      It's a loop with :
      - Find the data in the Data Base (it take a lot of time)
      - With the data, make the Excel File
      - Export it



      I would like to make all th request at the same time :)



      is There a solution to make asynchronous function in order to make all the Excel file at the same time and save it in the server ? (or a better solution).



      Thank you very much for your futur help.










      share|improve this question
















      I need your help,



      Hi,



      I have to find a solution in php in order to create a large amount of Excel File.



      I make a huge amount of variable and put it in a Phpspreadsheet object.



      But sometime the time to make only one Excel file is around 20 minutes. SO i need to start this function during the night. But i have a problem of memory and/or execution time .



      It's a PHP backend server. It's not for users, only for administrators.



      It's a loop with :
      - Find the data in the Data Base (it take a lot of time)
      - With the data, make the Excel File
      - Export it



      I would like to make all th request at the same time :)



      is There a solution to make asynchronous function in order to make all the Excel file at the same time and save it in the server ? (or a better solution).



      Thank you very much for your futur help.







      phpspreadsheet






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Mar 28 at 15:20







      webmaster Chp

















      asked Mar 28 at 14:52









      webmaster Chpwebmaster Chp

      135 bronze badges




      135 bronze badges

























          0






          active

          oldest

          votes










          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );














          draft saved

          draft discarded
















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55400615%2fmake-large-amount-of-excel-file%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes




          Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.







          Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.




















          draft saved

          draft discarded















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55400615%2fmake-large-amount-of-excel-file%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

          용인 삼성생명 블루밍스 목차 통계 역대 감독 선수단 응원단 경기장 같이 보기 외부 링크 둘러보기 메뉴samsungblueminx.comeh선수 명단용인 삼성생명 블루밍스용인 삼성생명 블루밍스ehsamsungblueminx.comeheheheh

          155 수학 과학 기타 둘러보기 메뉴eh추가해eh문서를 완성해