A
AA2e72E
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.
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.