Mixing
How to create an excel file and attach in mail without store in local disk
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
1
Using maatwebsite I have to generate the 'xlsx' file and attach the same in the email through mailable or direct mail attachment.
By default the file is stored in storage folder which I don't want.
Ignored the export or download method at the end of the script and assigned that Excel::create in a variable.
$file = Excel::create($fileName, function($excel) use($valuesInArray) {
$excel->sheet('Sheetname', function($sheet) use($valuesInArray) {
$sheet->fromArray($valuesInArray);
});
});
Mail::send('email.documents_export',["user"=>"Albert", "clientName" => "AAA"],function($m) use($file){
$m->to('albert@aaa.com')->subject('Document Export');
$m->attach($file->store("xlsx",false,true)['full']);
});
File has to be available for attachment without store it anywhere.
laravel maatwebsite-excel
edited Jan 3 at 10:15
Mozammil
6,315420
asked Jan 3 at 9:19
Albert RajAlbert Raj
599
add a comment |
1
Using maatwebsite I have to generate the 'xlsx' file and attach the same in the email through mailable or direct mail attachment.
By default the file is stored in storage folder which I don't want.
Ignored the export or download method at the end of the script and assigned that Excel::create in a variable.
$file = Excel::create($fileName, function($excel) use($valuesInArray) {
$excel->sheet('Sheetname', function($sheet) use($valuesInArray) {
$sheet->fromArray($valuesInArray);
});
});
Mail::send('email.documents_export',["user"=>"Albert", "clientName" => "AAA"],function($m) use($file){
$m->to('albert@aaa.com')->subject('Document Export');
$m->attach($file->store("xlsx",false,true)['full']);
});
File has to be available for attachment without store it anywhere.
laravel maatwebsite-excel
edited Jan 3 at 10:15
Mozammil
6,315420
asked Jan 3 at 9:19
Albert RajAlbert Raj
599
Went through the package.Storeneeds a path or uses the path from config. I am curious to know why you don't want it to be stored somewhere?
– Mozammil
Jan 3 at 11:38
Because I don't need the file anymore. Its a additional storage for application server. Manually or some Script should delete those files later.
– Albert Raj
Jan 3 at 13:15
Why not encapsulate that logic in aJobthat gets dispatched on a queue?
– Mozammil
Jan 3 at 13:22
How come the Job and Queue are related with this question ?
– Albert Raj
Jan 4 at 9:53
store()needs a path and it seems you are worried that you need to write a script or delete those temporary files later on. Encapsulating this logic in a Job (creating mailable, attaching file, deleting file) and dispatching it into a Queue for async processing would be a good solution imo.
– Mozammil
Jan 4 at 9:57
add a comment |
1
1
1
Using maatwebsite I have to generate the 'xlsx' file and attach the same in the email through mailable or direct mail attachment.
By default the file is stored in storage folder which I don't want.
Ignored the export or download method at the end of the script and assigned that Excel::create in a variable.
$file = Excel::create($fileName, function($excel) use($valuesInArray) {
$excel->sheet('Sheetname', function($sheet) use($valuesInArray) {
$sheet->fromArray($valuesInArray);
});
});
Mail::send('email.documents_export',["user"=>"Albert", "clientName" => "AAA"],function($m) use($file){
$m->to('albert@aaa.com')->subject('Document Export');
$m->attach($file->store("xlsx",false,true)['full']);
});
File has to be available for attachment without store it anywhere.
laravel maatwebsite-excel
edited Jan 3 at 10:15
Mozammil
6,315420
asked Jan 3 at 9:19
Albert RajAlbert Raj
599
Using maatwebsite I have to generate the 'xlsx' file and attach the same in the email through mailable or direct mail attachment.
By default the file is stored in storage folder which I don't want.
Ignored the export or download method at the end of the script and assigned that Excel::create in a variable.
$file = Excel::create($fileName, function($excel) use($valuesInArray) {
$excel->sheet('Sheetname', function($sheet) use($valuesInArray) {
$sheet->fromArray($valuesInArray);
});
});
Mail::send('email.documents_export',["user"=>"Albert", "clientName" => "AAA"],function($m) use($file){
$m->to('albert@aaa.com')->subject('Document Export');
$m->attach($file->store("xlsx",false,true)['full']);
});
File has to be available for attachment without store it anywhere.
laravel maatwebsite-excel
laravel maatwebsite-excel
edited Jan 3 at 10:15
Mozammil
6,315420
asked Jan 3 at 9:19
Albert RajAlbert Raj
599
edited Jan 3 at 10:15
Mozammil
6,315420
asked Jan 3 at 9:19
Albert RajAlbert Raj
599
edited Jan 3 at 10:15
Mozammil
6,315420
edited Jan 3 at 10:15
Mozammil
6,315420
edited Jan 3 at 10:15
Mozammil
6,315420
6,315420
asked Jan 3 at 9:19
Albert RajAlbert Raj
599
asked Jan 3 at 9:19
Albert RajAlbert Raj
599
asked Jan 3 at 9:19
Albert RajAlbert Raj
599
599
Went through the package.Storeneeds a path or uses the path from config. I am curious to know why you don't want it to be stored somewhere?
– Mozammil
Jan 3 at 11:38
Because I don't need the file anymore. Its a additional storage for application server. Manually or some Script should delete those files later.
– Albert Raj
Jan 3 at 13:15
Why not encapsulate that logic in aJobthat gets dispatched on a queue?
– Mozammil
Jan 3 at 13:22
How come the Job and Queue are related with this question ?
– Albert Raj
Jan 4 at 9:53
store()needs a path and it seems you are worried that you need to write a script or delete those temporary files later on. Encapsulating this logic in a Job (creating mailable, attaching file, deleting file) and dispatching it into a Queue for async processing would be a good solution imo.
– Mozammil
Jan 4 at 9:57
add a comment |
Went through the package.Storeneeds a path or uses the path from config. I am curious to know why you don't want it to be stored somewhere?
– Mozammil
Jan 3 at 11:38
Because I don't need the file anymore. Its a additional storage for application server. Manually or some Script should delete those files later.
– Albert Raj
Jan 3 at 13:15
Why not encapsulate that logic in aJobthat gets dispatched on a queue?
– Mozammil
Jan 3 at 13:22
How come the Job and Queue are related with this question ?
– Albert Raj
Jan 4 at 9:53
store()needs a path and it seems you are worried that you need to write a script or delete those temporary files later on. Encapsulating this logic in a Job (creating mailable, attaching file, deleting file) and dispatching it into a Queue for async processing would be a good solution imo.
– Mozammil
Jan 4 at 9:57
Went through the package.
Store needs a path or uses the path from config. I am curious to know why you don't want it to be stored somewhere?– Mozammil
Jan 3 at 11:38
Went through the package.
Store needs a path or uses the path from config. I am curious to know why you don't want it to be stored somewhere?– Mozammil
Jan 3 at 11:38
Because I don't need the file anymore. Its a additional storage for application server. Manually or some Script should delete those files later.
– Albert Raj
Jan 3 at 13:15
Because I don't need the file anymore. Its a additional storage for application server. Manually or some Script should delete those files later.
– Albert Raj
Jan 3 at 13:15
Why not encapsulate that logic in a
Job that gets dispatched on a queue?– Mozammil
Jan 3 at 13:22
Why not encapsulate that logic in a
Job that gets dispatched on a queue?– Mozammil
Jan 3 at 13:22
How come the Job and Queue are related with this question ?
– Albert Raj
Jan 4 at 9:53
How come the Job and Queue are related with this question ?
– Albert Raj
Jan 4 at 9:53
store() needs a path and it seems you are worried that you need to write a script or delete those temporary files later on. Encapsulating this logic in a Job (creating mailable, attaching file, deleting file) and dispatching it into a Queue for async processing would be a good solution imo.– Mozammil
Jan 4 at 9:57
store() needs a path and it seems you are worried that you need to write a script or delete those temporary files later on. Encapsulating this logic in a Job (creating mailable, attaching file, deleting file) and dispatching it into a Queue for async processing would be a good solution imo.– Mozammil
Jan 4 at 9:57
add a comment |
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/3.0/"u003ecc by-sa 3.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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54019333%2fhow-to-create-an-excel-file-and-attach-in-mail-without-store-in-local-disk%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
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54019333%2fhow-to-create-an-excel-file-and-attach-in-mail-without-store-in-local-disk%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
Went through the package.
Storeneeds a path or uses the path from config. I am curious to know why you don't want it to be stored somewhere?– Mozammil
Jan 3 at 11:38
Because I don't need the file anymore. Its a additional storage for application server. Manually or some Script should delete those files later.
– Albert Raj
Jan 3 at 13:15
Why not encapsulate that logic in a
Jobthat gets dispatched on a queue?– Mozammil
Jan 3 at 13:22
How come the Job and Queue are related with this question ?
– Albert Raj
Jan 4 at 9:53
store()needs a path and it seems you are worried that you need to write a script or delete those temporary files later on. Encapsulating this logic in a Job (creating mailable, attaching file, deleting file) and dispatching it into a Queue for async processing would be a good solution imo.– Mozammil
Jan 4 at 9:57