MSXML 3.0 Programming xml data into Excel 2000

MSXML 3.0 Programming xml data into Excel 2000

• Txoni

  Do you want to convert Excel Data into XML

  or

  Do you want to convert XML data into Excel spreadsheet

  
  

• VenuKasarla

  hi Umut Alev

  Thanks for help

  I have to use Excel 2000 only

  and yes i have to save back the data into xml format same as i have to load into

  excel sheet using Msxml dom

  and yes i have to convert XML data into Excel spreadsheet
  

  
  
  

• sanj

  It's easy to extract data from XML DOM. There are many ways to do this.

  For example you can write and run XSLT stylesheet that output data in CSV format.

  Excel can read CSV, but will lose some formatting information -- fonts, colors, etc.

  Excel 2003 has much better support for XML. Instead of CSV you can output XML file in Excel format and then save it to .xls for further us in Excel 2000.

  Excel also has set OLE APIs for creating and modifying sheets programmatically.

  You can navigate through MSXML DOM tree node by node and insert values into Excel.

  
  
  

• tjiwe

  You may write C++/VB/JavaScript program that takes data from DOM nodes and sets values in Excel 2000 stylesheet cells.

  Excel is exports reach object model for this. It may be not so easy to find information about Excel 2000 because most articles are now discuss Excel 2003.

  You can start from http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_2003_ta/html/odc_ancexcel_00.asp.

  And find rest of information on http://www.live.com.

  
  
  

• renis

  hi Sergey Dubinets

  Thanks for help

  I have to use Excel 2000 only

  and yes i have to save back the data into xml format same as i have to load into

  excel sheet using Msxml dom

  and on the basis of xml file i have to dynamically format the excel sheet

  i.e if i have multiple nodes of <CharValues> then in excel sheet i have to

  show these value in multiple  column in  excel sheet
  

  
  
  
  
• MSXML 3.0 Programming xml data into Excel 2000