This project has moved and is read-only. For the latest updates, please go here.

DataType = XLCellValues.Text did not implement in excel

Dec 12, 2012 at 9:52 AM

I had a issue to request your help, When i used ws.Cell(1, 1).DataType = XLCellValues.Text; or table.FirstRow().FirstCell().DataType = XLCellValues.Text;

After save as to excel file, When i opened it and right click cell to saw format cell, Why it still be a general format cell not changed to text format cell, This is a big trouble for me cause some data of mine have value '00045' or '032/120/2554' the excel cut off '000' in my data or converted my data to date format cell.

Can you help me or any advise for this case if i want to change it to text format cell


Dec 12, 2012 at 7:43 PM

See Documentation -> FAQ