Excel

NAME

Kernel::System::DBCRUD::Format::Excel - DBCRUD Excel lib

SYNOPSIS

All DBCRUD format Excel functions.

PUBLIC INTERFACE

new()

create an object

my DBCRUDExcelObject = $Kernel::OM->Get('Kernel::System::DBCRUD::Format::Excel');

GetContent()

return content of Excel String as array-ref.

my $Array = $DBCRUDExcelObject->GetContent(
    Content => $ContentString,
);

Returns:

my $Array = [];

SetContent()

return content of array as excel string.

my $ExportString = $DBCRUDExcelObject->SetContent(
    Content => $Array,
);

Returns:

my $ExportString = '---';

_EncodeExcelValue()

This function will encode the value and move it too ascii.

$DBCRUDExcelObject->_EncodeExcelValue(\$Value);

Returns:

my $Value = 1;