EasyXLS

PivotTable.inc

<?php
$PIVOTTABLE_AREA_NONE = 0;
$PIVOTTABLE_AREA_ROW_LABELS = 1;
$PIVOTTABLE_AREA_COLUMN_LABELS = 2;
$PIVOTTABLE_AREA_REPORT_FILTER = 4;
$PIVOTTABLE_SORT_A_TO_Z = 0;
$PIVOTTABLE_SORT_IN_DATA_SOURCE_ORDER = 1;
$PIVOTTABLE_SORT_Z_TO_A = 2;
$PIVOTTABLE_SORT_MANUAL = 3;
$PIVOTTABLE_PIVOT_STYLE_NONE = "None";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_1 = "PivotStyleLight1";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_2 = "PivotStyleLight2";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_3 = "PivotStyleLight3";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_4 = "PivotStyleLight4";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_5 = "PivotStyleLight5";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_6 = "PivotStyleLight6";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_7 = "PivotStyleLight7";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_8 = "PivotStyleLight8";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_9 = "PivotStyleLight9";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_10 = "PivotStyleLight10";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_11 = "PivotStyleLight11";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_12 = "PivotStyleLight12";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_13 = "PivotStyleLight13";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_14 = "PivotStyleLight14";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_15 = "PivotStyleLight15";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_16 = "PivotStyleLight16";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_17 = "PivotStyleLight17";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_18 = "PivotStyleLight18";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_19 = "PivotStyleLight19";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_20 = "PivotStyleLight20";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_21 = "PivotStyleLight21";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_22 = "PivotStyleLight22";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_23 = "PivotStyleLight23";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_24 = "PivotStyleLight24";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_25 = "PivotStyleLight25";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_26 = "PivotStyleLight26";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_27 = "PivotStyleLight27";
$PIVOTTABLE_PIVOT_STYLE_LIGHT_28 = "PivotStyleLight28";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_1 = "PivotStyleMedium1";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_2 = "PivotStyleMedium2";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_3 = "PivotStyleMedium3";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_4 = "PivotStyleMedium4";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_5 = "PivotStyleMedium5";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_6 = "PivotStyleMedium6";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_7 = "PivotStyleMedium7";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_8 = "PivotStyleMedium8";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_9 = "PivotStyleMedium9";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_10 = "PivotStyleMedium10";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_11 = "PivotStyleMedium11";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_12 = "PivotStyleMedium12";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_13 = "PivotStyleMedium13";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_14 = "PivotStyleMedium14";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_15 = "PivotStyleMedium15";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_16 = "PivotStyleMedium16";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_17 = "PivotStyleMedium17";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_18 = "PivotStyleMedium18";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_19 = "PivotStyleMedium19";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_20 = "PivotStyleMedium20";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_21 = "PivotStyleMedium21";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_22 = "PivotStyleMedium22";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_23 = "PivotStyleMedium23";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_24 = "PivotStyleMedium24";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_25 = "PivotStyleMedium25";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_26 = "PivotStyleMedium26";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_27 = "PivotStyleMedium27";
$PIVOTTABLE_PIVOT_STYLE_MEDIUM_28 = "PivotStyleMedium28";
$PIVOTTABLE_PIVOT_STYLE_DARK_1 = "PivotStyleDark1";
$PIVOTTABLE_PIVOT_STYLE_DARK_2 = "PivotStyleDark2";
$PIVOTTABLE_PIVOT_STYLE_DARK_3 = "PivotStyleDark3";
$PIVOTTABLE_PIVOT_STYLE_DARK_4 = "PivotStyleDark4";
$PIVOTTABLE_PIVOT_STYLE_DARK_5 = "PivotStyleDark5";
$PIVOTTABLE_PIVOT_STYLE_DARK_6 = "PivotStyleDark6";
$PIVOTTABLE_PIVOT_STYLE_DARK_7 = "PivotStyleDark7";
$PIVOTTABLE_PIVOT_STYLE_DARK_8 = "PivotStyleDark8";
$PIVOTTABLE_PIVOT_STYLE_DARK_9 = "PivotStyleDark9";
$PIVOTTABLE_PIVOT_STYLE_DARK_10 = "PivotStyleDark10";
$PIVOTTABLE_PIVOT_STYLE_DARK_11 = "PivotStyleDark11";
$PIVOTTABLE_PIVOT_STYLE_DARK_12 = "PivotStyleDark12";
$PIVOTTABLE_PIVOT_STYLE_DARK_13 = "PivotStyleDark13";
$PIVOTTABLE_PIVOT_STYLE_DARK_14 = "PivotStyleDark14";
$PIVOTTABLE_PIVOT_STYLE_DARK_15 = "PivotStyleDark15";
$PIVOTTABLE_PIVOT_STYLE_DARK_16 = "PivotStyleDark16";
$PIVOTTABLE_PIVOT_STYLE_DARK_17 = "PivotStyleDark17";
$PIVOTTABLE_PIVOT_STYLE_DARK_18 = "PivotStyleDark18";
$PIVOTTABLE_PIVOT_STYLE_DARK_19 = "PivotStyleDark19";
$PIVOTTABLE_PIVOT_STYLE_DARK_20 = "PivotStyleDark20";
$PIVOTTABLE_PIVOT_STYLE_DARK_21 = "PivotStyleDark21";
$PIVOTTABLE_PIVOT_STYLE_DARK_22 = "PivotStyleDark22";
$PIVOTTABLE_PIVOT_STYLE_DARK_23 = "PivotStyleDark23";
$PIVOTTABLE_PIVOT_STYLE_DARK_24 = "PivotStyleDark24";
$PIVOTTABLE_PIVOT_STYLE_DARK_25 = "PivotStyleDark25";
$PIVOTTABLE_PIVOT_STYLE_DARK_26 = "PivotStyleDark26";
$PIVOTTABLE_PIVOT_STYLE_DARK_27 = "PivotStyleDark27";
$PIVOTTABLE_PIVOT_STYLE_DARK_28 = "PivotStyleDark28";
$PIVOTTABLE_AUTOFORMAT_REPORT_1 = "Report1";
$PIVOTTABLE_AUTOFORMAT_REPORT_2 = "Report2";
$PIVOTTABLE_AUTOFORMAT_REPORT_3 = "Report3";
$PIVOTTABLE_AUTOFORMAT_REPORT_4 = "Report4";
$PIVOTTABLE_AUTOFORMAT_REPORT_5 = "Report5";
$PIVOTTABLE_AUTOFORMAT_REPORT_6 = "Report6";
$PIVOTTABLE_AUTOFORMAT_REPORT_7 = "Report7";
$PIVOTTABLE_AUTOFORMAT_REPORT_8 = "Report8";
$PIVOTTABLE_AUTOFORMAT_REPORT_9 = "Report9";
$PIVOTTABLE_AUTOFORMAT_REPORT_10 = "Report10";
$PIVOTTABLE_AUTOFORMAT_TABLE_1 = "Table1";
$PIVOTTABLE_AUTOFORMAT_TABLE_2 = "Table2";
$PIVOTTABLE_AUTOFORMAT_TABLE_3 = "Table3";
$PIVOTTABLE_AUTOFORMAT_TABLE_4 = "Table4";
$PIVOTTABLE_AUTOFORMAT_TABLE_5 = "Table5";
$PIVOTTABLE_AUTOFORMAT_TABLE_6 = "Table6";
$PIVOTTABLE_AUTOFORMAT_TABLE_7 = "Table7";
$PIVOTTABLE_AUTOFORMAT_TABLE_8 = "Table8";
$PIVOTTABLE_AUTOFORMAT_TABLE_9 = "Table9";
$PIVOTTABLE_AUTOFORMAT_TABLE_10 = "Table10";
$PIVOTTABLE_AUTOFORMAT_PIVOTTABLE_CLASIC = "PivotTableClasic";
$PIVOTTABLE_AUTOFORMAT_NONE = "None";
$PIVOTTABLE_SUBTOTAL_NONE = 0;
$PIVOTTABLE_SUBTOTAL_AUTOMATIC = 1;
$PIVOTTABLE_SUBTOTAL_SUM = 2;
$PIVOTTABLE_SUBTOTAL_COUNTA = 3;
$PIVOTTABLE_SUBTOTAL_AVERAGE = 4;
$PIVOTTABLE_SUBTOTAL_MAX = 5;
$PIVOTTABLE_SUBTOTAL_MIN = 6;
$PIVOTTABLE_SUBTOTAL_PRODUCT = 7;
$PIVOTTABLE_SUBTOTAL_COUNT = 8;
$PIVOTTABLE_SUBTOTAL_STDEV = 9;
$PIVOTTABLE_SUBTOTAL_STDEVP = 10;
$PIVOTTABLE_SUBTOTAL_VAR = 11;
$PIVOTTABLE_SUBTOTAL_VARP = 12;
$PIVOTTABLE_SUM_VALUES_FIELD = "#SUM_VALUES#";
?>

EasyXLS Excel components:

.NET
Excel Library for PHP
full COM+ version to import, export or convert Excel files
Excel Writer for PHP
COM+ version to create and export Excel files
Download EasyXLS™ Excel Component for PHP

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2019
MS Excel 2021
Office 365
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT