OWC spreadsheet control in MFC dialog - need to change worksheet

T

Trips

Well-known member
Joined
Aug 7, 2010
Messages
2,788
I added a Microsoft Office Spreadsheet control (OWC11.DLL) in MFC dialog.  Also I added  the  MFC ActiveX Control wrapper class. I am able to display the data using put_CSVData and  save  using Export.  I looked at the methods (there are nearly 138 methods listed out in wrapper class - AddIn, BeginUndo, ...etc..), but I could not find a method to change spreadsheet name (default Sheet1, Sheet2 & Sheet3),  load data into Sheet2 and expand the field width. If any one of you can help me, I really appreciate it.
Thank you,
Jay.
  <hr class="sig WeJaya

View the full article
 

Similar threads

A
how to Apply Custom Control Class in Dialog Controls
Replies
0
Views
160
Amrit.shr
A
A
Which Activex control should i add to my MFC app if I want to output video using FFmpeg library?
Replies
0
Views
69
aks2161989
A
A
How can I add properties to an Mfc PropertyGrid Control inserted from the "Toolbox" ?
Replies
0
Views
85
aks2161989
A
J
Textbox control in vbnet which will have red underline if wrong spelling and make a right click to show correct spelling
Replies
0
Views
121
jepoyman
J
J
How to export data from SQL server (using query) to Excel file
Replies
0
Views
80
Julz80
J
Back
Top