VB6 xls upload in flexigrid shows GE0ERL

Originally Posted 29 June 2015, 9:52 pm EST

  • Originally Posted 29 June 2015, 9:52 pm EST

    Good day!

    here\'s the scenario im uploading an xls file that need to display in vsflexigrid but the problem is some fields in xls are numeric and those number display as GE0ERL in VSFlexGrid. Can somebody please tell me how to fix this?

    heres the sample code that im using.. by the way the xls files is edited using openoffice.

    cd.Filter = \"Excel File (*.xls) | *.xls\"
    cd.DialogTitle = \"Upload A Shell Billing Excel File\"
    cd.InitDir = Environ(\"USERPROFILE\") & \"\\Desktop\"
    cd.ShowOpen
    txtPath.Text = cd.FileName

    If xObj.FileExists(cd.FileName) = True Then

    Screen.MousePointer = 11

    With flex

    lbl.Caption = \"Uplaod Starting...\": DoEvents

    .FixedRows = 0
    .FixedCols = 1
    .LoadGrid cd.FileName, flexFileExcel, 0 \'sheet
    .FixedRows = 1
    .FixedCols = 1

    .AutoSize 0, .Cols - 1


    End With
    Screen.MousePointer = 0
    lbl.Caption = \"Upload Complete...\": DoEvents
    MsgBox \"Upload successfully completed.\", vbInformation, MsgTitle
    End If

    2015/06/testfilefor-upload2.xls
  • Marked as Answer

    Reply

    Hi,

    Thanks for the detailed information.

    I would like to inform you that this is the designed behavior of the control. Loading an excel file with numeric fields in C1FlexGrid, does not update the DataType of the columns in the grid.

    For setting the DataType of the columns in the grid, you can use the ColDataType property of VSFlexGrid manually.

    Best Regards,
    Pragati Kaushik
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels