Liferay: Reading Excel data using Apache POI
Getting the below error while reading the Excel data using Apache POI:
javax.xml.stream.FactoryConfigurationError: Provider
com.bea.xml.stream.EventFactory not found.
Below is the code I am using:
InputStream inputStream = new ByteArrayInputStream(byteCodeConversion);
ZipSecureFile.setMinInflateRatio(-1.0d);
XSSFWorkbook wb = new XSSFWorkbook(inputStream);//Throwing the error
Below are the dependencies I am using:
compile group: 'stax', name: 'stax-api', version: '1.0.1'
compile group: 'commons-codec', name: 'commons-codec', version: '1.9'
compile group: 'org.apache.poi', name: 'poi-ooxml', version: '3.15'
compile group: 'org.apache.poi', name: 'poi-ooxml-schemas', version: '3.15'
compile group: 'org.apache.poi', name: 'poi', version: '3.15'
compile group: 'dom4j', name: 'dom4j', version: '1.6.1'
compile group: 'stax', name: 'stax-api', version: '1.0.1'
compile group: 'org.apache.commons', name: 'commons-collections4', version: '4.1'
apache-poi liferay-7
add a comment |
Getting the below error while reading the Excel data using Apache POI:
javax.xml.stream.FactoryConfigurationError: Provider
com.bea.xml.stream.EventFactory not found.
Below is the code I am using:
InputStream inputStream = new ByteArrayInputStream(byteCodeConversion);
ZipSecureFile.setMinInflateRatio(-1.0d);
XSSFWorkbook wb = new XSSFWorkbook(inputStream);//Throwing the error
Below are the dependencies I am using:
compile group: 'stax', name: 'stax-api', version: '1.0.1'
compile group: 'commons-codec', name: 'commons-codec', version: '1.9'
compile group: 'org.apache.poi', name: 'poi-ooxml', version: '3.15'
compile group: 'org.apache.poi', name: 'poi-ooxml-schemas', version: '3.15'
compile group: 'org.apache.poi', name: 'poi', version: '3.15'
compile group: 'dom4j', name: 'dom4j', version: '1.6.1'
compile group: 'stax', name: 'stax-api', version: '1.0.1'
compile group: 'org.apache.commons', name: 'commons-collections4', version: '4.1'
apache-poi liferay-7
Take a look on the answer of Using com.bea.xml.stream package on android
– samabcde
Nov 14 '18 at 11:46
@samabcde I tried it previously but no luck..
– Apurva Gupta
Nov 14 '18 at 12:03
1
Why are you using such old versions of Apache POI? What happens when you upgrade?
– Gagravarr
Nov 14 '18 at 12:11
add a comment |
Getting the below error while reading the Excel data using Apache POI:
javax.xml.stream.FactoryConfigurationError: Provider
com.bea.xml.stream.EventFactory not found.
Below is the code I am using:
InputStream inputStream = new ByteArrayInputStream(byteCodeConversion);
ZipSecureFile.setMinInflateRatio(-1.0d);
XSSFWorkbook wb = new XSSFWorkbook(inputStream);//Throwing the error
Below are the dependencies I am using:
compile group: 'stax', name: 'stax-api', version: '1.0.1'
compile group: 'commons-codec', name: 'commons-codec', version: '1.9'
compile group: 'org.apache.poi', name: 'poi-ooxml', version: '3.15'
compile group: 'org.apache.poi', name: 'poi-ooxml-schemas', version: '3.15'
compile group: 'org.apache.poi', name: 'poi', version: '3.15'
compile group: 'dom4j', name: 'dom4j', version: '1.6.1'
compile group: 'stax', name: 'stax-api', version: '1.0.1'
compile group: 'org.apache.commons', name: 'commons-collections4', version: '4.1'
apache-poi liferay-7
Getting the below error while reading the Excel data using Apache POI:
javax.xml.stream.FactoryConfigurationError: Provider
com.bea.xml.stream.EventFactory not found.
Below is the code I am using:
InputStream inputStream = new ByteArrayInputStream(byteCodeConversion);
ZipSecureFile.setMinInflateRatio(-1.0d);
XSSFWorkbook wb = new XSSFWorkbook(inputStream);//Throwing the error
Below are the dependencies I am using:
compile group: 'stax', name: 'stax-api', version: '1.0.1'
compile group: 'commons-codec', name: 'commons-codec', version: '1.9'
compile group: 'org.apache.poi', name: 'poi-ooxml', version: '3.15'
compile group: 'org.apache.poi', name: 'poi-ooxml-schemas', version: '3.15'
compile group: 'org.apache.poi', name: 'poi', version: '3.15'
compile group: 'dom4j', name: 'dom4j', version: '1.6.1'
compile group: 'stax', name: 'stax-api', version: '1.0.1'
compile group: 'org.apache.commons', name: 'commons-collections4', version: '4.1'
apache-poi liferay-7
apache-poi liferay-7
edited Nov 14 '18 at 11:49
Mustafa Ehsan
2,3951428
2,3951428
asked Nov 14 '18 at 11:37
Apurva GuptaApurva Gupta
1
1
Take a look on the answer of Using com.bea.xml.stream package on android
– samabcde
Nov 14 '18 at 11:46
@samabcde I tried it previously but no luck..
– Apurva Gupta
Nov 14 '18 at 12:03
1
Why are you using such old versions of Apache POI? What happens when you upgrade?
– Gagravarr
Nov 14 '18 at 12:11
add a comment |
Take a look on the answer of Using com.bea.xml.stream package on android
– samabcde
Nov 14 '18 at 11:46
@samabcde I tried it previously but no luck..
– Apurva Gupta
Nov 14 '18 at 12:03
1
Why are you using such old versions of Apache POI? What happens when you upgrade?
– Gagravarr
Nov 14 '18 at 12:11
Take a look on the answer of Using com.bea.xml.stream package on android
– samabcde
Nov 14 '18 at 11:46
Take a look on the answer of Using com.bea.xml.stream package on android
– samabcde
Nov 14 '18 at 11:46
@samabcde I tried it previously but no luck..
– Apurva Gupta
Nov 14 '18 at 12:03
@samabcde I tried it previously but no luck..
– Apurva Gupta
Nov 14 '18 at 12:03
1
1
Why are you using such old versions of Apache POI? What happens when you upgrade?
– Gagravarr
Nov 14 '18 at 12:11
Why are you using such old versions of Apache POI? What happens when you upgrade?
– Gagravarr
Nov 14 '18 at 12:11
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
);
);
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%2f53299352%2fliferay-reading-excel-data-using-apache-poi%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
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%2f53299352%2fliferay-reading-excel-data-using-apache-poi%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
Take a look on the answer of Using com.bea.xml.stream package on android
– samabcde
Nov 14 '18 at 11:46
@samabcde I tried it previously but no luck..
– Apurva Gupta
Nov 14 '18 at 12:03
1
Why are you using such old versions of Apache POI? What happens when you upgrade?
– Gagravarr
Nov 14 '18 at 12:11