save in excel file different column












1















I am looking for a code I can import results in each iteration in each specific cell in excel



for (i in data_length)
{
D = d[[i]]*100
write.csv(D, file="path directory")
}


I need a code to save in same in same excel file but in different row and column










share|improve this question

























  • Your code so far uses write.csv which is appropriate for a comma-separated value (.csv) file, not an Excel (.xls or .xlsx) file. Do you need to save results in an actual Excel file, or is CSV okay?

    – Gregor
    Nov 26 '18 at 14:40






  • 1





    Hello Fatima. Please read How to create a Minimal, Complete, and Verifiable Example and update your post. As currently stated, your question is too ambiguous to answer. For example, the contents of d[[i]] are unclear.

    – Len Greski
    Nov 26 '18 at 14:49











  • you surely want to set the append param of write.csv() to TRUE. write.csv(D, file="file", append=T) might work if your data (which you unfortunately did not supply) allows for it

    – Ben T.
    Nov 26 '18 at 14:50













  • I am not sure about the line which save result into excel but the things I have in mind is to save result one by one into 1 excel file in different column and row..Could you suggest me the command line for this purpose?

    – FatimaUPC
    Nov 26 '18 at 15:25


















1















I am looking for a code I can import results in each iteration in each specific cell in excel



for (i in data_length)
{
D = d[[i]]*100
write.csv(D, file="path directory")
}


I need a code to save in same in same excel file but in different row and column










share|improve this question

























  • Your code so far uses write.csv which is appropriate for a comma-separated value (.csv) file, not an Excel (.xls or .xlsx) file. Do you need to save results in an actual Excel file, or is CSV okay?

    – Gregor
    Nov 26 '18 at 14:40






  • 1





    Hello Fatima. Please read How to create a Minimal, Complete, and Verifiable Example and update your post. As currently stated, your question is too ambiguous to answer. For example, the contents of d[[i]] are unclear.

    – Len Greski
    Nov 26 '18 at 14:49











  • you surely want to set the append param of write.csv() to TRUE. write.csv(D, file="file", append=T) might work if your data (which you unfortunately did not supply) allows for it

    – Ben T.
    Nov 26 '18 at 14:50













  • I am not sure about the line which save result into excel but the things I have in mind is to save result one by one into 1 excel file in different column and row..Could you suggest me the command line for this purpose?

    – FatimaUPC
    Nov 26 '18 at 15:25
















1












1








1








I am looking for a code I can import results in each iteration in each specific cell in excel



for (i in data_length)
{
D = d[[i]]*100
write.csv(D, file="path directory")
}


I need a code to save in same in same excel file but in different row and column










share|improve this question
















I am looking for a code I can import results in each iteration in each specific cell in excel



for (i in data_length)
{
D = d[[i]]*100
write.csv(D, file="path directory")
}


I need a code to save in same in same excel file but in different row and column







r






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 26 '18 at 14:36







FatimaUPC

















asked Nov 26 '18 at 14:30









FatimaUPCFatimaUPC

62




62













  • Your code so far uses write.csv which is appropriate for a comma-separated value (.csv) file, not an Excel (.xls or .xlsx) file. Do you need to save results in an actual Excel file, or is CSV okay?

    – Gregor
    Nov 26 '18 at 14:40






  • 1





    Hello Fatima. Please read How to create a Minimal, Complete, and Verifiable Example and update your post. As currently stated, your question is too ambiguous to answer. For example, the contents of d[[i]] are unclear.

    – Len Greski
    Nov 26 '18 at 14:49











  • you surely want to set the append param of write.csv() to TRUE. write.csv(D, file="file", append=T) might work if your data (which you unfortunately did not supply) allows for it

    – Ben T.
    Nov 26 '18 at 14:50













  • I am not sure about the line which save result into excel but the things I have in mind is to save result one by one into 1 excel file in different column and row..Could you suggest me the command line for this purpose?

    – FatimaUPC
    Nov 26 '18 at 15:25





















  • Your code so far uses write.csv which is appropriate for a comma-separated value (.csv) file, not an Excel (.xls or .xlsx) file. Do you need to save results in an actual Excel file, or is CSV okay?

    – Gregor
    Nov 26 '18 at 14:40






  • 1





    Hello Fatima. Please read How to create a Minimal, Complete, and Verifiable Example and update your post. As currently stated, your question is too ambiguous to answer. For example, the contents of d[[i]] are unclear.

    – Len Greski
    Nov 26 '18 at 14:49











  • you surely want to set the append param of write.csv() to TRUE. write.csv(D, file="file", append=T) might work if your data (which you unfortunately did not supply) allows for it

    – Ben T.
    Nov 26 '18 at 14:50













  • I am not sure about the line which save result into excel but the things I have in mind is to save result one by one into 1 excel file in different column and row..Could you suggest me the command line for this purpose?

    – FatimaUPC
    Nov 26 '18 at 15:25



















Your code so far uses write.csv which is appropriate for a comma-separated value (.csv) file, not an Excel (.xls or .xlsx) file. Do you need to save results in an actual Excel file, or is CSV okay?

– Gregor
Nov 26 '18 at 14:40





Your code so far uses write.csv which is appropriate for a comma-separated value (.csv) file, not an Excel (.xls or .xlsx) file. Do you need to save results in an actual Excel file, or is CSV okay?

– Gregor
Nov 26 '18 at 14:40




1




1





Hello Fatima. Please read How to create a Minimal, Complete, and Verifiable Example and update your post. As currently stated, your question is too ambiguous to answer. For example, the contents of d[[i]] are unclear.

– Len Greski
Nov 26 '18 at 14:49





Hello Fatima. Please read How to create a Minimal, Complete, and Verifiable Example and update your post. As currently stated, your question is too ambiguous to answer. For example, the contents of d[[i]] are unclear.

– Len Greski
Nov 26 '18 at 14:49













you surely want to set the append param of write.csv() to TRUE. write.csv(D, file="file", append=T) might work if your data (which you unfortunately did not supply) allows for it

– Ben T.
Nov 26 '18 at 14:50







you surely want to set the append param of write.csv() to TRUE. write.csv(D, file="file", append=T) might work if your data (which you unfortunately did not supply) allows for it

– Ben T.
Nov 26 '18 at 14:50















I am not sure about the line which save result into excel but the things I have in mind is to save result one by one into 1 excel file in different column and row..Could you suggest me the command line for this purpose?

– FatimaUPC
Nov 26 '18 at 15:25







I am not sure about the line which save result into excel but the things I have in mind is to save result one by one into 1 excel file in different column and row..Could you suggest me the command line for this purpose?

– FatimaUPC
Nov 26 '18 at 15:25














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


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53483302%2fsave-in-excel-file-different-column%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














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53483302%2fsave-in-excel-file-different-column%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

A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

Calculate evaluation metrics using cross_val_predict sklearn

Insert data from modal to MySQL (multiple modal on website)