Skip to Content
avatar image
Former Member

How to get Format cells option using OLE method?

Hi All,

I am working on OLE method for generating output in Excel format. I am facing a problem in printing number as 200,000,000 instead

in excel it is printed as 200000000, i.e without comma seperator.

Manually i am able to achieve it by right clicking on particular cell and choose format cell option.

But how to achieve it programmatic-ally using OLE method.

Please give your suggestions.

Thanks,

Teja.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 29, 2015 at 10:41 AM

    Try to use Object  CellFormat , method CellFormat.NumberFormatLocal.

    Hint: try to build/record a macro in Excel to identify parameters, or look in microsoft online help.

    Regards,

    Raymond

    Add comment
    10|10000 characters needed characters exceeded