The sgFormatExcel constant is NOT SUPPORTED on the ImportData method. This constant is used for Export only. The only way to transfer data from and Excel file to SharpGrid is to export their data from Excel into a CSV file, then read that file into the grid.