Set Number format in excel using interop

Question

Using the method below I can load a row at time into an Excel file. Once all the rows are loaded into Excel.

A column holds alphanumeric characters,if cell content is numbers its aligned to left side otherwise aligned to right side.I need to always aligned to right side.

I would like change the format of cell to Text.

 private void AddExcelRows(string startRange, int rowCount,int colCount, object values) { _range = _sheet.get_Range(startRange, _optionalValue); _range = _range.get_Resize(rowCount, colCount); _range.set_Value(_optionalValue, values); }

How can I set cell format as Text?

Philipp Schmid · Accepted Answer · 2011-07-18 16:27:56Z

5

The text format is the '@' symbol, so:

_range.NumberFormat = "@";

should do the trick.

answered Jul 18, 2011 at 16:27

Philipp Schmid

5,8485 gold badges47 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Set Number format in excel using interop

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related