Tag Archives: Chart

Excel Number Formats

http://peltiertech.com/Excel/NumberFormats.html

Advertisements

The much hated Excel Chart Object

For more details, visit here:

http://msdn.microsoft.com/en-us/library/aa213725(v=office.11).aspx

 

When you find that the Xapp.SHEET call in VB.NET hangs, this might be the problem:
What you are trying to call is a CHART OBJECT, not a SHEET, although it looks like one!
Chart objects only have a tab at the bottom of Excel, but they do not contain cells.

To activate a sheet, make this call:
XApp.Charts(Sheetnumber).Activate()

I hope this helps some people out there!