search

kingwingshome / excellibrary

Automatically exported from code.google.com/p/excellibrary
0 stars 0 forks source link

Question mark in a square when exporting text data to Excel #113

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 

To export text data to excel I have used the code in C# as follows

worksheet.Cells[1, 1] = new Cell(lst.Notes.ToString(), CellFormat.General);

using the above code data exports, but when there is a enter(i.e new line) in a 
text field or special character,it is replacing
with Question mark in a square.

So,please suggest me how can I solve this issue.

Original issue reported on code.google.com by uday...@gmail.com on 7 Nov 2011 at 2:12