Spreadsheet component OWC10 how to load XML data one sheet at a time

S

Shailesh

I have a requirement where I need to load summary data in sheet1 and
then when the user clicks on a column, I need to load the related
detail in sheet2.

Currently I load summary data using the Spreadsheet1.XMLURL property .
The XMLURL contains data for just sheet1 (summary).

Is there a method similar to LoadText which can load XML directly to a
sheet like this:-
Spreadsheet1.ActiveSheet.LoadXML ......

Otherwise, is there a way I can load XML data just to sheet2, without
refreshing the entire workbook.

(I know I can do it programmatically cell by cell)

Thanks
S
 

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

Need Help with a VBA subroutine 0
OWC10 xmlurl (passes) vs. OWC11 xmlurl (fails) 5
Spreadsheet Component with XML and Lists 2
How to Load XML data in OWC 9 1
Creating a Chart on form from selected data in query. 0
Locked Cells, Formulas, & CSV Dat 0
XML in Worksheet w/o Looping 0
OWC Spreadsheet object crashes when setting XMLURL property and sheet contains cell validation (list 0

Top