«

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.

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


"Abdhul Saleem" wrote:

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

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



"Hameer Saleem" wrote:

>
> 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
>
>
> "Abdhul Saleem" wrote:
>
> > 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.