ถาม php กับ excel ตัวอย่างการ Export Excel to XML ตัวอย่างไฟล์ excel.xls นะครับ

<?php

	function writeXML($xml)
	{
		$fp = fopen('ExcelToXML.xml', 'w+');
		fwrite($fp,$xml);
		fclose($fp);
	}

	//*** Get Document Path ***//
	$strPath = realpath(basename(getenv($_SERVER["SCRIPT_NAME"]))); // C:/AppServ/www/myphp
	$OpenFile = "excel.xls";
	
	//*** Create Exce.Application ***//
	$xlApp = new COM("Excel.Application");
	$xlBook = $xlApp->Workbooks->Open("$strPath/$OpenFile");
	$xlBook = $xlApp->Workbooks->Open(realpath($OpenFile));
	$xlSheet1 = $xlBook->Worksheets(1);	

	$xml = new DOMDocument( "1.0", "utf-8" );  // "Create" the XML document.

	$xml_root = $xml->createElement( "People" ); // Create Root Node.

	for($i=2;$i<=6;$i++)
	{
		$xml_person = $xml->createElement( "Person");  // สร้าง Node ของบุคคลแต่ละคน

		//ดึงข้อมูลจากไฟล์ Excel
		$xml_id = $xlSheet1->Cells->Item($i,1);
		$xml_name = $xlSheet1->Cells->Item($i,2);
		$xml_lastname = $xlSheet1->Cells->Item($i,3);
		$xml_address = $xlSheet1->Cells->Item($i,4);
		$xml_tel = $xlSheet1->Cells->Item($i,5);
		$xml_mail = $xlSheet1->Cells->Item($i,6);

		//Create Child  Node ของ Person
		$id = $xml->createElement("id",$xml_id);
		$name = $xml->createElement("name",$xml_name);
		$lastname = $xml->createElement("lastname",$xml_lastname);
		$address = $xml->createElement("address",$xml_address);
		$tel = $xml->createElement("tel",$xml_tel);
		$mail = $xml->createElement("mail",$xml_mail);

		// Append Child Node ของ Person
		$xml_person->appendChild( $id );
		$xml_person->appendChild( $name );
		$xml_person->appendChild( $lastname );
		$xml_person->appendChild( $address );
		$xml_person->appendChild( $tel );
		$xml_person->appendChild( $mail );

		// Append Person Node
		$xml_root->appendChild( $xml_person );
	}
	
	//*** Close & Quit ***//
	$xlApp->Application->Quit();
	$xlApp = null;
	$xlBook = null;
	$xlSheet1 = null;

	
	$xml->appendChild( $xml_root ); //Append Root Node
	$text = $xml->saveXML();	//Parse and Save the XML.

	// Write File XML
	writeXML($text); 
?>
Export Excel to XML