owc10 spreadsheet Column Headings, c#

T

TaiFighter

Hello,



Does anyone know how to set the column headings in an owc10
spreadsheet using c#?



I hjave tried something along the lines of below, but no luck:



OWC10.Headings myColHeadings = (OWC10.Headings)
this.axSpreadsheet1.Windows[1].ColumnHeadings[1];



myColHeadings.set_Item("Test");



If this is not possible, is it possible in owc11 and is it easy
to migrate?



Thanks,

Alan
 
A

Alvin Bruney

what you want is this
sp.ActiveWindow.ColumnHeadings(2).Caption = "Test"

this is for the web by the way so i'm not totally sure it's available for
the desk top environment but it will point you down the right road.



regards
 
T

TaiFighter

Thanks Alan

I have actually tried a number of permutations for trying to set the
headers for a Windows application and I can't find a way to do it.



Do you know if it is possible to set? Is it a set method, and is there a
way to access a specific column header to set it?



Also, I made the changes recommended to get the events to fire, but my
excel component is now read-only:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;319341

I have a licence, so I'm not sure why?



Thanks again,

Alan
 
A

Alvin Bruney

the column appears readonly. I'm sure this is not correct or I am not
accessing it the proper way because heading setting should be easy for a
windows app. I'll take another look at it later to see if I can get thru.

I would suggest you seek specialized help thru microsoft support for the
events issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top