Tabs within cells in Excel


#1

Hi. I'm trying to export data from .net (C#) to Excel. I need to have a tab character in the cell. I'm using the following command:

worksheet.Cells["B2"].PutValue("Brand:\t\t\t\t" + creative.Brand);

And it's putting little squares instead of tabs. Anyone have any ideas?

Thanks, Lisa


#2

I think MS Excel doesn’t support to put a tab character into a cell for I can’t find a way to do it manually in MS Excel. Please change “\t” to 4 space characters " ".