Hello,

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

                        exporter.Export(stream);

                    } 

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)

Thanks. 

1. So Is another way to convert the column from numeric to string?

2. Although the type of the column is string, but the data contains only digits - the excel display the column as numbers, not as text. - Do you have any solution for display it as text in the file?

 thanks.

Hi Rachel,

From what you have described in your previous reply, the column's DataType is String but Excel displays it as numbers. This is how the Excel formatter works, it displays numeric values as numbers, even if the underlying data type is String. Unfortunately, this issue  falls outside the scope of our support, since it is an Excel issue not a DataGrid one.

it's says that the only way to solve this problem is - not use with your exporting at all, and do it myself -

I can define the excel columns as string!

  Excel.Application xlApp = new Excel.Application();

  Excel.Workbook xlWorkBook = xlApp.Workbooks.Add(misValue);

  Excel.Worksheet xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

  chartRange = xlWorkSheet.get_Range("e5", "e6");

  chartRange.NumberFormat = "@";

  xlWorkSheet.Cells[5, 5] = 123456789123456789; 

and it works !! this long number displayed in the excel as well ! 

Hi Rachel,

As I explained in my previous reply, this issue falls outside the scope of our support since it is not an issue with an Xceed product. Therefore, I cannot confirm if your solution, which does not contains any Xceed class or method, is valid or not. We apologize for any inconvenience this might cause you.