GET XLS DATA skipping values

lamalcz · Post by **lamalcz** » Mon May 21, 2007 3:25 pm

I have a small model successfully retrieving data from Excel using GET XLS DATA, for example:

industrial fuel consumption[IndustrialFuels] =
GET XLS DATA('BBAM.xls','IndustrialFuel','A','B4')

However, this next code reads the first values then skips two entries and reads the fourth value and so on.

transportation fuel consumption[TransportationFuels] =
GET XLS DATA('BBAM.xls','TransportationFuel','A','B4')

I have checked the subscripts, they are of the right number and order. The data file has no hidden rows. The Worksheet names are correct.

Of the five sets of GET XLS DATA on this particular View, only this one (transportation fuel consumption) fails to read the correct values.

lamalcz · Post by **lamalcz** » Mon May 21, 2007 4:19 pm

Fixed my problem. It seems that there was data in the rows below the input data. That caused GET XLS DATA to behave differently.