// Form element
$optionValue = getOption('loadSheet', $tSheets[0]);
print formElement(formLabel('loadSheet', 'Excel sheet'), formSelect('loadSheet', $optionValue, $sheets));
// Apply sheet
$loadSheet = $optionValue;
$reader->setOption('loadSheet', $optionValue);
break;
}
}
function getOption($name, $default = null)
{
global $sessionOptions;
return array_key_exists($name, $sessionOptions) ? $sessionOptions[$name] : $default;
}
print formElement('', formSubmit('filter', 'Save options'));
print formEnd();
########################################################################################################################
## Print Excel sheet ###################################################################################################
########################################################################################################################
echo '<h2>Preview</h2>';
$workbook = $reader->load($excelFile);
$sheet = $workbook->getSheet($loadSheet);
print '<table border="1" cellpadding="1" cellspacing="0">';
for ($row = 0; $row < min(10, $sheet->getNumRows()); $row++) {
print '<tr>';
for ($col = 0; $col < $sheet->getNumColumns(); $col++) {
print '<td>' . $sheet->getCellValue($row, $col) . '</td>';
}
print '</tr>';
}
print '</table>';
border: dotted;
}
</style>
</head>
<?php
htmlBodyStart();
formStart();
getTextField();
echo getTextFieldV1('First Name', 'fname');
echo getTextFieldV1('Last Name', 'lname');
echo getTextFieldV2('Phone 1', 'phone1', 'cssClassA');
echo getTextFieldV3('Phone 2', 'phone2');
echo getTextFieldV3('City', 'city', 'cssClassA');
formEnd();
htmlBodyEnd();
htmlEnd();
function htmlStart()
{
echo "<html>";
}
function htmlEnd()
{
echo "</html>";
}
function htmlBodyStart()
{
echo "<body>";
}
function htmlBodyEnd()
