private function PHPExcel_Writer_Excel2007_Worksheet::_writeDataValidations in Loft Data Grids 6.2
Same name and namespace in other branches
- 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php \PHPExcel_Writer_Excel2007_Worksheet::_writeDataValidations()
* Write DataValidations * *
Parameters
PHPExcel_Shared_XMLWriter $objWriter XML Writer: * @param PHPExcel_Worksheet $pSheet Worksheet * @throws PHPExcel_Writer_Exception
1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeDataValidations()
- PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet in vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel2007/ Worksheet.php - * Write worksheet to XML format * *
File
- vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel2007/ Worksheet.php, line 542
Class
- PHPExcel_Writer_Excel2007_Worksheet
- PHPExcel_Writer_Excel2007_Worksheet
Code
private function _writeDataValidations(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null) {
// Datavalidation collection
$dataValidationCollection = $pSheet
->getDataValidationCollection();
// Write data validations?
if (!empty($dataValidationCollection)) {
$objWriter
->startElement('dataValidations');
$objWriter
->writeAttribute('count', count($dataValidationCollection));
foreach ($dataValidationCollection as $coordinate => $dv) {
$objWriter
->startElement('dataValidation');
if ($dv
->getType() != '') {
$objWriter
->writeAttribute('type', $dv
->getType());
}
if ($dv
->getErrorStyle() != '') {
$objWriter
->writeAttribute('errorStyle', $dv
->getErrorStyle());
}
if ($dv
->getOperator() != '') {
$objWriter
->writeAttribute('operator', $dv
->getOperator());
}
$objWriter
->writeAttribute('allowBlank', $dv
->getAllowBlank() ? '1' : '0');
$objWriter
->writeAttribute('showDropDown', !$dv
->getShowDropDown() ? '1' : '0');
$objWriter
->writeAttribute('showInputMessage', $dv
->getShowInputMessage() ? '1' : '0');
$objWriter
->writeAttribute('showErrorMessage', $dv
->getShowErrorMessage() ? '1' : '0');
if ($dv
->getErrorTitle() !== '') {
$objWriter
->writeAttribute('errorTitle', $dv
->getErrorTitle());
}
if ($dv
->getError() !== '') {
$objWriter
->writeAttribute('error', $dv
->getError());
}
if ($dv
->getPromptTitle() !== '') {
$objWriter
->writeAttribute('promptTitle', $dv
->getPromptTitle());
}
if ($dv
->getPrompt() !== '') {
$objWriter
->writeAttribute('prompt', $dv
->getPrompt());
}
$objWriter
->writeAttribute('sqref', $coordinate);
if ($dv
->getFormula1() !== '') {
$objWriter
->writeElement('formula1', $dv
->getFormula1());
}
if ($dv
->getFormula2() !== '') {
$objWriter
->writeElement('formula2', $dv
->getFormula2());
}
$objWriter
->endElement();
}
$objWriter
->endElement();
}
}