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

[IDV #DCJ-440096]: Can't export data to excel



> Full Name: pawanrat
> Email Address: address@hidden
> Organization: RU
> Package Version: 4.0u1 build date:2013-03-29 18:10 UTC
> Operating System: Windows 7
> Hardware: Java: home: C:\Program Files (x86)\IDV_4.0u1\jre version: 1.6.0_43 
> j3d:1.5.2 fcs (build4)
> Description of problem: I try to export my netCDF grid information data to 
> excel but there're some error below:
> Writing grid to xls file: C:\Users\Climate\Desktop\test2.xls
> Invalid column index (256).  Allowable column range for BIFF8 is (0..255) or 
> ('A'..'IV')
> 
> my netCDF data is historical GFDL precipitation in 5 year daily.
> Time,Lat, Lon, pr
> I don't know how to fix this probelm please help me.
> 

Hi Pawanrat,
          There is some size restriction in generating the xls file, the IDV 
still relying on the old xls library which limit the file to 256 columns. To 
upgrade to the new xls library will increase the software package dramatically 
and this is why we have not do it. I am not sure if there is any help we can 
offer other than asking you to subset your gridded data first and then save to 
the xls file.


Yuan
> ******************
> 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:5820)
> 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._pyx98.writeGridToXls$36(<string>:332)
> at org.python.pycode._pyx98.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._pyx107.f$0(<string>:1)
> at org.python.pycode._pyx107.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:3178)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.setData(DisplayControlImpl.java:3160)
> at 
> ucar.unidata.idv.control.GridTableControl.setData(GridTableControl.java:125)
> at ucar.unidata.idv.control.GridTableControl.init(GridTableControl.java:108)
> 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:1249)
> 
> 
> 


Ticket Details
===================
Ticket ID: DCJ-440096
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.