Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Spreadsheet::WriteExceUserrContributed PerlSpreadsheet::WriteExcel::FromXML(3)

NAME
       Spreadsheet::WriteExcel::FromXML	- Create Excel Spreadsheet from	XML

SYNOPSIS
	 use strict;
	 use warnings;
	 use Spreadsheet::WriteExcel::FromXML;
	 my $fromxml = Spreadsheet::WriteExcel::FromXML->new( "file.xml" );
	 $fromxml->parse;
	 $fromxml->buildSpreadsheet;
	 $fromxml->writeFile("file.xls");
	 # or
	 my $data = $fromxml->getSpreadsheetData;
	 # then	write $data to a file...or do with it as you wish

	 # or, even simpler:
	 my $data = Spreadsheet::WriteExcel::FromXML->BuildSpreadsheet(	"file.xml" );

	 # or, even simpler:
	 Spreadsheet::WriteExcel::FromXML->XMLToXLS( "file.xml", "file.xls" );

DESCRIPTION
       This module uses	Spreadsheet::WriteExcel	to turn	a simple XML data file
       into a binary Excel XLS file.

       See also	the FromXML.dtd	file in	the distribution.

API REFERENCE
   new([$])
       Param:  XML file	name - name of file to be parsed.  Return: ToExcel
       object.

       Constructor.  Optionally	takes an XML file name.

   private void	_initializeXMLSource($)
       Param:  XML file	source (GLOB, IO::Handle, file name or XML as a	string
       [or scalar ref])	Return:	true Throws: exception if unable to

       Initializer method to check for existance of the	XML file.

   parse
       Param:  XML file	name or	an IO::Handle [optional].  Return: true
       Throws: exception if xmlsource initialization fails, or if parsing
       fails

       A method	to make	the necessary calls to parse the XML file.  Remember,
       if a file handle	is passed in the calling code is responsible for
       closing it.

   _parseXMLFileToTree
       Param:  none.  Return: true

       A method	to parse an XML	file into a tree-style data structure using
       XML::Parser.

   _processTree
	 Param:	$ar	    - child xml	elements
	 Param:	$xmltag	    - the xml tag name (string)
	 Param:	$rownum	    - the current row number in	the internal worksheet
	 Param:	$column	    - the current column number	in the current row
	 Param:	$rowformat
	 Return: void.

       A method	for taking the tree-style data structure from XML::Parser and
       sticking	the data into our object structure & Spreadsheet::WriteExcel.
       After this method is called, we have an Excel spreadsheet ready for
       output.

   writeFile($)
       Param:  filename	- file name to output Excel data to.  Return:
       true/false Throws: exception if unable to open the file.

       writeFile takes a file name and writes the XLS data from	the internal
       buffer to the specified file.

   getSpreadsheetData
       Once the	spreadsheet has	been generated,	this method returns the	binary
       representation of the spreadsheet.

   workbook([$])
       Get/set method to reference our Workbook	object.

   _treeData([$])
       Get/set method for the raw XML tree data.

   _xmlfh([$])
       Get/set method for the XML file that is being parsed.

   bigflag([$])
       Get/set method for large	(>7mb) Excel spreadsheets.  If set, the	code
       will make the appriopriate calls	to build a spreadsheet >7mb.  This
       requires	a patch	to OLE::Storage_Lite.

SEE ALSO
       SpreadSheet::WriteExcel SpreadSheet::WriteExcel::FromDB
       OLE::Storage_Lite

AUTHORS
       W. Justin Bedard	juice [at] lerch.org

       Kyle R. Burton mortis [at] voicenet.com,	krburton [at] cpan.org

       Brendan W. McAdams bwmcadams [at] cpan.org <Since 1.10>

perl v5.24.1			  2006-06-2Spreadsheet::WriteExcel::FromXML(3)

NAME | SYNOPSIS | DESCRIPTION | API REFERENCE | SEE ALSO | AUTHORS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Spreadsheet::WriteExcel::FromXML&sektion=3&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help