Mahesh Deshpande wrote:
Sid,
I have attached my sample excel. You can see values in drop down are coming from 2nd sheet.
If you go to Data --> Validation you will see there is reference to ClientList and that is what is used in macro.
Now my idea is when ever my master data changes I will only update 2nd sheet (which I will make it hidden) and it will come automatically in 1st sheet.
Any input ??????
Do other guys also facing this problem when there is ref to a list or something like that???
Regards
Mahesh.
*/"Sharma, Siddharth" <[EMAIL PROTECTED]>/* wrote:
Mahesh,
How much physical memory do you have? A good starting point is to set the maximum and minimum heap size same, say 256 meg -Xmx256M -Xms256M
There is a science involved in figuring out the right heap size for your application.
Your exception does not seem to state that you are facing a memory problem though, so I am not sure why you are pursuing the heap tuning option.
I think you have some excel file issue. If you have #REF in your source excel file, then this error is shown by POI. I will suggest first inspecting your excel and getting rid of such instances.
-Sid
-----Original Message----- From: Mahesh Deshpande [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 2:09 AM To: POI Users List Subject: RE: AW: AW: AW: can't open workbook
Siddarth, Thanks for -Xmx=2000 your input.
In environment tab for server configuration, in Java VM Arguments I tried giving following values 1) Just -Xmx 2) Then -Xmx=2000 3) After that Xmx=2000 I am not sure how exactly this should be mentioned...in all 2 cases I got same issue like last time. Can you please me exactly how to mention this parameter?
Regards, Mahesh.
"Sharma, Siddharth" wrote: There are two places in wsad, one affecting the ide and the other the server. 1. /wsappdev.ini - it will say something like -Xj9. You may want to stop using the j9 vm for the ide since I've found it to be quite unstable. It has a smaller memory footprint though than the classic vm. Add -Xmx to whatever value works for you. 2. Open your server configuration by dbl-clicking it. Open the environment tab. Expand the Java VM Argument and set your max heap size with -Xmx
-----Original Message----- From: Mahesh Deshpande [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 7:03 AM To: POI Users List Subject: AW: AW: AW: AW: can't open workbook
Hi Folks,
I am getting following exceptions while opening worksheet.
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file_path)) HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheet("Lists");
[10/14/04 16:10:00:299 IST] 6c226ca4 SystemErr R [WARNING] Unknown Ptg 3c (60) [10/14/04 16:10:00:800 IST] 6c226ca4 SystemErr R java.lang.reflect.InvocationTargetException [10/14/04 16:10:00:800 IST] 6c226ca4 SystemErr R at sun.reflect.GeneratedConstructorAccessor106.newInstance(Unknown Source) [10/14/04 16:10:00:800 IST] 6c226ca4 SystemErr R at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc torAccessorImpl.java(Compiled Code)) [10/14/04 16:10:00:800 IST] 6c226ca4 SystemErr R at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code)) [10/14/04 16:10:00:800 IST] 6c226ca4 SystemErr R at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java(Com piled Code))
Any one faced this issue please help me..
Thanks in advance. Here is old mail thread..
I went through mail archive. I found some mails suggesting putting some startup parameters in eclipse path like.. c:\eclipse\eclipse.exe -vmargs -Xmx256M -Xss1024k -showsplash 600
I am using WSAD 5.1.1
How do I configure these parameters in WSAD.... any one faced this issue please help me..
Thanks in advance. Here is old mail thread..
Regards, Mahesh.
--------------------------------
Hi Avik.
I've counterchecked the documentation and didn't find something which seems to fit for that forking.
Can you remember that option more detailed?
Regards, Karl-Heinz.
-----Urspr�ngliche Nachricht----- Von: Avik Sengupta [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 18. M�rz 2004 16:36 An: POI Users List Betreff: Re: AW: AW: AW: can't open workbook
No, what I meant is, AFAIK, when you run a java program from inside eclipse, (either via JUnit, or using a "main()" method), you can configure whether you want that java program to run in the same JVM that is running eclipse, or inside a forked (ie, external) JVM. If you use a forked JVM, you should be able to set its startup parameters.
Regards - Avik
On Thu, 2004-03-18 at 20:41, Karl-Heinz Zengerle wrote: > Hi Avik. > > We call Eclipse the following way: > c: > cd \eclipse > C:\j2sdk1.4.1_05\bin\javaw.exe -cp c:\eclipse\startup.jar > org.eclipse.core.launcher.Main -os win32 -ws win32 -arch x86 -showsplash > c:\eclipse\eclipse.exe -vmargs -Xmx256M -Xss1024k -showsplash 600 > > So I'ld say that calling Eclipse we first call javaw which then calls > eclipse and tells it its desired memory. > > Regards, Karl-Heinz. > > > -----Urspr�ngliche Nachricht----- > Von: Avik Sengupta [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 18. M�rz 2004 16:04 > An: POI Users List > Betreff: Re: AW: AW: can't open workbook > > Are you forking a separate JVM from eclipse to run your tests? That > might have its own settings. > > On Thu, 2004-03-18 at 19:19, Karl-Heinz Zengerle wrote: > > Hi Avik. > > > > The Excel file has 3 MB. The Java VM has 256 MB. In that case > > (JSP-Tomcat) it runs successfully. > > > > Eclipse itselfs seems not to react add the added start parameter > > "-vmargs -Xmx256M" (which should increase the max heap size according > to > > the documentation). Even doubling this value didn't help. > > > > Regards, Karl-Heinz. > > > > > > -----Urspr�ngliche Nachricht----- > > Von: Avik Sengupta [mailto:[EMAIL PROTECTED] > > Gesendet: Donnerstag, 18. M�rz 2004 14:40 > > An: POI Users List > > Betreff: Re: AW: can't open workbook > > > > What's your file size? How much JVM memory are you using? if you are > > calling from JSP or Eclipse, remember that tomcat(or any other > > container)/eclipse itself will use up a large part of the available > > memory. > > > > Check it out standalone first, then add the amount of heap required to > > get it to run standalone to the heap setting while running tomcat or > > eclipse. > > > > On Wed, 2004-03-17 at 16:44, Karl-Heinz Zengerle wrote: > > > Hi world. > > > > > > We could improve the situation to the following one: > > > > > > The things are running being called from a JSP page. > > > Being run or debugged in Ecplipse it still crashes with the out > > > of > > > memory error whatever VM memory we use. > > > > > > All that happens at > > > this.oiWB = new HSSFWorkbook(fs); > > > i.e. when opening the Excel file and not having processed anything > in > > > our application. > > > > > > Does anybody have a further idea? > > > > > > Regards, Karl-Heinz. > > > > > > > > > -----Urspr�ngliche Nachricht----- > > > Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > > > Gesendet: Montag, 15. M�rz 2004 16:52 > > > An: 'POI Users List' > > > Betreff: AW: can't open workbook > > > > > > Hi world. > > > > > > Without shelter measures we receive an out of memory error now. > > > > > > So I've the following questions: > > > Which Excel things doesn't POI allow? > > > Up to about what size normally Excel files can be opened without > > > increasing the Java VM memory and without having problems? > > > > > > Regards, Karl-Heinz. > > > > > > > > > -----Urspr�ngliche Nachricht----- > > > Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > > > Gesendet: Montag, 15. M�rz 2004 16:42 > > > An: [EMAIL PROTECTED] > > > Betreff: can't open workbook > > > > > > Hi world, > > > > > > When our application processed the following command > > > > > > this.oiWB = new HSSFWorkbook(fs); > > > > > > the exception below is thrown. > > > > > > java.lang.reflect.InvocationTargetException > > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > > > Method) > > > at > > > > > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA > > > ccessorImpl.java:39) > > > at > > > > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons > > > tructorAccessorImpl.java:27) > > > at > > java.lang.reflect.Constructor.newInstance(Constructor.java:274) > > > at > > > > > > org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java > > > :257) > > > at > > > > > > org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav > > > a:193) > > > at > > > > > > org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:207) > > > at > > > > > > org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:174) > > > <-- POI > > > at webCRT.XlCRTImport.(XlCRTImport.java:120) > > > <-- our application > > > at webCRT.XlCRTImport.importCRTFile(XlCRTImport.java:324) > > > at webCRT.XlCRTTstImp.TestImportFiles(XlCRTTstImp.java:275) > > > at webCRT.XlCRTImport.main(XlCRTImport.java:186) > > > Caused by: java.lang.IllegalArgumentException: Illegal length > > > at > > > > org.apache.poi.util.StringUtil.getFromUnicodeHigh(StringUtil.java:114) > > > at > > > > org.apache.poi.hssf.record.FontRecord.fillFields(FontRecord.java:172) > > > at > org.apache.poi.hssf.record.Record.fillFields(Record.java:127) > > > at org.apache.poi.hssf.record.Record.(Record.java:92) > > > at > > > org.apache.poi.hssf.record.FontRecord.(FontRecord.java:125) > > > ... 12 more > > > > > > Does anybody have an idea of possible reasons? Opening the workbook > is > > > the first POI action. So it can't be in our application. > > > > > > Since several months small files where all sheets are visible and > not > > > locked in any way the application runs without problems. Now the > Excel > > > file has grown very much (around our basic handling) and some sheets > > are > > > hidden and some sheets are locked. > > > > > > Regards, > > > Karl-Heinz Zengerle > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > >
--------------------------------- Do you Yahoo!? vote.yahoo.com - Register online to vote today!
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------- Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
------------------------------------------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
