iiasa/xl2gdx

Cross-platform alternative to GDXRRW, converts Excel files to GDX using R

xl2gdx's Issues

script doesn't read 0

The script doesn't read a table entry 0. When I read this table from the xlsx file, only the first 6 rows are read. Converting a 0 to a nonzero number changes this behavior.

HRP	HUP	HRR	HUR	FIRM

frisch -1.5 -1.5 -1.5 -1.5
AGR 0.7 0.7 0.7 0.7
FOOD 1.1 1.1 1.1 1.1
OTHIND 1.1 1.1 1.1 1.1
SER 1.05 1.05 1.05 1.05
ADM 1.05 1.05 1.05 1.05
sh0O 0 0 0 0
tr0O 0 0 0 0
ttdh0O 0 0 0 0
ttdf0O 0

This the same as the issue discussed in Example 4 - Reading a GDX File .
The squeeze option takes care of this in gdxxrw.