How to set text style for excel

[Abdhul Saleem]

Hi,

How to set text style for an excel cell progrmattically, which is equavalant
to Excel->Format Cells->Number Tab->Text

Regards,
M. Abdhul Saleem.

 

[Hameer Saleem]

Hi Abdhul,

The key is you have to cast the particular cell to Excel.Range type, then
you will be
able to access the property Excel.Range.Style.

Here is the C# code
((Excel.Range)ws.Cells[1, 1]).Style

where ws is the Worksheet

Regards,
Hameer Saleem

 

[Hameer Saleem]

Hi again,

Sorry to have missed out your exact requirement.

For your actual scenario (Excel->Format Cells->Number Tab->Text) you can use ,

((Excel.Range)ws.Cells[1, 1]).NumberFormat

where ws is the Worksheet



Regards,
Hameer Saleem

Hi Abdhul,

The key is you have to cast the particular cell to Excel.Range type, then
you will be
able to access the property Excel.Range.Style.

Here is the C# code
((Excel.Range)ws.Cells[1, 1]).Style

where ws is the Worksheet

Regards,
Hameer Saleem

Hi,

How to set text style for an excel cell progrmattically, which is equavalant
to Excel->Format Cells->Number Tab->Text

Regards,
M. Abdhul Saleem.