$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 = new COM( 'EasyXLS.ExcelDocument') Create an instance of the class that exports Excel files
