Tabs within cells in Excel

lisapro · August 17, 2006, 11:06am

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

Laurence · August 17, 2006, 5:15pm

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 " ".