Questions tagged [fast-excel]
9 questions
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
How to download CSV file with CRLF and not LF?
I am using FastExcel to generate .csv templates, but it downloads it with LF instead of CRLF for the line breaks, so whenever I edit the files on Windows, and upload the file back to the server, the .csv formatting is messed up.
I'm not sure if it…
pileup
- 1
- 2
- 18
- 45
1
vote
0 answers
Support of hierarchy level in fast excel
Could you please help me understand is there any way to generate excel sheet where in we can see format like hierarchy level is clasped with + button e.g.
+Info
On click on expand
Info
Info1
info2
Sandeep Pandey
- 11
- 1
1
vote
0 answers
Export Laravel Excel Data horizontally
I'm using rap2hpoutre/fast-excel library for exporting the information I need. Currently, with basic settings, I receive my data in the excel document in the following format:
Questions
First Question
Second Question
Third Question
What I want to…
Mikhail Ladonkin
- 135
- 10
1
vote
0 answers
How to send Fast Excel to Guzzle post request
i use Fast Excel library from https://github.com/rap2hpoutre/fast-excel, can i put return from ->download('file.xlsx') to Guzzle post request? with this code i'm not get anything
$httpClient = new \GuzzleHttp\Client([
'headers' => [
…
Jazz
- 183
- 9
0
votes
1 answer
Call to undefined method Rap2hpoutre\FastExcel\Facades\FastExcel::import() in laravel 10 job although the method exists
Have a controller given below when the (new FastExcel)->import($fullPath, function ($row) portion is uncommented, I can see users being inserted into the database as expeected. However when I move this logic to a job I get
Call to undefined…
uhexos
- 383
- 4
- 19
0
votes
0 answers
How to determine empty rows in excel sheet using Apache POI or Fast Excel or any other free / open source library without iterating over complete row?
I need to determine if a row in excel sheet is empty or not without iterating over whole row.
Iterating over row to determine if whole row is empty and then reading that row to get all data will increase the time of file reading operation as I need…
Ravi
- 3
- 2
0
votes
0 answers
Validation in Fast Excel package Laravel
ImportController
Bhabishya Portfilio
- 21
- 3
0
votes
0 answers
What is the memory efficient approach to import a huge Excel with Laravel FastExcel package?
I am using https://github.com/rap2hpoutre/fast-excel for importing many large Excel files in a loop.
But the memory is getting exhausted during the process.
Below is the error:
2020-08-20 15:16:28 Saved 13867 records from file…
Akshay Lokur
- 6,680
- 13
- 43
- 62