You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2012/05/17 01:50:38 UTC

[Bug 53250] New: Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

https://issues.apache.org/bugzilla/show_bug.cgi?id=53250

          Priority: P2
            Bug ID: 53250
          Assignee: dev@poi.apache.org
           Summary: Blocked when instantiate of XSSFExcelExtractor or
                    XSSFWorkbook
          Severity: critical
    Classification: Unclassified
          Reporter: toplinuxer@gmail.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: XSSF
           Product: POI

Hi~


when I instantiate XSSFWorkbook or XSSFExcelExtractor for getText().

New instantiate about them is blocked with attached XSLX file.

I write code like below

#
# case 1
#
OPCPackage pkg = OPCPackage.open(fileName);

// blocked below code, no exception.. no response..
XSSFExcelExtractor ext = new XSSFExcelExtractor(pkg);
String fullText = ext.getText();

#
# case 2
#
OPCPackage pkg = OPCPackage.open(fileName);

// blocked below code, no exception.. no response..
XSSFWorkbook wb = new XSSFWorkbook(pkg);
XSSFExcelExtractor ext = new XSSFExcelExtractor(wb);
String fullText = ext.getText();



I will attach problem occurred Excel File.

Would you please quick answer about this problem.. I got critical issue about
that.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 53250] Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53250

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #7 from Yegor Kozlov <ye...@dinom.ru> ---


*** This bug has been marked as a duplicate of bug 51585 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 53250] Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53250

--- Comment #4 from toplinuxer@gmail.com ---
my runtime is 
  Windows 7 64bit
  JDK 1.7.0_03 32bit

and your poi 3.8

check it plz..

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 53250] Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53250

toplinuxer@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from toplinuxer@gmail.com ---

It's size about 1.3M
so can't upload to site (limit to 1MB ㅠㅠ)

so I attach problem occured Excel file with below link 

http://bit.ly/JU6Ujl

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 53250] Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53250

Nick Burch <ni...@alfresco.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|---                         |WORKSFORME

--- Comment #5 from Nick Burch <ni...@alfresco.com> ---
The POI bugzilla is not the place to ask for help with basic JVM setup queries,
try the support forums of whoever makes your JVM. I don't know what you've done
wrong, only that POI can handle your file just fine

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 53250] Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53250

toplinuxer@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|WORKSFORME                  |---

--- Comment #6 from toplinuxer@gmail.com ---
I think this problem is blocked when instantiate Class
But see long time this problem is not blocking, but needed so many time (1
hours)

About attacked XLSX, instantiate Workbook or XSSFExcelExtractor needed
about 1 hours. (after about 1 hours next code do their works well...)
Similar issue is like below
(
http://mail-archives.apache.org/mod_mbox/poi-user/201010.mbox/%3C9C9F7A2C-ECDC-4BAE-AC8E-79A97E762868@jmlafferty.com%3E
)


How can I solve this performance issue.

I need a timeout or make a short the latency when instantiate

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 53250] Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53250

toplinuxer@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|WORKSFORME                  |---

--- Comment #3 from toplinuxer@gmail.com ---
I use jdk1.7.0_03 version.

and what do you mean "correctly configured" ?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 53250] Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53250

Nick Burch <ni...@alfresco.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |WORKSFORME

--- Comment #2 from Nick Burch <ni...@alfresco.com> ---
Supplied file opens and extracts just fine for me. POI extracts text which
starts with:

표지
master(070428)
    <2007년 04월 24일 기준>
    1. Pipe Line
    (Unit:M Won)
    Territory    January    February    March    1Q    April    May    June   
2Q    1H    July    August    September    3Q    1Q ~ 3Q    OctoberNovember   
December    4Q    2H    YTD
    06
Act.    Plan    P/L    Act    '06/'07
(etc)

I don't know what you're doing wrong, but I'd double check your JVM is
installed and correctly configured, and you've not broken the xml parsing in it

-- 
You are receiving this mail because:
You are the assignee for the bug.