[Lennie]

Hullo Good Guys,

I am using c#NE2008, XML, Excel 2003.

I tried transfer XML file data directly into EXCEL 2003 using OPENXML it did does work but did not produced a proper Excel Column Header Text:

This is the coding:
xlWkBook = xlApp.Application.Workbooks.OpenXML(strXMLFile, oMissing, oMissing);



I need your help, please help me. Thank you.

Once I got the coding working based on your helps, I will post the coding here to share with other Newbies who may have similar problems.

private void BtnExportExcel_Click(object sender, EventArgs e)
 
		{ //export directly from XML to Excel 2003
 

 
			string strXMLFile = @”F:\SalesDept\OrderXML.xml”;
 
			object oMissing = System.Reflection.Missing.Value;						 
 

 
			Excel.Application xlApp = new Excel.ApplicationClass();
 
			Excel.Workbook xlWkBook;
 
			Excel.Worksheet xlWksheet = null;
 
			xlApp.Visible = true;
 

 
		 xlWkBook = xlApp.Application.Workbooks.OpenXML(strXMLFile, oMissing, oMissing);							 
 
	 }

-----------------------------------------------------------------



XML FILE DATA STRUCTURE













FRANK

10267

29/07/1996

26/08/1996

06/08/1996

208.58





FRANK

10337

24/10/1996

21/11/1996

29/10/1996

108.26









------------------------------------------------------------------------------



EXCEL 2003 SPREADSHEET RESULT



/table















/row/CustomerID

/row/Freight

/row/Freight/#agg

/row/OrderDate

/row/OrderID

/row/OrderID/#agg

/row/RequiredDate

/row/ShippedDate

FRANK

208.58

208.58

29/07/1996

10267

10267

26/08/1996

06/08/1996

FRANK

108.26

108.26

24/10/1996

10337

10337

21/11/1996

29/10/1996







Looking forward for your help. I am desperate to deliver the Application. Appreciate your help very much. Thank you.


Have a Good Day,
Cheers,
Lennie