I want to export my data to excel & csv files.
I have some columns with numeric data and I want that they will be shown as text columns in the file. (It is neccacery for me, becouse the numbers are very long - more than 15 digits, and the excel doesn't know display it as well, unless the column is defined as text from the beginning)
I'm try use with the FormatSetting.NumericFormat but nothing happens..
this is my code:
using (Stream stream = saveFileDialog.OpenFile())
CsvExporter exporter = new CsvExporter(MyXceedGrid);
exporter.FormatSettings.Culture = System.Globalization.CultureInfo.CurrentCulture;
exporter.FormatSettings.NumericFormat = "#";//or 0.0000, or any something else
So Please -
1. How really use with the FormatSetting ? what is wrong in my code?
2. Why the CsvExporter provides the FormatSetting, but the ExcelExporter not? (my version is 4.2.11215.9190)