User Tools

Site Tools


interfaces:how_reads_gdxxrw_excel_data_which_is_stored_as_text

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

interfaces:how_reads_gdxxrw_excel_data_which_is_stored_as_text [2009/02/20 11:22]
admin created
interfaces:how_reads_gdxxrw_excel_data_which_is_stored_as_text [2009/02/20 11:23] (current)
admin
Line 1: Line 1:
 ====== How reads gdxxrw Excel data, which is stored as text? ====== ====== How reads gdxxrw Excel data, which is stored as text? ======
-// We have just upgraded a model from using v22.3 to v22.6. Unfortunately the Excel data which is read into the model has many  instances of numbers stored as text [probably a copy and paste once  long ago], and this is causing problems in v22.6 (and I tried a couple of later versions also). ​ This did not used to cause issues with 22.3 We will clean up the data as we go, however there are any many different ​datasets ​(hundreds) and its very likely someone will push one of these unfixed versions of Excel data through the model at some stage. ​ Is there a setting or similar for dealing with this?//+// We have just upgraded a model from using v22.3 to v22.6. Unfortunately the Excel data which is read into the model has many  instances of numbers stored as text [probably a copy and paste once  long ago], and this is causing problems in v22.6 (and I tried a couple of later versions also). ​ This did not used to cause issues with 22.3 We will clean up the data as we go, however there are any many different ​data sets (hundreds) and its very likely someone will push one of these unfixed versions of Excel data through the model at some stage. ​ Is there a setting or similar for dealing with this?//
  
  
  
 We asked Excel to give us the value of a cell; depending on the locale setting, the value returned can be different depending on the We asked Excel to give us the value of a cell; depending on the locale setting, the value returned can be different depending on the
-current decimal separator. In one locale 1.8 returns 1.8 while in an other it returned 1.0. To avoid this, we started [in a GAMS rrlease ​> 22.3] to return NA for cells that should contain a numerical value but contain text instead (Except we look for Inf Eps etc).+current decimal separator. In one locale 1.8 returns 1.8 while in an other it returned 1.0. To avoid this, we started [in a GAMS release ​> 22.3] to return NA for cells that should contain a numerical value but contain text instead (Except we look for Inf Eps etc).
  
 So I think there is no way of getting the numbers out of cells that are formatted as text and start with a quote. Inside GAMS you can find out if data read in by gdxxrw had such cells: Look for NA. You can abort the program and tell the user to fix this in the spreadsheet. For example, So I think there is no way of getting the numbers out of cells that are formatted as text and start with a quote. Inside GAMS you can find out if data read in by gdxxrw had such cells: Look for NA. You can abort the program and tell the user to fix this in the spreadsheet. For example,
IMPRESSUM / LEGAL NOTICEPRIVACY POLICY interfaces/how_reads_gdxxrw_excel_data_which_is_stored_as_text.txt ยท Last modified: 2009/02/20 11:23 by admin