Can someone please explain to me why the following happens? I am creating a dataset returning information from the database, the columns I return to the dataset are all formatted according to how I require them to return in Excel. i.e int, float, datetime etc
As soon as I use the following method
GridWeb1.WebWorksheets.ImportDataView..... my data types are lost. All my data is returned to Excel with my numbers stored as text when I export the data to Excel.... (I want to convert the text to numbers without looping)....