write to excel data from user(console) with POI java
0
I did not solve this question.
in console:
-Name?
-merve
-Number?
-123
-Name?
-xxxx
Number?
-xxx
Like this, I will ask name and number in console,It will write to Excel this data when He/She answered.
java excel apache-poi
asked Nov 14 '18 at 11:00
mervemerve
1
|
show 2 more comments
0
I did not solve this question.
in console:
-Name?
-merve
-Number?
-123
-Name?
-xxxx
Number?
-xxx
Like this, I will ask name and number in console,It will write to Excel this data when He/She answered.
java excel apache-poi
asked Nov 14 '18 at 11:00
mervemerve
1
1
Could you please be more precise? How should the desired Excel workbook look after execution? What code have you tried so far? Do you know how to write to an Excel workbook using apache.poi?
– deHaar
Nov 14 '18 at 11:06
@deHaar my First excel experience. I know write to an Excel workbook using apache poi, I can write cell but I can not write data from user to Excel.
– merve
Nov 14 '18 at 11:12
2
You just have to store input from the console in some variables and write their values to the Excel workbook after input has been closed. Do you know how to receive user input? If not, see this, for example...
– deHaar
Nov 14 '18 at 11:14
Thank you so much, I know receive user input with Scanner but how to write excel this data and in loop( name? -merve :writing excel: name?dehaar :writing excel: like this 10 persons..) @deHaar
– merve
Nov 14 '18 at 11:21
It is more difficult to write every single dataset into an opened workbook. I would store them in a data structure, maybe a POJO or aMap/Listand then, after all input has been done, loop through the data structure and write the values to the workbook.
– deHaar
Nov 14 '18 at 11:41
|
show 2 more comments
0
0
0
I did not solve this question.
in console:
-Name?
-merve
-Number?
-123
-Name?
-xxxx
Number?
-xxx
Like this, I will ask name and number in console,It will write to Excel this data when He/She answered.
java excel apache-poi
asked Nov 14 '18 at 11:00
mervemerve
1
I did not solve this question.
in console:
-Name?
-merve
-Number?
-123
-Name?
-xxxx
Number?
-xxx
Like this, I will ask name and number in console,It will write to Excel this data when He/She answered.
java excel apache-poi
java excel apache-poi
asked Nov 14 '18 at 11:00
mervemerve
1
asked Nov 14 '18 at 11:00
mervemerve
1
asked Nov 14 '18 at 11:00
mervemerve
1
asked Nov 14 '18 at 11:00
mervemerve
1
asked Nov 14 '18 at 11:00
mervemerve
1
1
1
Could you please be more precise? How should the desired Excel workbook look after execution? What code have you tried so far? Do you know how to write to an Excel workbook using apache.poi?
– deHaar
Nov 14 '18 at 11:06
@deHaar my First excel experience. I know write to an Excel workbook using apache poi, I can write cell but I can not write data from user to Excel.
– merve
Nov 14 '18 at 11:12
2
You just have to store input from the console in some variables and write their values to the Excel workbook after input has been closed. Do you know how to receive user input? If not, see this, for example...
– deHaar
Nov 14 '18 at 11:14
Thank you so much, I know receive user input with Scanner but how to write excel this data and in loop( name? -merve :writing excel: name?dehaar :writing excel: like this 10 persons..) @deHaar
– merve
Nov 14 '18 at 11:21
It is more difficult to write every single dataset into an opened workbook. I would store them in a data structure, maybe a POJO or aMap/Listand then, after all input has been done, loop through the data structure and write the values to the workbook.
– deHaar
Nov 14 '18 at 11:41
|
show 2 more comments
1
Could you please be more precise? How should the desired Excel workbook look after execution? What code have you tried so far? Do you know how to write to an Excel workbook using apache.poi?
– deHaar
Nov 14 '18 at 11:06
@deHaar my First excel experience. I know write to an Excel workbook using apache poi, I can write cell but I can not write data from user to Excel.
– merve
Nov 14 '18 at 11:12
2
You just have to store input from the console in some variables and write their values to the Excel workbook after input has been closed. Do you know how to receive user input? If not, see this, for example...
– deHaar
Nov 14 '18 at 11:14
Thank you so much, I know receive user input with Scanner but how to write excel this data and in loop( name? -merve :writing excel: name?dehaar :writing excel: like this 10 persons..) @deHaar
– merve
Nov 14 '18 at 11:21
It is more difficult to write every single dataset into an opened workbook. I would store them in a data structure, maybe a POJO or aMap/Listand then, after all input has been done, loop through the data structure and write the values to the workbook.
– deHaar
Nov 14 '18 at 11:41
1
1
Could you please be more precise? How should the desired Excel workbook look after execution? What code have you tried so far? Do you know how to write to an Excel workbook using apache.poi?
– deHaar
Nov 14 '18 at 11:06
Could you please be more precise? How should the desired Excel workbook look after execution? What code have you tried so far? Do you know how to write to an Excel workbook using apache.poi?
– deHaar
Nov 14 '18 at 11:06
@deHaar my First excel experience. I know write to an Excel workbook using apache poi, I can write cell but I can not write data from user to Excel.
– merve
Nov 14 '18 at 11:12
@deHaar my First excel experience. I know write to an Excel workbook using apache poi, I can write cell but I can not write data from user to Excel.
– merve
Nov 14 '18 at 11:12
2
2
You just have to store input from the console in some variables and write their values to the Excel workbook after input has been closed. Do you know how to receive user input? If not, see this, for example...
– deHaar
Nov 14 '18 at 11:14
You just have to store input from the console in some variables and write their values to the Excel workbook after input has been closed. Do you know how to receive user input? If not, see this, for example...
– deHaar
Nov 14 '18 at 11:14
Thank you so much, I know receive user input with Scanner but how to write excel this data and in loop( name? -merve :writing excel: name?dehaar :writing excel: like this 10 persons..) @deHaar
– merve
Nov 14 '18 at 11:21
Thank you so much, I know receive user input with Scanner but how to write excel this data and in loop( name? -merve :writing excel: name?dehaar :writing excel: like this 10 persons..) @deHaar
– merve
Nov 14 '18 at 11:21
It is more difficult to write every single dataset into an opened workbook. I would store them in a data structure, maybe a POJO or a
Map/List and then, after all input has been done, loop through the data structure and write the values to the workbook.– deHaar
Nov 14 '18 at 11:41
It is more difficult to write every single dataset into an opened workbook. I would store them in a data structure, maybe a POJO or a
Map/List and then, after all input has been done, loop through the data structure and write the values to the workbook.– deHaar
Nov 14 '18 at 11:41
|
show 2 more comments
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%2f53298651%2fwrite-to-excel-data-from-userconsole-with-poi-java%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%2f53298651%2fwrite-to-excel-data-from-userconsole-with-poi-java%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
1
Could you please be more precise? How should the desired Excel workbook look after execution? What code have you tried so far? Do you know how to write to an Excel workbook using apache.poi?
– deHaar
Nov 14 '18 at 11:06
@deHaar my First excel experience. I know write to an Excel workbook using apache poi, I can write cell but I can not write data from user to Excel.
– merve
Nov 14 '18 at 11:12
2
You just have to store input from the console in some variables and write their values to the Excel workbook after input has been closed. Do you know how to receive user input? If not, see this, for example...
– deHaar
Nov 14 '18 at 11:14
Thank you so much, I know receive user input with Scanner but how to write excel this data and in loop( name? -merve :writing excel: name?dehaar :writing excel: like this 10 persons..) @deHaar
– merve
Nov 14 '18 at 11:21
It is more difficult to write every single dataset into an opened workbook. I would store them in a data structure, maybe a POJO or a
Map/Listand then, after all input has been done, loop through the data structure and write the values to the workbook.– deHaar
Nov 14 '18 at 11:41