NAME

EAI::File - read/parse Files from the filesystem or write to the filesystem

SYNOPSIS

readText ($File, $data, $filenames)
readExcel ($File, $data, $filenames)
readXML ($File, $data, $filenames)
writeText ($File, $data)
writeExcel ($File, $data)

DESCRIPTION

EAI::File contains all file parsing API-calls. This is for reading plain text data (also as quoted csv), reading excel data (old 2003 and new 2007+ format), reading xml data, writing plain text data and excel files.

API

readText ($$$)

reads the defined text file with specified parameters into array of hashes (DB ready structure)

$File      .. hash ref for File specific configuration
$data      .. hash ref for returned data (hashkey "data" -> above mentioned array of hashes)
$filenames .. array of file names, if explicit (given in case of mget and unpacked zip archives).

returns 0 on error, 1 if OK

readExcel ($$$)

reads the defined excel file with specified parameters into array of hashes (DB ready structure)

$File      .. hash ref for File specific configuration
$data      .. hash ref for returned data (hashkey "data" -> above mentioned array of hashes)
$filenames .. array of file names, if explicit (given in case of mget and unpacked zip archives).

returns 0 on error, 1 if OK

readXML ($$$)

reads the defined XML file with specified parameters into array of hashes (DB ready structure)

$File      .. hash ref for File specific configuration
$data      .. hash ref for returned data (hashkey "data" -> above mentioned array of hashes)
$filenames .. array of filenamea, if explicit (given in case of mget and unpacked zip archives).

returns 0 on error, 1 if OK

writeText ($$)

writes a text file using specified parameters from array of hashes (DB structure)

$File      .. hash ref for File specific configuration
$data      .. hash ref for returned data (hashkey "data" -> above mentioned array of hashes)

returns 0 on error, 1 if OK

writeExcel ($$)

writes an excel file using specified parameters from array of hashes (DB structure)

$File      .. hash ref for File specific configuration
$data      .. hash ref for returned data (hashkey "data" -> above mentioned array of hashes)

returns 0 on error, 1 if OK

COPYRIGHT

Copyright (c) 2023 Roland Kapl

All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

The full text of the license can be found in the LICENSE file included with this module.