$xlsPivotTable->setStyle($PIVOTTABLE_PIVOT_STYLE_DARK_11) $xlsPivotTable->addFieldToReportFilter( "Sale country") $xlsPivotTable->addFieldToValues( "Sale amount", "Sale amount per year",$PIVOTTABLE_SUBTOTAL_SUM) $xlsPivotTable->addFieldToColumnLabels( "Year") $xlsPivotTable->addFieldToRowLabels( "Sale agent") $xlsPivotTable->setLocation_2( "A3:G15") $xlsPivotTable->setSourceRange( "First tab!\$A\$1:\$E\$9",$workbook) $xlsFirstTable->easy_getCell(8,2)->setValue( "July") $xlsFirstTable->easy_getCell(8,1)->setValue( "United Kingdom") $xlsFirstTable->easy_getCell(8,0)->setValue( "Scott Valey") $xlsFirstTable->easy_getCell(7,2)->setValue( "June") $xlsFirstTable->easy_getCell(7,1)->setValue( "United Kingdom") $xlsFirstTable->easy_getCell(7,0)->setValue( "Scott Valey") $xlsFirstTable->easy_getCell(6,2)->setValue( "June") $xlsFirstTable->easy_getCell(6,0)->setValue( "Steve Marlowe") $xlsFirstTable->easy_getCell(5,2)->setValue( "July") $xlsFirstTable->easy_getCell(5,1)->setValue( "USA") $xlsFirstTable->easy_getCell(5,0)->setValue( "John Down") $xlsFirstTable->easy_getCell(4,2)->setValue( "June") $xlsFirstTable->easy_getCell(4,1)->setValue( "USA") $xlsFirstTable->easy_getCell(4,0)->setValue( "John Down") $xlsFirstTable->easy_getCell(3,2)->setValue( "July") $xlsFirstTable->easy_getCell(3,1)->setValue( "USA") $xlsFirstTable->easy_getCell(3,0)->setValue( "John Down")
$xlsFirstTable->easy_getCell(2,2)->setValue( "June") $xlsFirstTable->easy_getCell(2,1)->setValue( "United Kingdom") $xlsFirstTable->easy_getCell(2,0)->setValue( "Scott Valey") $xlsFirstTable->easy_getCell(1,2)->setValue( "June") $xlsFirstTable->easy_getCell(1,1)->setValue( "USA") $xlsFirstTable->easy_getCell(1,0)->setValue( "John Down") Add data in cells for report values - the source for pivot table $xlsFirstTable->easy_getRowAt(0)->setBold( true) $xlsFirstTable->easy_getCell(0,4)->setDataType($DATATYPE_STRING) $xlsFirstTable->easy_getCell(0,4)->setValue( "Sale amount") $xlsFirstTable->easy_getCell(0,3)->setDataType($DATATYPE_STRING) $xlsFirstTable->easy_getCell(0,3)->setValue( "Year") $xlsFirstTable->easy_getCell(0,2)->setDataType($DATATYPE_STRING) $xlsFirstTable->easy_getCell(0,2)->setValue( "Month") $xlsFirstTable->easy_getCell(0,1)->setDataType($DATATYPE_STRING) $xlsFirstTable->easy_getCell(0,1)->setValue( "Sale country") $xlsFirstTable->easy_getCell(0,0)->setDataType($DATATYPE_STRING) $xlsFirstTable->easy_getCell(0,0)->setValue( "Sale agent") $xlsFirstTable = $workbook->easy_getSheetAt(0)->easy_getExcelTable() Get the table of data for the first worksheet $workbook->easy_addWorksheet_2( "Second tab") $workbook->easy_addWorksheet_2( "First tab") $workbook = new COM( "EasyXLS.ExcelDocument") Create an instance of the class that exports Excel files
0 kommentar(er)
