Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to get Format cells option using OLE method?

Former Member

‎10-28-2015 4:49 PM

0 Kudos

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.

1 REPLY 1

raymond_giuseppi
Active Contributor

‎10-29-2015 10:41 AM

0 Kudos

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