This archive contains answers to questions sent to Unidata support through mid-2025. Note that the archive is no longer being updated. We provide the archive for reference; many of the answers presented here remain technically correct, even if somewhat outdated. For the most up-to-date information on the use of NSF Unidata software and data services, please consult the Software Documentation first.
Rokaya, 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 project. 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