4 Replies Latest reply: Jun 20, 2011 1:48 AM by chrisportal212 RSS

    Excel import wizard dialog shows certain rows' numbers as dates

      I imported data from an Excel 2003 file and saw strange behavior in the import file wizard. This is the wizard that appears when you click Table Files in the script editor, and open a spreadsheet.

       

      What happens, is numbers in a certain row are displayed as dates. For example:

       

      Clip_10.jpg

      In this case, any numeric fields in the 6th row are always formatted as dates. If I delete the 6th row, so that the 7th row becomes the 6th row, and reopen the file wizard, the new 6th row of data gets the same treatment.

       

      After testing some other data out, it turns out that for every nth column that it recognizes as a date field, the wizard is formatting any numeric data in the nth row, as dates. Meanwhile, the dates in the other rows are formatted incorrectly as numbers, and not dates.

       

      In this picture, columns 2 and 4 were formatted as dates:

       

      Clip_11.jpg

       

      Fortunately, I think it's just a glitch in the File Wizard results browser, as once the data gets into qlikview, everything seems to work fine, as seen here, using the same data as in the last screenshot:

       

      Clip_12.jpg

       

      Weird, right? Not a big problem since the data seems to get in the program ok, but its still disconcerting.

       

      Also, I do not see the same error when importing the same data as a CSV file.