Setting CellDataFormat to Value means that the data will be exported in the type the data is. So if a column is set to string, it will be exported to string. If the next column is set to double, it will be exported to double. Etc… In sum, you should be able to export your numeric columns as such.
What is the exception you get exactly?
Imported from legacy forums. Posted by André (had 291 views)