It looks like if the cell is null/empty, then it ends up returning the wrong data

[GoogleCodeExporter]

<connection id="xlsx" 
url="jdbc:xls:file:${quest.reward.filename}?readStreaming=true"/>
...
<query connection-id="xlsx">
    SELECT * FROM Quests;
    <script connection-id="log">
        ${etl.getParameter('Quest ID')} $EXP
    </script>
</query>

The data in the spreadsheet looks like this...

Zone ID Level   Quest ID    GUID    Quest Name  EXP Gold    Bag Type    Item ID Item 
Rarity  Item Name   Quantity    Class

9   30  902 QUEST-9-902 Sic Semper 
Proditores  144000  -   class   15722   Uncommon    Infiltrator's Gauntlets 1   lancer
9   30  902 QUEST-9-902 

15722   Uncommon    Infiltrator's Gauntlets 1   berserker
9   30  902 QUEST-9-902 

15725   Uncommon    Infiltrator's Grips 1   warrior

And I get this for the output..

902 144000
902 Uncommon
902 Uncommon

So when that EXP column is empty/null, for some reason it returns data from the 
Item Rarity column

Original issue reported on code.google.com by vasilievip on 19 May 2012 at 7:57

Attachments:

• Sample.xlsx

[GoogleCodeExporter]

This issue was closed by revision r170.

Original comment by vasilievip on 19 May 2012 at 8:55

• Changed state: Fixed

[GoogleCodeExporter]

Original comment by vasilievip on 27 Apr 2013 at 9:54

• Added labels: 6.1