Office Web Component Spreadsheet: C#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can use the OWC.Spreadsheet component successfully from VB6. From C#, I cannot figure out how to activate another worksheet. The (working) code for the default active sheet is:

axSpreadsheet1.ActiveSheet.ConnectionString="Driver={Oracle in OraHome9};Server=D2K1Z01J;Database=HR;UID=AA;PWD=ORACLE";

axSpreadsheet1.ActiveSheet.CommandText="Select * from hr.employees;";

I want to be able to do this:

axSpreadsheet1.Worksheets[2].ConnectionString= ....
axSpreadsheet1.Worksheetd[2].CommandText= ....

This works in VB6: I get all kind of errors in C#. I have searched the WEB for a solution and posted the query in the C# newsgroup a few days ago: no joy at all.

Can someone show me the way? Please.
 
You must log in or register to reply here.

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

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel, Microsoft Jet and OLE-DB 7
Changing Oracle connection from DSN to DSN-Less 3
Spreadsheet Component not setting focus 2
Find & Delete Duplicates across two Excel Worksheets 12
OBDC Oracle connection in a ASP.net web page 2
PivotTable from a ADODB.Recordset ? 7
Oracle Connection String 1

Back
Top