[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[IDV #MQK-994181]: Increase column index in excel


The problem here is that the IDV is using an older version of the Apache POI 
library. This is the library that handles writing data to Excel. The new 
version of the POI library may get around the problem you described. The 
problem with the new version of the POI library is that it is very large in 
size so we chose not redistribute it with the IDV. If you wish to sink your 
teeth into this problem, you could theoretically build the IDV with the new 
version of the POI library (http://poi.apache.org/). The IDV project is on 
github (https://github.com/Unidata/IDV) You'll have to replace the old version 
of the POI library with the new version and use Apache ant to build your 

All this is involved so please keep us up-to-date on your progress.

Best Wishes,

Unidata IDV Support

> Full Name: Rokaya Hassan
> Email Address: address@hidden
> Organization: Tuskegee University
> Package Version: 4.1 build date:2013-08-02 18:38 UTC
> Operating System: Windows 7
> Hardware: Java: home: C:\Program Files (x86)\IDV_4.1\jre version: 1.6.0_43 
> j3d:1.5.2 fcs (build4)
> Description of problem: Writing grid to xls file: C:\Users\TUSKEGEE 
> UNIVERSITY\Desktop\test.xlsx
> Invalid column index (256).  Allowable column range for BIFF8 is (0..255) or 
> ('A'..'IV')
> I have this error when trying to export data to EXcel its a climate data in 
> netcdf formate for 31 years grided time .
> I need to open at least each year alone . Because if ihave 2004 file to open.
> ******************
> Stack trace:
> java.lang.IllegalArgumentException: Invalid column index (256).  Allowable 
> column range for BIFF8 is (0..255) or ('A'..'IV')
> at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:946)
> at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:160)
> at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:148)
> at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:126)
> at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:104)
> at ucar.unidata.data.grid.GridUtil.writeGridToXls(GridUtil.java:5824)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:186)
> at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:204)
> at org.python.core.PyObject.__call__(PyObject.java:404)
> at org.python.core.PyObject.__call__(PyObject.java:408)
> at org.python.pycode._pyx97.writeGridToXls$36(<string>:332)
> at org.python.pycode._pyx97.call_function(<string>)
> at org.python.core.PyTableCode.call(PyTableCode.java:165)
> at org.python.core.PyBaseCode.call(PyBaseCode.java:149)
> at org.python.core.PyFunction.__call__(PyFunction.java:327)
> at org.python.pycode._pyx99.f$0(<string>:1)
> at org.python.pycode._pyx99.call_function(<string>)
> at org.python.core.PyTableCode.call(PyTableCode.java:165)
> at org.python.core.PyCode.call(PyCode.java:18)
> at org.python.core.Py.runCode(Py.java:1261)
> at org.python.core.__builtin__.eval(__builtin__.java:484)
> at org.python.core.__builtin__.eval(__builtin__.java:488)
> at org.python.util.PythonInterpreter.eval(PythonInterpreter.java:190)
> at ucar.unidata.data.DerivedDataChoice.getData(DerivedDataChoice.java:787)
> at ucar.unidata.data.DataChoice.getData(DataChoice.java:637)
> at ucar.unidata.data.DataInstance.getData(DataInstance.java:243)
> at ucar.unidata.data.DataInstance.getData(DataInstance.java:207)
> at ucar.unidata.data.grid.GridDataInstance.init(GridDataInstance.java:206)
> at ucar.unidata.data.grid.GridDataInstance.<init>(GridDataInstance.java:163)
> at ucar.unidata.data.grid.GridDataInstance.<init>(GridDataInstance.java:144)
> at 
> ucar.unidata.idv.control.GridDisplayControl.doMakeDataInstance(GridDisplayControl.java:284)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.initializeDataInstance(DisplayControlImpl.java:3224)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.setData(DisplayControlImpl.java:3206)
> at ucar.unidata.idv.control.PlanViewControl.setData(PlanViewControl.java:641)
> at 
> ucar.unidata.idv.control.ImagePlanViewControl.setData(ImagePlanViewControl.java:114)
> at ucar.unidata.idv.control.PlanViewControl.init(PlanViewControl.java:471)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.init(DisplayControlImpl.java:1421)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.init(DisplayControlImpl.java:1106)
> at ucar.unidata.idv.ControlDescriptor.initControl(ControlDescriptor.java:986)
> at ucar.unidata.idv.ControlDescriptor$1.run(ControlDescriptor.java:911)
> at ucar.unidata.util.Misc$3.run(Misc.java:1251)

Ticket Details
Ticket ID: MQK-994181
Department: Support IDV
Priority: Normal
Status: Closed

NOTE: All email exchanges with Unidata User Support are recorded in the Unidata inquiry tracking system and then made publicly available through the web. If you do not want to have your interactions made available in this way, you must let us know in each email you send to us.