Hi Rory Kingan,
Thank you for using Syncfusion products
Please enable the preserveTypes arugment when Importing data table to worksheet.
Following code example illustrates how to import a data table to a sheet
mainsheet.ImportDataTable(dataTable, true, 1, 1,true);
Regards,
Manojkumar.