Reading data from ods(Open office spreadsheet) for selenium in java
Is there any possibility of using ods(Open office spreadsheet) files for read and write data in selenium using java. I searched internet and i am not find any way. Pls anyone help me.
java selenium
add a comment |
Is there any possibility of using ods(Open office spreadsheet) files for read and write data in selenium using java. I searched internet and i am not find any way. Pls anyone help me.
java selenium
Can't you save your data in.xls
file?
– Rafał Laskowski
Jul 5 '17 at 10:29
yes. My company have only open office
– Kanagaraj
Jul 5 '17 at 10:30
Open office supports saving and loading from.xls
extension.
– Rafał Laskowski
Jul 5 '17 at 10:30
ok. thanks for your information
– Kanagaraj
Jul 5 '17 at 10:33
1
And then, you can usejxl
library to operate on.xls
files
– Rafał Laskowski
Jul 5 '17 at 10:57
add a comment |
Is there any possibility of using ods(Open office spreadsheet) files for read and write data in selenium using java. I searched internet and i am not find any way. Pls anyone help me.
java selenium
Is there any possibility of using ods(Open office spreadsheet) files for read and write data in selenium using java. I searched internet and i am not find any way. Pls anyone help me.
java selenium
java selenium
asked Jul 5 '17 at 10:27
KanagarajKanagaraj
207
207
Can't you save your data in.xls
file?
– Rafał Laskowski
Jul 5 '17 at 10:29
yes. My company have only open office
– Kanagaraj
Jul 5 '17 at 10:30
Open office supports saving and loading from.xls
extension.
– Rafał Laskowski
Jul 5 '17 at 10:30
ok. thanks for your information
– Kanagaraj
Jul 5 '17 at 10:33
1
And then, you can usejxl
library to operate on.xls
files
– Rafał Laskowski
Jul 5 '17 at 10:57
add a comment |
Can't you save your data in.xls
file?
– Rafał Laskowski
Jul 5 '17 at 10:29
yes. My company have only open office
– Kanagaraj
Jul 5 '17 at 10:30
Open office supports saving and loading from.xls
extension.
– Rafał Laskowski
Jul 5 '17 at 10:30
ok. thanks for your information
– Kanagaraj
Jul 5 '17 at 10:33
1
And then, you can usejxl
library to operate on.xls
files
– Rafał Laskowski
Jul 5 '17 at 10:57
Can't you save your data in
.xls
file?– Rafał Laskowski
Jul 5 '17 at 10:29
Can't you save your data in
.xls
file?– Rafał Laskowski
Jul 5 '17 at 10:29
yes. My company have only open office
– Kanagaraj
Jul 5 '17 at 10:30
yes. My company have only open office
– Kanagaraj
Jul 5 '17 at 10:30
Open office supports saving and loading from
.xls
extension.– Rafał Laskowski
Jul 5 '17 at 10:30
Open office supports saving and loading from
.xls
extension.– Rafał Laskowski
Jul 5 '17 at 10:30
ok. thanks for your information
– Kanagaraj
Jul 5 '17 at 10:33
ok. thanks for your information
– Kanagaraj
Jul 5 '17 at 10:33
1
1
And then, you can use
jxl
library to operate on .xls
files– Rafał Laskowski
Jul 5 '17 at 10:57
And then, you can use
jxl
library to operate on .xls
files– Rafał Laskowski
Jul 5 '17 at 10:57
add a comment |
1 Answer
1
active
oldest
votes
File file = new File("file location");
Sheet sheet = SpreadSheet.createFromFile(file).getSheet(0)MutableCell domain = null;
sheet.getCellAt(row index,column index).setValue(value you want to write in the cell) / getvalue()-fetches the value in the cell;
sheet.getSpreadSheet().saveAs(file);
Note:
For using this, you need openjdocument
jar file added to your project.
add a comment |
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
});
}
});
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%2f44923640%2freading-data-from-odsopen-office-spreadsheet-for-selenium-in-java%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
File file = new File("file location");
Sheet sheet = SpreadSheet.createFromFile(file).getSheet(0)MutableCell domain = null;
sheet.getCellAt(row index,column index).setValue(value you want to write in the cell) / getvalue()-fetches the value in the cell;
sheet.getSpreadSheet().saveAs(file);
Note:
For using this, you need openjdocument
jar file added to your project.
add a comment |
File file = new File("file location");
Sheet sheet = SpreadSheet.createFromFile(file).getSheet(0)MutableCell domain = null;
sheet.getCellAt(row index,column index).setValue(value you want to write in the cell) / getvalue()-fetches the value in the cell;
sheet.getSpreadSheet().saveAs(file);
Note:
For using this, you need openjdocument
jar file added to your project.
add a comment |
File file = new File("file location");
Sheet sheet = SpreadSheet.createFromFile(file).getSheet(0)MutableCell domain = null;
sheet.getCellAt(row index,column index).setValue(value you want to write in the cell) / getvalue()-fetches the value in the cell;
sheet.getSpreadSheet().saveAs(file);
Note:
For using this, you need openjdocument
jar file added to your project.
File file = new File("file location");
Sheet sheet = SpreadSheet.createFromFile(file).getSheet(0)MutableCell domain = null;
sheet.getCellAt(row index,column index).setValue(value you want to write in the cell) / getvalue()-fetches the value in the cell;
sheet.getSpreadSheet().saveAs(file);
Note:
For using this, you need openjdocument
jar file added to your project.
edited Nov 24 '18 at 11:06
סטנלי גרונן
1,61472044
1,61472044
answered Nov 24 '18 at 8:52
MohanrajMohanraj
1
1
add a comment |
add a comment |
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.
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%2f44923640%2freading-data-from-odsopen-office-spreadsheet-for-selenium-in-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
Can't you save your data in
.xls
file?– Rafał Laskowski
Jul 5 '17 at 10:29
yes. My company have only open office
– Kanagaraj
Jul 5 '17 at 10:30
Open office supports saving and loading from
.xls
extension.– Rafał Laskowski
Jul 5 '17 at 10:30
ok. thanks for your information
– Kanagaraj
Jul 5 '17 at 10:33
1
And then, you can use
jxl
library to operate on.xls
files– Rafał Laskowski
Jul 5 '17 at 10:57