« Back to Serviceability XML Questions

Spreadsheet::WriteExcel::FromXML to put xml responses into excel

Combination View Flat View Tree View
Threads [ Previous | Next ]
I Had posted this in administration XML forum as well, but this seems more appropriate:
 
 
CUCM 8.5.1
 
Using Curl to grab perfmon counters from servers in a cluster - I get the xml file back and ahve done some parsing to get what I wanted but now trying to
use Spreadsheet::WriteExcel::FromXML (http://search.cpan.org/dist/Spreadsheet-WriteExcel-FromXML/lib/Spreadsheet/WriteExcel/FromXML.pm) perl module
to import the output of some of these directly to excel.  In particular, trying to get the SipStack perfmon data returned (http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/8_5_1/rtmt/rtpmcm.html#wp1071553).
 
This module seems to work well for other well-formed xml files, but I'm getting some unrecognized type errors when trying to import the output.
 
Has anyone here successfully used WriteExcel::FromXML to import cucm xml outputs directly into exce?
Is there a better method to be able to pull the perfmon counter data into an excel sheet?
 
Thanks!