diff options
| -rw-r--r-- | PHPINFO | 8 | ||||
| -rw-r--r-- | REFLECTION | 1700 | ||||
| -rw-r--r-- | composer.json | 19 | ||||
| -rwxr-xr-x | makesrc.sh | 30 | ||||
| -rw-r--r-- | php-pecl-xlswriter.spec | 391 |
5 files changed, 1856 insertions, 292 deletions
@@ -2,8 +2,6 @@ xlswriter xlswriter support => enabled -Version => 1.3.0 -libxlsxwriter headers version => 0.8.7 -libxlsxwriter library version => 0.8.7 -libxlsxio headers version => 0.2.21 -libxlsxio library version => 0.2.21 +Version => 2.0.3 +bundled libxlsxwriter version => 1.1.6 +bundled libxlsxreader version => self-maintained @@ -1,7 +1,20 @@ -Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { +Extension [ <persistent> extension #139 xlswriter version 2.0.3 ] { - - Classes [4] { - Class [ <internal:xlswriter> class Vtiful\Kernel\Exception extends Exception implements Throwable ] { + - Functions { + Function [ <internal:xlswriter> function xlswriter_get_version ] { + + - Parameters [0] { + } + } + Function [ <internal:xlswriter> function xlswriter_get_author ] { + + - Parameters [0] { + } + } + } + + - Classes [8] { + Class [ <internal:xlswriter> class Vtiful\Kernel\Exception extends Exception implements Throwable, Stringable ] { - Constants [0] { } @@ -13,67 +26,158 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } - Properties [4] { - Property [ <default> protected $message ] - Property [ <default> protected $code ] - Property [ <default> protected $file ] - Property [ <default> protected $line ] + Property [ protected $message = '' ] + Property [ protected $code = 0 ] + Property [ protected string $file = '' ] + Property [ protected int $line = 0 ] } - Methods [10] { Method [ <internal:Core, inherits Exception, ctor> public method __construct ] { - Parameters [3] { - Parameter #0 [ <optional> $message ] - Parameter #1 [ <optional> $code ] - Parameter #2 [ <optional> $previous ] + Parameter #0 [ <optional> string $message = "" ] + Parameter #1 [ <optional> int $code = 0 ] + Parameter #2 [ <optional> ?Throwable $previous = null ] } } Method [ <internal:Core, inherits Exception> public method __wakeup ] { + + - Parameters [0] { + } + - Tentative return [ void ] } Method [ <internal:Core, inherits Exception, prototype Throwable> final public method getMessage ] { + + - Parameters [0] { + } + - Return [ string ] } Method [ <internal:Core, inherits Exception, prototype Throwable> final public method getCode ] { + + - Parameters [0] { + } } Method [ <internal:Core, inherits Exception, prototype Throwable> final public method getFile ] { + + - Parameters [0] { + } + - Return [ string ] } Method [ <internal:Core, inherits Exception, prototype Throwable> final public method getLine ] { + + - Parameters [0] { + } + - Return [ int ] } Method [ <internal:Core, inherits Exception, prototype Throwable> final public method getTrace ] { + + - Parameters [0] { + } + - Return [ array ] } Method [ <internal:Core, inherits Exception, prototype Throwable> final public method getPrevious ] { + + - Parameters [0] { + } + - Return [ ?Throwable ] } Method [ <internal:Core, inherits Exception, prototype Throwable> final public method getTraceAsString ] { + + - Parameters [0] { + } + - Return [ string ] } - Method [ <internal:Core, inherits Exception, prototype Throwable> public method __toString ] { + Method [ <internal:Core, inherits Exception, prototype Stringable> public method __toString ] { + + - Parameters [0] { + } + - Return [ string ] } } } Class [ <internal:xlswriter> class Vtiful\Kernel\Excel ] { - - Constants [7] { - Constant [ public integer SKIP_NONE ] { 0 } - Constant [ public integer SKIP_EMPTY_ROW ] { 1 } - Constant [ public integer SKIP_EMPTY_CELLS ] { 2 } - Constant [ public integer TYPE_INT ] { 2 } - Constant [ public integer TYPE_DOUBLE ] { 4 } - Constant [ public integer TYPE_STRING ] { 1 } - Constant [ public integer TYPE_TIMESTAMP ] { 8 } + - Constants [63] { + Constant [ public int SKIP_NONE ] { 0 } + Constant [ public int SKIP_EMPTY_ROW ] { 1 } + Constant [ public int SKIP_HIDDEN_ROW ] { 8 } + Constant [ public int SKIP_EMPTY_CELLS ] { 2 } + Constant [ public int SKIP_EMPTY_VALUE ] { 256 } + Constant [ public int SKIP_MERGED_FOLLOW ] { 16 } + Constant [ public int FORMULA_VERBOSE ] { 32 } + Constant [ public int GRIDLINES_HIDE_ALL ] { 0 } + Constant [ public int GRIDLINES_SHOW_ALL ] { 3 } + Constant [ public int GRIDLINES_SHOW_PRINT ] { 2 } + Constant [ public int GRIDLINES_SHOW_SCREEN ] { 1 } + Constant [ public int PAPER_DEFAULT ] { 0 } + Constant [ public int PAPER_LETTER ] { 1 } + Constant [ public int PAPER_LETTER_SMALL ] { 2 } + Constant [ public int PAPER_TABLOID ] { 3 } + Constant [ public int PAPER_LEDGER ] { 4 } + Constant [ public int PAPER_LEGAL ] { 5 } + Constant [ public int PAPER_STATEMENT ] { 6 } + Constant [ public int PAPER_EXECUTIVE ] { 7 } + Constant [ public int PAPER_A3 ] { 8 } + Constant [ public int PAPER_A4 ] { 9 } + Constant [ public int PAPER_A4_SMALL ] { 10 } + Constant [ public int PAPER_A5 ] { 11 } + Constant [ public int PAPER_B4 ] { 12 } + Constant [ public int PAPER_B5 ] { 13 } + Constant [ public int PAPER_FOLIO ] { 14 } + Constant [ public int PAPER_QUARTO ] { 15 } + Constant [ public int PAPER_NOTE ] { 18 } + Constant [ public int PAPER_ENVELOPE_9 ] { 19 } + Constant [ public int PAPER_ENVELOPE_10 ] { 20 } + Constant [ public int PAPER_ENVELOPE_11 ] { 21 } + Constant [ public int PAPER_ENVELOPE_12 ] { 22 } + Constant [ public int PAPER_ENVELOPE_14 ] { 23 } + Constant [ public int PAPER_C_SIZE_SHEET ] { 24 } + Constant [ public int PAPER_D_SIZE_SHEET ] { 25 } + Constant [ public int PAPER_E_SIZE_SHEET ] { 26 } + Constant [ public int PAPER_ENVELOPE_DL ] { 27 } + Constant [ public int PAPER_ENVELOPE_C3 ] { 28 } + Constant [ public int PAPER_ENVELOPE_C4 ] { 29 } + Constant [ public int PAPER_ENVELOPE_C5 ] { 30 } + Constant [ public int PAPER_ENVELOPE_C6 ] { 31 } + Constant [ public int PAPER_ENVELOPE_C65 ] { 32 } + Constant [ public int PAPER_ENVELOPE_B4 ] { 33 } + Constant [ public int PAPER_ENVELOPE_B5 ] { 34 } + Constant [ public int PAPER_ENVELOPE_B6 ] { 35 } + Constant [ public int PAPER_ENVELOPE_1 ] { 36 } + Constant [ public int PAPER_MONARCH ] { 37 } + Constant [ public int PAPER_ENVELOPE_2 ] { 38 } + Constant [ public int PAPER_FANFOLD ] { 39 } + Constant [ public int PAPER_GERMAN_STD_FANFOLD ] { 40 } + Constant [ public int PAPER_GERMAN_LEGAL_FANFOLD ] { 41 } + Constant [ public int COMMENT_DISPLAY_DEFAULT ] { 0 } + Constant [ public int COMMENT_DISPLAY_HIDDEN ] { 1 } + Constant [ public int COMMENT_DISPLAY_VISIBLE ] { 2 } + Constant [ public int OBJECT_POSITION_DEFAULT ] { 0 } + Constant [ public int OBJECT_MOVE_AND_SIZE ] { 1 } + Constant [ public int OBJECT_MOVE_DONT_SIZE ] { 2 } + Constant [ public int OBJECT_DONT_MOVE_DONT_SIZE ] { 3 } + Constant [ public int OBJECT_MOVE_AND_SIZE_AFTER ] { 4 } + Constant [ public int TYPE_INT ] { 2 } + Constant [ public int TYPE_DOUBLE ] { 4 } + Constant [ public int TYPE_STRING ] { 1 } + Constant [ public int TYPE_TIMESTAMP ] { 8 } } - Static properties [0] { } - - Static methods [2] { + - Static methods [4] { Method [ <internal:xlswriter> static public method columnIndexFromString ] { - Parameters [1] { @@ -87,15 +191,29 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { Parameter #0 [ <required> $index ] } } + + Method [ <internal:xlswriter> static public method timestampFromDateDouble ] { + + - Parameters [1] { + Parameter #0 [ <required> $index ] + } + } + + Method [ <internal:xlswriter> static public method getFormulaAst ] { + + - Parameters [1] { + Parameter #0 [ <required> $formula ] + } + } } - Properties [3] { - Property [ <default> private $config ] - Property [ <default> private $fileName ] - Property [ <default> private $read_row_type ] + Property [ private $config = NULL ] + Property [ private $fileName = NULL ] + Property [ private $read_row_type = NULL ] } - - Methods [25] { + - Methods [95] { Method [ <internal:xlswriter, ctor> public method __construct ] { - Parameters [1] { @@ -103,11 +221,17 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } } + Method [ <internal:xlswriter> public method close ] { + + - Parameters [0] { + } + } + Method [ <internal:xlswriter> public method fileName ] { - Parameters [2] { Parameter #0 [ <required> $file_name ] - Parameter #1 [ <optional> $sheet_name ] + Parameter #1 [ <optional> $sheet_name = <default> ] } } @@ -118,6 +242,13 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } } + Method [ <internal:xlswriter> public method existSheet ] { + + - Parameters [1] { + Parameter #0 [ <required> $sheet_name ] + } + } + Method [ <internal:xlswriter> public method checkoutSheet ] { - Parameters [1] { @@ -125,18 +256,27 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } } + Method [ <internal:xlswriter> public method activateSheet ] { + + - Parameters [1] { + Parameter #0 [ <required> $sheet_name ] + } + } + Method [ <internal:xlswriter> public method constMemory ] { - - Parameters [2] { + - Parameters [3] { Parameter #0 [ <required> $file_name ] - Parameter #1 [ <optional> $sheet_name ] + Parameter #1 [ <optional> $sheet_name = <default> ] + Parameter #2 [ <optional> $use_zip64 = <default> ] } } Method [ <internal:xlswriter> public method header ] { - - Parameters [1] { + - Parameters [2] { Parameter #0 [ <required> $header ] + Parameter #1 [ <optional> $format_handle = <default> ] } } @@ -148,9 +288,15 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } Method [ <internal:xlswriter> public method output ] { + + - Parameters [0] { + } } Method [ <internal:xlswriter> public method getHandle ] { + + - Parameters [0] { + } } Method [ <internal:xlswriter> public method autoFilter ] { @@ -166,8 +312,18 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { Parameter #0 [ <required> $row ] Parameter #1 [ <required> $column ] Parameter #2 [ <required> $data ] - Parameter #3 [ <required> $format ] - Parameter #4 [ <required> $format_handle ] + Parameter #3 [ <optional> $format = <default> ] + Parameter #4 [ <optional> $format_handle = <default> ] + } + } + + Method [ <internal:xlswriter> public method insertRichText ] { + + - Parameters [4] { + Parameter #0 [ <required> $row ] + Parameter #1 [ <required> $column ] + Parameter #2 [ <required> $rich_strings ] + Parameter #3 [ <optional> $format_handle = <default> ] } } @@ -177,8 +333,8 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { Parameter #0 [ <required> $row ] Parameter #1 [ <required> $column ] Parameter #2 [ <required> $timestamp ] - Parameter #3 [ <required> $format ] - Parameter #4 [ <required> $format_handle ] + Parameter #3 [ <optional> $format = <default> ] + Parameter #4 [ <optional> $format_handle = <default> ] } } @@ -193,11 +349,13 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { Method [ <internal:xlswriter> public method insertUrl ] { - - Parameters [4] { + - Parameters [6] { Parameter #0 [ <required> $row ] Parameter #1 [ <required> $column ] Parameter #2 [ <required> $url ] - Parameter #3 [ <required> $format ] + Parameter #3 [ <optional> $text = <default> ] + Parameter #4 [ <optional> $tool_tip = <default> ] + Parameter #5 [ <optional> $format = <default> ] } } @@ -207,43 +365,378 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { Parameter #0 [ <required> $row ] Parameter #1 [ <required> $column ] Parameter #2 [ <required> $image ] - Parameter #3 [ <optional> $width ] - Parameter #4 [ <optional> $height ] + Parameter #3 [ <optional> $width = <default> ] + Parameter #4 [ <optional> $height = <default> ] + } + } + + Method [ <internal:xlswriter> public method insertImageOpt ] { + + - Parameters [4] { + Parameter #0 [ <required> $row ] + Parameter #1 [ <required> $column ] + Parameter #2 [ <required> $image ] + Parameter #3 [ <optional> ?array $options = <default> ] } } Method [ <internal:xlswriter> public method insertFormula ] { - - Parameters [3] { + - Parameters [4] { Parameter #0 [ <required> $row ] Parameter #1 [ <required> $column ] Parameter #2 [ <required> $formula ] + Parameter #3 [ <optional> $format_handle = <default> ] + } + } + + Method [ <internal:xlswriter> public method insertDynamicFormula ] { + + - Parameters [4] { + Parameter #0 [ <required> $row ] + Parameter #1 [ <required> $column ] + Parameter #2 [ <required> $formula ] + Parameter #3 [ <optional> $format_handle = <default> ] + } + } + + Method [ <internal:xlswriter> public method insertDynamicArrayFormula ] { + + - Parameters [6] { + Parameter #0 [ <required> $first_row ] + Parameter #1 [ <required> $first_column ] + Parameter #2 [ <required> $last_row ] + Parameter #3 [ <required> $last_column ] + Parameter #4 [ <required> $formula ] + Parameter #5 [ <optional> $format_handle = <default> ] + } + } + + Method [ <internal:xlswriter> public method insertComment ] { + + - Parameters [3] { + Parameter #0 [ <required> $row ] + Parameter #1 [ <required> $column ] + Parameter #2 [ <required> $comment ] + } + } + + Method [ <internal:xlswriter> public method showComment ] { + + - Parameters [0] { } } Method [ <internal:xlswriter> public method mergeCells ] { - - Parameters [2] { + - Parameters [3] { Parameter #0 [ <required> $range ] Parameter #1 [ <required> $data ] + Parameter #2 [ <optional> $format_handle = <default> ] } } Method [ <internal:xlswriter> public method setColumn ] { - - Parameters [3] { - Parameter #0 [ <required> $format_handle ] - Parameter #1 [ <required> $range ] - Parameter #2 [ <required> $width ] + - Parameters [6] { + Parameter #0 [ <required> $range ] + Parameter #1 [ <required> $width ] + Parameter #2 [ <optional> $format_handle = <default> ] + Parameter #3 [ <optional> $level = <default> ] + Parameter #4 [ <optional> $collapsed = <default> ] + Parameter #5 [ <optional> $hidden = <default> ] } } Method [ <internal:xlswriter> public method setRow ] { - - Parameters [3] { + - Parameters [6] { + Parameter #0 [ <required> $range ] + Parameter #1 [ <required> $height ] + Parameter #2 [ <optional> $format_handle = <default> ] + Parameter #3 [ <optional> $level = <default> ] + Parameter #4 [ <optional> $collapsed = <default> ] + Parameter #5 [ <optional> $hidden = <default> ] + } + } + + Method [ <internal:xlswriter> public method autoSize ] { + + - Parameters [1] { + Parameter #0 [ <optional> $range = <default> ] + } + } + + Method [ <internal:xlswriter> public method getCurrentLine ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method setCurrentLine ] { + + - Parameters [1] { + Parameter #0 [ <required> $row ] + } + } + + Method [ <internal:xlswriter> public method defaultFormat ] { + + - Parameters [1] { Parameter #0 [ <required> $format_handle ] - Parameter #1 [ <required> $range ] - Parameter #2 [ <required> $height ] + } + } + + Method [ <internal:xlswriter> public method defaultRowOptions ] { + + - Parameters [3] { + Parameter #0 [ <optional> $level = <default> ] + Parameter #1 [ <optional> $collapsed = <default> ] + Parameter #2 [ <optional> $hidden = <default> ] + } + } + + Method [ <internal:xlswriter> public method outlineSettings ] { + + - Parameters [4] { + Parameter #0 [ <optional> $visible = <default> ] + Parameter #1 [ <optional> $below = <default> ] + Parameter #2 [ <optional> $right = <default> ] + Parameter #3 [ <optional> $auto_style = <default> ] + } + } + + Method [ <internal:xlswriter> public method freezePanes ] { + + - Parameters [2] { + Parameter #0 [ <required> $row ] + Parameter #1 [ <required> $column ] + } + } + + Method [ <internal:xlswriter> public method protection ] { + + - Parameters [1] { + Parameter #0 [ <optional> $password = <default> ] + } + } + + Method [ <internal:xlswriter> public method validation ] { + + - Parameters [2] { + Parameter #0 [ <required> $range ] + Parameter #1 [ <required> $validation_resource ] + } + } + + Method [ <internal:xlswriter> public method zoom ] { + + - Parameters [1] { + Parameter #0 [ <required> $scale ] + } + } + + Method [ <internal:xlswriter> public method gridline ] { + + - Parameters [1] { + Parameter #0 [ <required> $option ] + } + } + + Method [ <internal:xlswriter> public method setPaper ] { + + - Parameters [1] { + Parameter #0 [ <required> $paper ] + } + } + + Method [ <internal:xlswriter> public method setMargins ] { + + - Parameters [4] { + Parameter #0 [ <required> $left ] + Parameter #1 [ <required> $right ] + Parameter #2 [ <required> $top ] + Parameter #3 [ <required> $bottom ] + } + } + + Method [ <internal:xlswriter> public method setPortrait ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method setLandscape ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method setPrintScale ] { + + - Parameters [1] { + Parameter #0 [ <optional> $scale = <default> ] + } + } + + Method [ <internal:xlswriter> public method setCurrentSheetHide ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method setCurrentSheetIsFirst ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method insertCommentOpt ] { + + - Parameters [4] { + Parameter #0 [ <required> $row ] + Parameter #1 [ <required> $column ] + Parameter #2 [ <required> $text ] + Parameter #3 [ <required> $options ] + } + } + + Method [ <internal:xlswriter> public method insertImageBuffer ] { + + - Parameters [4] { + Parameter #0 [ <required> $row ] + Parameter #1 [ <required> $column ] + Parameter #2 [ <required> $bytes ] + Parameter #3 [ <optional> $options = <default> ] + } + } + + Method [ <internal:xlswriter> public method setHeader ] { + + - Parameters [2] { + Parameter #0 [ <required> $value ] + Parameter #1 [ <optional> $options = <default> ] + } + } + + Method [ <internal:xlswriter> public method setFooter ] { + + - Parameters [2] { + Parameter #0 [ <required> $value ] + Parameter #1 [ <optional> $options = <default> ] + } + } + + Method [ <internal:xlswriter> public method repeatRows ] { + + - Parameters [1] { + Parameter #0 [ <required> $range ] + } + } + + Method [ <internal:xlswriter> public method repeatColumns ] { + + - Parameters [1] { + Parameter #0 [ <required> $range ] + } + } + + Method [ <internal:xlswriter> public method printArea ] { + + - Parameters [1] { + Parameter #0 [ <required> $range ] + } + } + + Method [ <internal:xlswriter> public method horizontalPageBreaks ] { + + - Parameters [1] { + Parameter #0 [ <required> $breaks ] + } + } + + Method [ <internal:xlswriter> public method verticalPageBreaks ] { + + - Parameters [1] { + Parameter #0 [ <required> $breaks ] + } + } + + Method [ <internal:xlswriter> public method fitToPages ] { + + - Parameters [2] { + Parameter #0 [ <required> $width ] + Parameter #1 [ <required> $height ] + } + } + + Method [ <internal:xlswriter> public method setTabColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $rgb ] + } + } + + Method [ <internal:xlswriter> public method setProperties ] { + + - Parameters [1] { + Parameter #0 [ <required> $props ] + } + } + + Method [ <internal:xlswriter> public method setCustomProperty ] { + + - Parameters [3] { + Parameter #0 [ <required> $name ] + Parameter #1 [ <required> $value ] + Parameter #2 [ <optional> $type = <default> ] + } + } + + Method [ <internal:xlswriter> public method defineName ] { + + - Parameters [3] { + Parameter #0 [ <required> $name ] + Parameter #1 [ <required> $formula ] + Parameter #2 [ <optional> $scopeSheet = <default> ] + } + } + + Method [ <internal:xlswriter> public method setBackgroundImage ] { + + - Parameters [1] { + Parameter #0 [ <required> $path ] + } + } + + Method [ <internal:xlswriter> public method setBackgroundImageBuffer ] { + + - Parameters [1] { + Parameter #0 [ <required> $bytes ] + } + } + + Method [ <internal:xlswriter> public method conditionalFormatCell ] { + + - Parameters [2] { + Parameter #0 [ <required> $range ] + Parameter #1 [ <required> $conditional_format ] + } + } + + Method [ <internal:xlswriter> public method conditionalFormatRange ] { + + - Parameters [2] { + Parameter #0 [ <required> $range ] + Parameter #1 [ <required> $conditional_format ] + } + } + + Method [ <internal:xlswriter> public method addTable ] { + + - Parameters [2] { + Parameter #0 [ <required> $range ] + Parameter #1 [ <optional> $options = <default> ] } } @@ -256,8 +749,138 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { Method [ <internal:xlswriter> public method openSheet ] { + - Parameters [2] { + Parameter #0 [ <optional> $zs_sheet_name = <default> ] + Parameter #1 [ <optional> $zl_flag = <default> ] + } + } + + Method [ <internal:xlswriter> public method putCSV ] { + + - Parameters [4] { + Parameter #0 [ <required> $fp ] + Parameter #1 [ <optional> $delimiter_str = <default> ] + Parameter #2 [ <optional> $enclosure_str = <default> ] + Parameter #3 [ <optional> $escape_str = <default> ] + } + } + + Method [ <internal:xlswriter> public method putCSVCallback ] { + + - Parameters [5] { + Parameter #0 [ <required> $callback ] + Parameter #1 [ <required> $fp ] + Parameter #2 [ <optional> $delimiter_str = <default> ] + Parameter #3 [ <optional> $enclosure_str = <default> ] + Parameter #4 [ <optional> $escape_str = <default> ] + } + } + + Method [ <internal:xlswriter> public method sheetList ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method sheetListWithMeta ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getMergedCells ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getHyperlinks ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getSheetProtection ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getRowOptions ] { + - Parameters [1] { - Parameter #0 [ <required> $zs_sheet_name ] + Parameter #0 [ <required> $row ] + } + } + + Method [ <internal:xlswriter> public method getColumnOptions ] { + + - Parameters [1] { + Parameter #0 [ <required> $colA1 ] + } + } + + Method [ <internal:xlswriter> public method getDefaultRowHeight ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getDefaultColumnWidth ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getDefinedNames ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getDataValidations ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getAutoFilter ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getPageSetup ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method nextRowRich ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getConditionalFormats ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method iterateComments ] { + + - Parameters [2] { + Parameter #0 [ <required> $callable ] + Parameter #1 [ <optional> $sheet = <default> ] + } + } + + Method [ <internal:xlswriter> public method iterateCharts ] { + + - Parameters [2] { + Parameter #0 [ <required> $callable ] + Parameter #1 [ <optional> $sheet = <default> ] } } @@ -268,17 +891,59 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } } + Method [ <internal:xlswriter> public method setGlobalType ] { + + - Parameters [1] { + Parameter #0 [ <required> $zv_type_t ] + } + } + + Method [ <internal:xlswriter> public method setSkipRows ] { + + - Parameters [1] { + Parameter #0 [ <required> $zv_skip_t ] + } + } + Method [ <internal:xlswriter> public method getSheetData ] { + + - Parameters [0] { + } } Method [ <internal:xlswriter> public method nextRow ] { + + - Parameters [1] { + Parameter #0 [ <optional> $zv_type_t = <default> ] + } + } + + Method [ <internal:xlswriter> public method nextRowWithFormula ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method getStyleFormat ] { + + - Parameters [1] { + Parameter #0 [ <required> $style_id ] + } + } + + Method [ <internal:xlswriter> public method iterateImages ] { + + - Parameters [2] { + Parameter #0 [ <required> $callback ] + Parameter #1 [ <optional> $sheet_name = <default> ] + } } Method [ <internal:xlswriter> public method nextCellCallback ] { - Parameters [2] { Parameter #0 [ <required> $fci ] - Parameter #1 [ <required> $sheet_name ] + Parameter #1 [ <optional> $sheet_name = <default> ] } } } @@ -286,71 +951,72 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { Class [ <internal:xlswriter> class Vtiful\Kernel\Format ] { - - Constants [64] { - Constant [ public integer UNDERLINE_SINGLE ] { 1 } - Constant [ public integer UNDERLINE_DOUBLE ] { 2 } - Constant [ public integer UNDERLINE_SINGLE_ACCOUNTING ] { 3 } - Constant [ public integer UNDERLINE_DOUBLE_ACCOUNTING ] { 4 } - Constant [ public integer FORMAT_ALIGN_LEFT ] { 1 } - Constant [ public integer FORMAT_ALIGN_CENTER ] { 2 } - Constant [ public integer FORMAT_ALIGN_RIGHT ] { 3 } - Constant [ public integer FORMAT_ALIGN_FILL ] { 4 } - Constant [ public integer FORMAT_ALIGN_JUSTIFY ] { 5 } - Constant [ public integer FORMAT_ALIGN_CENTER_ACROSS ] { 6 } - Constant [ public integer FORMAT_ALIGN_DISTRIBUTED ] { 7 } - Constant [ public integer FORMAT_ALIGN_VERTICAL_TOP ] { 8 } - Constant [ public integer FORMAT_ALIGN_VERTICAL_BOTTOM ] { 9 } - Constant [ public integer FORMAT_ALIGN_VERTICAL_CENTER ] { 10 } - Constant [ public integer FORMAT_ALIGN_VERTICAL_JUSTIFY ] { 11 } - Constant [ public integer FORMAT_ALIGN_VERTICAL_DISTRIBUTED ] { 12 } - Constant [ public integer COLOR_BLACK ] { 16777216 } - Constant [ public integer COLOR_BLUE ] { 255 } - Constant [ public integer COLOR_BROWN ] { 8388608 } - Constant [ public integer COLOR_CYAN ] { 65535 } - Constant [ public integer COLOR_GRAY ] { 8421504 } - Constant [ public integer COLOR_GREEN ] { 32768 } - Constant [ public integer COLOR_LIME ] { 65280 } - Constant [ public integer COLOR_MAGENTA ] { 16711935 } - Constant [ public integer COLOR_NAVY ] { 128 } - Constant [ public integer COLOR_ORANGE ] { 16737792 } - Constant [ public integer COLOR_PINK ] { 16711935 } - Constant [ public integer COLOR_PURPLE ] { 8388736 } - Constant [ public integer COLOR_RED ] { 16711680 } - Constant [ public integer COLOR_SILVER ] { 12632256 } - Constant [ public integer COLOR_WHITE ] { 16777215 } - Constant [ public integer COLOR_YELLOW ] { 16776960 } - Constant [ public integer PATTERN_NONE ] { 0 } - Constant [ public integer PATTERN_SOLID ] { 1 } - Constant [ public integer PATTERN_MEDIUM_GRAY ] { 2 } - Constant [ public integer PATTERN_DARK_GRAY ] { 3 } - Constant [ public integer PATTERN_LIGHT_GRAY ] { 4 } - Constant [ public integer PATTERN_DARK_HORIZONTAL ] { 5 } - Constant [ public integer PATTERN_DARK_VERTICAL ] { 6 } - Constant [ public integer PATTERN_DARK_DOWN ] { 7 } - Constant [ public integer PATTERN_DARK_UP ] { 8 } - Constant [ public integer PATTERN_DARK_GRID ] { 9 } - Constant [ public integer PATTERN_DARK_TRELLIS ] { 10 } - Constant [ public integer PATTERN_LIGHT_HORIZONTAL ] { 11 } - Constant [ public integer PATTERN_LIGHT_VERTICAL ] { 12 } - Constant [ public integer PATTERN_LIGHT_DOWN ] { 13 } - Constant [ public integer PATTERN_LIGHT_UP ] { 14 } - Constant [ public integer PATTERN_LIGHT_GRID ] { 15 } - Constant [ public integer PATTERN_LIGHT_TRELLIS ] { 16 } - Constant [ public integer PATTERN_GRAY_125 ] { 17 } - Constant [ public integer PATTERN_GRAY_0625 ] { 18 } - Constant [ public integer BORDER_THIN ] { 1 } - Constant [ public integer BORDER_MEDIUM ] { 2 } - Constant [ public integer BORDER_DASHED ] { 3 } - Constant [ public integer BORDER_DOTTED ] { 4 } - Constant [ public integer BORDER_THICK ] { 5 } - Constant [ public integer BORDER_DOUBLE ] { 6 } - Constant [ public integer BORDER_HAIR ] { 7 } - Constant [ public integer BORDER_MEDIUM_DASHED ] { 8 } - Constant [ public integer BORDER_DASH_DOT ] { 9 } - Constant [ public integer BORDER_MEDIUM_DASH_DOT ] { 10 } - Constant [ public integer BORDER_DASH_DOT_DOT ] { 11 } - Constant [ public integer BORDER_MEDIUM_DASH_DOT_DOT ] { 12 } - Constant [ public integer BORDER_SLANT_DASH_DOT ] { 13 } + - Constants [65] { + Constant [ public int UNDERLINE_SINGLE ] { 1 } + Constant [ public int UNDERLINE_DOUBLE ] { 2 } + Constant [ public int UNDERLINE_SINGLE_ACCOUNTING ] { 3 } + Constant [ public int UNDERLINE_DOUBLE_ACCOUNTING ] { 4 } + Constant [ public int FORMAT_ALIGN_LEFT ] { 1 } + Constant [ public int FORMAT_ALIGN_CENTER ] { 2 } + Constant [ public int FORMAT_ALIGN_RIGHT ] { 3 } + Constant [ public int FORMAT_ALIGN_FILL ] { 4 } + Constant [ public int FORMAT_ALIGN_JUSTIFY ] { 5 } + Constant [ public int FORMAT_ALIGN_CENTER_ACROSS ] { 6 } + Constant [ public int FORMAT_ALIGN_DISTRIBUTED ] { 7 } + Constant [ public int FORMAT_ALIGN_VERTICAL_TOP ] { 8 } + Constant [ public int FORMAT_ALIGN_VERTICAL_BOTTOM ] { 9 } + Constant [ public int FORMAT_ALIGN_VERTICAL_CENTER ] { 10 } + Constant [ public int FORMAT_ALIGN_VERTICAL_JUSTIFY ] { 11 } + Constant [ public int FORMAT_ALIGN_VERTICAL_DISTRIBUTED ] { 12 } + Constant [ public int COLOR_BLACK ] { 16777216 } + Constant [ public int COLOR_BLUE ] { 255 } + Constant [ public int COLOR_BROWN ] { 8388608 } + Constant [ public int COLOR_CYAN ] { 65535 } + Constant [ public int COLOR_GRAY ] { 8421504 } + Constant [ public int COLOR_GREEN ] { 32768 } + Constant [ public int COLOR_LIME ] { 65280 } + Constant [ public int COLOR_MAGENTA ] { 16711935 } + Constant [ public int COLOR_NAVY ] { 128 } + Constant [ public int COLOR_ORANGE ] { 16737792 } + Constant [ public int COLOR_PINK ] { 16711935 } + Constant [ public int COLOR_PURPLE ] { 8388736 } + Constant [ public int COLOR_RED ] { 16711680 } + Constant [ public int COLOR_SILVER ] { 12632256 } + Constant [ public int COLOR_WHITE ] { 16777215 } + Constant [ public int COLOR_YELLOW ] { 16776960 } + Constant [ public int PATTERN_NONE ] { 0 } + Constant [ public int PATTERN_SOLID ] { 1 } + Constant [ public int PATTERN_MEDIUM_GRAY ] { 2 } + Constant [ public int PATTERN_DARK_GRAY ] { 3 } + Constant [ public int PATTERN_LIGHT_GRAY ] { 4 } + Constant [ public int PATTERN_DARK_HORIZONTAL ] { 5 } + Constant [ public int PATTERN_DARK_VERTICAL ] { 6 } + Constant [ public int PATTERN_DARK_DOWN ] { 7 } + Constant [ public int PATTERN_DARK_UP ] { 8 } + Constant [ public int PATTERN_DARK_GRID ] { 9 } + Constant [ public int PATTERN_DARK_TRELLIS ] { 10 } + Constant [ public int PATTERN_LIGHT_HORIZONTAL ] { 11 } + Constant [ public int PATTERN_LIGHT_VERTICAL ] { 12 } + Constant [ public int PATTERN_LIGHT_DOWN ] { 13 } + Constant [ public int PATTERN_LIGHT_UP ] { 14 } + Constant [ public int PATTERN_LIGHT_GRID ] { 15 } + Constant [ public int PATTERN_LIGHT_TRELLIS ] { 16 } + Constant [ public int PATTERN_GRAY_125 ] { 17 } + Constant [ public int PATTERN_GRAY_0625 ] { 18 } + Constant [ public int BORDER_NONE ] { 0 } + Constant [ public int BORDER_THIN ] { 1 } + Constant [ public int BORDER_MEDIUM ] { 2 } + Constant [ public int BORDER_DASHED ] { 3 } + Constant [ public int BORDER_DOTTED ] { 4 } + Constant [ public int BORDER_THICK ] { 5 } + Constant [ public int BORDER_DOUBLE ] { 6 } + Constant [ public int BORDER_HAIR ] { 7 } + Constant [ public int BORDER_MEDIUM_DASHED ] { 8 } + Constant [ public int BORDER_DASH_DOT ] { 9 } + Constant [ public int BORDER_MEDIUM_DASH_DOT ] { 10 } + Constant [ public int BORDER_DASH_DOT_DOT ] { 11 } + Constant [ public int BORDER_MEDIUM_DASH_DOT_DOT ] { 12 } + Constant [ public int BORDER_SLANT_DASH_DOT ] { 13 } } - Static properties [0] { @@ -362,7 +1028,7 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { - Properties [0] { } - - Methods [13] { + - Methods [22] { Method [ <internal:xlswriter, ctor> public method __construct ] { - Parameters [1] { @@ -371,12 +1037,21 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } Method [ <internal:xlswriter> public method wrap ] { + + - Parameters [0] { + } } Method [ <internal:xlswriter> public method bold ] { + + - Parameters [0] { + } } Method [ <internal:xlswriter> public method italic ] { + + - Parameters [0] { + } } Method [ <internal:xlswriter> public method border ] { @@ -386,10 +1061,37 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } } + Method [ <internal:xlswriter> public method borderOfTheFourSides ] { + + - Parameters [4] { + Parameter #0 [ <required> $top ] + Parameter #1 [ <required> $right ] + Parameter #2 [ <required> $bottom ] + Parameter #3 [ <required> $left ] + } + } + + Method [ <internal:xlswriter> public method borderColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $color ] + } + } + + Method [ <internal:xlswriter> public method borderColorOfTheFourSides ] { + + - Parameters [4] { + Parameter #0 [ <required> $top_color ] + Parameter #1 [ <required> $right_color ] + Parameter #2 [ <required> $bottom_color ] + Parameter #3 [ <required> $left_color ] + } + } + Method [ <internal:xlswriter> public method align ] { - Parameters [1] { - Parameter #0 [ <required> $style ] + Parameter #0 [ <required> ...$style ] } } @@ -407,6 +1109,13 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } } + Method [ <internal:xlswriter> public method font ] { + + - Parameters [1] { + Parameter #0 [ <required> $font ] + } + } + Method [ <internal:xlswriter> public method fontSize ] { - Parameters [1] { @@ -415,6 +1124,9 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } Method [ <internal:xlswriter> public method strikeout ] { + + - Parameters [0] { + } } Method [ <internal:xlswriter> public method underline ] { @@ -424,14 +1136,49 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } } + Method [ <internal:xlswriter> public method unlocked ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method locked ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method hidden ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method rotation ] { + + - Parameters [1] { + Parameter #0 [ <required> $angle ] + } + } + + Method [ <internal:xlswriter> public method indent ] { + + - Parameters [1] { + Parameter #0 [ <required> $level ] + } + } + Method [ <internal:xlswriter> public method toResource ] { + + - Parameters [0] { + } } Method [ <internal:xlswriter> public method background ] { - Parameters [2] { Parameter #0 [ <required> $pattern ] - Parameter #1 [ <required> $color ] + Parameter #1 [ <optional> $color = <default> ] } } } @@ -439,34 +1186,36 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { Class [ <internal:xlswriter> class Vtiful\Kernel\Chart ] { - - Constants [27] { - Constant [ public integer CHART_BAR ] { 4 } - Constant [ public integer CHART_BAR_STACKED ] { 5 } - Constant [ public integer CHART_BAR_STACKED_PERCENT ] { 6 } - Constant [ public integer CHART_AREA ] { 1 } - Constant [ public integer CHART_AREA_STACKED ] { 2 } - Constant [ public integer CHART_AREA_STACKED_PERCENT ] { 3 } - Constant [ public integer CHART_LINE ] { 11 } - Constant [ public integer CHART_COLUMN ] { 7 } - Constant [ public integer CHART_COLUMN_STACKED ] { 8 } - Constant [ public integer CHART_COLUMN_STACKED_PERCENT ] { 9 } - Constant [ public integer CHART_DOUGHNUT ] { 10 } - Constant [ public integer CHART_PIE ] { 12 } - Constant [ public integer CHART_SCATTER ] { 13 } - Constant [ public integer CHART_SCATTER_STRAIGHT ] { 14 } - Constant [ public integer CHART_SCATTER_STRAIGHT_WITH_MARKERS ] { 15 } - Constant [ public integer CHART_SCATTER_SMOOTH ] { 16 } - Constant [ public integer CHART_SCATTER_SMOOTH_WITH_MARKERS ] { 17 } - Constant [ public integer CHART_RADAR ] { 18 } - Constant [ public integer CHART_RADAR_WITH_MARKERS ] { 19 } - Constant [ public integer CHART_RADAR_FILLED ] { 20 } - Constant [ public integer CHART_LEGEND_NONE ] { 0 } - Constant [ public integer CHART_LEGEND_RIGHT ] { 1 } - Constant [ public integer CHART_LEGEND_LEFT ] { 2 } - Constant [ public integer CHART_LEGEND_TOP ] { 3 } - Constant [ public integer CHART_LEGEND_BOTTOM ] { 4 } - Constant [ public integer CHART_LEGEND_OVERLAY_RIGHT ] { 6 } - Constant [ public integer CHART_LEGEND_OVERLAY_LEFT ] { 7 } + - Constants [29] { + Constant [ public int CHART_BAR ] { 4 } + Constant [ public int CHART_BAR_STACKED ] { 5 } + Constant [ public int CHART_BAR_STACKED_PERCENT ] { 6 } + Constant [ public int CHART_AREA ] { 1 } + Constant [ public int CHART_AREA_STACKED ] { 2 } + Constant [ public int CHART_AREA_STACKED_PERCENT ] { 3 } + Constant [ public int CHART_LINE ] { 11 } + Constant [ public int CHART_COLUMN ] { 7 } + Constant [ public int CHART_COLUMN_STACKED ] { 8 } + Constant [ public int CHART_COLUMN_STACKED_PERCENT ] { 9 } + Constant [ public int CHART_DOUGHNUT ] { 10 } + Constant [ public int CHART_PIE ] { 14 } + Constant [ public int CHART_SCATTER ] { 15 } + Constant [ public int CHART_SCATTER_STRAIGHT ] { 16 } + Constant [ public int CHART_SCATTER_STRAIGHT_WITH_MARKERS ] { 17 } + Constant [ public int CHART_SCATTER_SMOOTH ] { 18 } + Constant [ public int CHART_SCATTER_SMOOTH_WITH_MARKERS ] { 19 } + Constant [ public int CHART_RADAR ] { 20 } + Constant [ public int CHART_RADAR_WITH_MARKERS ] { 21 } + Constant [ public int CHART_RADAR_FILLED ] { 22 } + Constant [ public int CHART_LEGEND_NONE ] { 0 } + Constant [ public int CHART_LEGEND_RIGHT ] { 1 } + Constant [ public int CHART_LEGEND_LEFT ] { 2 } + Constant [ public int CHART_LEGEND_TOP ] { 3 } + Constant [ public int CHART_LEGEND_BOTTOM ] { 4 } + Constant [ public int CHART_LEGEND_OVERLAY_RIGHT ] { 6 } + Constant [ public int CHART_LEGEND_OVERLAY_LEFT ] { 7 } + Constant [ public int CHART_LINE_STACKED ] { 12 } + Constant [ public int CHART_LINE_STACKED_PERCENT ] { 13 } } - Static properties [0] { @@ -491,7 +1240,7 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { - Parameters [2] { Parameter #0 [ <required> $value ] - Parameter #1 [ <optional> $categories ] + Parameter #1 [ <optional> $categories = <default> ] } } @@ -538,6 +1287,669 @@ Extension [ <persistent> extension #173 xlswriter version 1.3.0 ] { } Method [ <internal:xlswriter> public method toResource ] { + + - Parameters [0] { + } + } + } + } + + Class [ <internal:xlswriter> class Vtiful\Kernel\Validation ] { + + - Constants [27] { + Constant [ public int TYPE_INTEGER ] { 1 } + Constant [ public int TYPE_INTEGER_FORMULA ] { 2 } + Constant [ public int TYPE_DECIMAL ] { 3 } + Constant [ public int TYPE_DECIMAL_FORMULA ] { 4 } + Constant [ public int TYPE_LIST ] { 5 } + Constant [ public int TYPE_LIST_FORMULA ] { 6 } + Constant [ public int TYPE_DATE ] { 7 } + Constant [ public int TYPE_DATE_FORMULA ] { 8 } + Constant [ public int TYPE_DATE_NUMBER ] { 9 } + Constant [ public int TYPE_TIME ] { 10 } + Constant [ public int TYPE_TIME_FORMULA ] { 11 } + Constant [ public int TYPE_TIME_NUMBER ] { 12 } + Constant [ public int TYPE_LENGTH ] { 13 } + Constant [ public int TYPE_LENGTH_FORMULA ] { 14 } + Constant [ public int TYPE_CUSTOM_FORMULA ] { 15 } + Constant [ public int TYPE_ANY ] { 16 } + Constant [ public int CRITERIA_BETWEEN ] { 1 } + Constant [ public int CRITERIA_NOT_BETWEEN ] { 2 } + Constant [ public int CRITERIA_EQUAL_TO ] { 3 } + Constant [ public int CRITERIA_NOT_EQUAL_TO ] { 4 } + Constant [ public int CRITERIA_GREATER_THAN ] { 5 } + Constant [ public int CRITERIA_LESS_THAN ] { 6 } + Constant [ public int CRITERIA_GREATER_THAN_OR_EQUAL_TO ] { 7 } + Constant [ public int CRITERIA_LESS_THAN_OR_EQUAL_TO ] { 8 } + Constant [ public int ERROR_TYPE_STOP ] { 0 } + Constant [ public int ERROR_TYPE_WARNING ] { 1 } + Constant [ public int ERROR_TYPE_INFORMATION ] { 2 } + } + + - Static properties [0] { + } + + - Static methods [0] { + } + + - Properties [0] { + } + + - Methods [23] { + Method [ <internal:xlswriter, ctor> public method __construct ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method validationType ] { + + - Parameters [1] { + Parameter #0 [ <required> $type ] + } + } + + Method [ <internal:xlswriter> public method criteriaType ] { + + - Parameters [1] { + Parameter #0 [ <required> $type ] + } + } + + Method [ <internal:xlswriter> public method ignoreBlank ] { + + - Parameters [1] { + Parameter #0 [ <required> $ignore_blank ] + } + } + + Method [ <internal:xlswriter> public method showInput ] { + + - Parameters [1] { + Parameter #0 [ <required> $show_input ] + } + } + + Method [ <internal:xlswriter> public method showError ] { + + - Parameters [1] { + Parameter #0 [ <required> $show_error ] + } + } + + Method [ <internal:xlswriter> public method errorType ] { + + - Parameters [1] { + Parameter #0 [ <required> $error_type ] + } + } + + Method [ <internal:xlswriter> public method dropdown ] { + + - Parameters [1] { + Parameter #0 [ <required> $dropdown ] + } + } + + Method [ <internal:xlswriter> public method valueNumber ] { + + - Parameters [1] { + Parameter #0 [ <required> $value_number ] + } + } + + Method [ <internal:xlswriter> public method valueFormula ] { + + - Parameters [1] { + Parameter #0 [ <required> $value_formula ] + } + } + + Method [ <internal:xlswriter> public method valueList ] { + + - Parameters [1] { + Parameter #0 [ <required> $value_list ] + } + } + + Method [ <internal:xlswriter> public method valueDatetime ] { + + - Parameters [1] { + Parameter #0 [ <required> $timestamp ] + } + } + + Method [ <internal:xlswriter> public method minimumNumber ] { + + - Parameters [1] { + Parameter #0 [ <required> $minimum_number ] + } + } + + Method [ <internal:xlswriter> public method minimumFormula ] { + + - Parameters [1] { + Parameter #0 [ <required> $minimum_formula ] + } + } + + Method [ <internal:xlswriter> public method minimumDatetime ] { + + - Parameters [1] { + Parameter #0 [ <required> $timestamp ] + } + } + + Method [ <internal:xlswriter> public method maximumNumber ] { + + - Parameters [1] { + Parameter #0 [ <required> $maximum_number ] + } + } + + Method [ <internal:xlswriter> public method maximumFormula ] { + + - Parameters [1] { + Parameter #0 [ <required> $maximum_formula ] + } + } + + Method [ <internal:xlswriter> public method maximumDatetime ] { + + - Parameters [1] { + Parameter #0 [ <required> $maximum_datetime ] + } + } + + Method [ <internal:xlswriter> public method inputTitle ] { + + - Parameters [1] { + Parameter #0 [ <required> $input_title ] + } + } + + Method [ <internal:xlswriter> public method inputMessage ] { + + - Parameters [1] { + Parameter #0 [ <required> $input_message ] + } + } + + Method [ <internal:xlswriter> public method errorTitle ] { + + - Parameters [1] { + Parameter #0 [ <required> $error_titile ] + } + } + + Method [ <internal:xlswriter> public method errorMessage ] { + + - Parameters [1] { + Parameter #0 [ <required> $error_message ] + } + } + + Method [ <internal:xlswriter> public method toResource ] { + + - Parameters [0] { + } + } + } + } + + Class [ <internal:xlswriter> class Vtiful\Kernel\RichString ] { + + - Constants [0] { + } + + - Static properties [0] { + } + + - Static methods [0] { + } + + - Properties [0] { + } + + - Methods [1] { + Method [ <internal:xlswriter, ctor> public method __construct ] { + + - Parameters [2] { + Parameter #0 [ <required> $text ] + Parameter #1 [ <optional> $format_handle = <default> ] + } + } + } + } + + Class [ <internal:xlswriter> class Vtiful\Kernel\ConditionalFormat ] { + + - Constants [71] { + Constant [ public int TYPE_CELL ] { 1 } + Constant [ public int TYPE_TEXT ] { 2 } + Constant [ public int TYPE_TIME_PERIOD ] { 3 } + Constant [ public int TYPE_AVERAGE ] { 4 } + Constant [ public int TYPE_DUPLICATE ] { 5 } + Constant [ public int TYPE_UNIQUE ] { 6 } + Constant [ public int TYPE_TOP ] { 7 } + Constant [ public int TYPE_BOTTOM ] { 8 } + Constant [ public int TYPE_BLANKS ] { 9 } + Constant [ public int TYPE_NO_BLANKS ] { 10 } + Constant [ public int TYPE_ERRORS ] { 11 } + Constant [ public int TYPE_NO_ERRORS ] { 12 } + Constant [ public int TYPE_FORMULA ] { 13 } + Constant [ public int TYPE_2_COLOR_SCALE ] { 14 } + Constant [ public int TYPE_3_COLOR_SCALE ] { 15 } + Constant [ public int TYPE_DATA_BAR ] { 16 } + Constant [ public int TYPE_ICON_SETS ] { 17 } + Constant [ public int CRITERIA_EQUAL_TO ] { 1 } + Constant [ public int CRITERIA_NOT_EQUAL_TO ] { 2 } + Constant [ public int CRITERIA_GREATER_THAN ] { 3 } + Constant [ public int CRITERIA_LESS_THAN ] { 4 } + Constant [ public int CRITERIA_GREATER_THAN_OR_EQUAL_TO ] { 5 } + Constant [ public int CRITERIA_LESS_THAN_OR_EQUAL_TO ] { 6 } + Constant [ public int CRITERIA_BETWEEN ] { 7 } + Constant [ public int CRITERIA_NOT_BETWEEN ] { 8 } + Constant [ public int CRITERIA_TEXT_CONTAINING ] { 9 } + Constant [ public int CRITERIA_TEXT_NOT_CONTAINING ] { 10 } + Constant [ public int CRITERIA_TEXT_BEGINS_WITH ] { 11 } + Constant [ public int CRITERIA_TEXT_ENDS_WITH ] { 12 } + Constant [ public int CRITERIA_TIME_PERIOD_YESTERDAY ] { 13 } + Constant [ public int CRITERIA_TIME_PERIOD_TODAY ] { 14 } + Constant [ public int CRITERIA_TIME_PERIOD_TOMORROW ] { 15 } + Constant [ public int CRITERIA_TIME_PERIOD_LAST_7_DAYS ] { 16 } + Constant [ public int CRITERIA_TIME_PERIOD_LAST_WEEK ] { 17 } + Constant [ public int CRITERIA_TIME_PERIOD_THIS_WEEK ] { 18 } + Constant [ public int CRITERIA_TIME_PERIOD_NEXT_WEEK ] { 19 } + Constant [ public int CRITERIA_TIME_PERIOD_LAST_MONTH ] { 20 } + Constant [ public int CRITERIA_TIME_PERIOD_THIS_MONTH ] { 21 } + Constant [ public int CRITERIA_TIME_PERIOD_NEXT_MONTH ] { 22 } + Constant [ public int CRITERIA_AVERAGE_ABOVE ] { 23 } + Constant [ public int CRITERIA_AVERAGE_BELOW ] { 24 } + Constant [ public int CRITERIA_TOP_OR_BOTTOM_PERCENT ] { 33 } + Constant [ public int RULE_MINIMUM ] { 1 } + Constant [ public int RULE_NUMBER ] { 2 } + Constant [ public int RULE_PERCENT ] { 3 } + Constant [ public int RULE_PERCENTILE ] { 4 } + Constant [ public int RULE_FORMULA ] { 5 } + Constant [ public int RULE_MAXIMUM ] { 6 } + Constant [ public int BAR_DIRECTION_CONTEXT ] { 0 } + Constant [ public int BAR_DIRECTION_LEFT_TO_RIGHT ] { 2 } + Constant [ public int BAR_DIRECTION_RIGHT_TO_LEFT ] { 1 } + Constant [ public int BAR_AXIS_AUTOMATIC ] { 0 } + Constant [ public int BAR_AXIS_MIDPOINT ] { 1 } + Constant [ public int BAR_AXIS_NONE ] { 2 } + Constant [ public int ICONS_3_ARROWS_COLORED ] { 0 } + Constant [ public int ICONS_3_ARROWS_GRAY ] { 1 } + Constant [ public int ICONS_3_FLAGS ] { 2 } + Constant [ public int ICONS_3_TRAFFIC_LIGHTS_UNRIMMED ] { 3 } + Constant [ public int ICONS_3_TRAFFIC_LIGHTS_RIMMED ] { 4 } + Constant [ public int ICONS_3_SIGNS ] { 5 } + Constant [ public int ICONS_3_SYMBOLS_CIRCLED ] { 6 } + Constant [ public int ICONS_3_SYMBOLS_UNCIRCLED ] { 7 } + Constant [ public int ICONS_4_ARROWS_COLORED ] { 8 } + Constant [ public int ICONS_4_ARROWS_GRAY ] { 9 } + Constant [ public int ICONS_4_RED_TO_BLACK ] { 10 } + Constant [ public int ICONS_4_RATINGS ] { 11 } + Constant [ public int ICONS_4_TRAFFIC_LIGHTS ] { 12 } + Constant [ public int ICONS_5_ARROWS_COLORED ] { 13 } + Constant [ public int ICONS_5_ARROWS_GRAY ] { 14 } + Constant [ public int ICONS_5_RATINGS ] { 15 } + Constant [ public int ICONS_5_QUARTERS ] { 16 } + } + + - Static properties [0] { + } + + - Static methods [0] { + } + + - Properties [0] { + } + + - Methods [34] { + Method [ <internal:xlswriter, ctor> public method __construct ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method type ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method criteria ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method value ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method valueString ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method minimum ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method minimumString ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method minimumRule ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method minimumColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method middle ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method middleString ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method middleRule ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method middleColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method maximum ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method maximumString ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method maximumRule ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method maximumColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method format ] { + + - Parameters [1] { + Parameter #0 [ <required> $format ] + } + } + + Method [ <internal:xlswriter> public method barColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method barOnly ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method dataBar2010 ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method barSolid ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method barNegativeColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method barBorderColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method barNegativeBorderColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method barNoBorder ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method barDirection ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method barAxisPosition ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method barAxisColor ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method iconStyle ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method reverseIcons ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method iconsOnly ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method multiRange ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method stopIfTrue ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + } + } + + Class [ <internal:xlswriter> class Vtiful\Kernel\Table ] { + + - Constants [13] { + Constant [ public int STYLE_TYPE_DEFAULT ] { 0 } + Constant [ public int STYLE_TYPE_LIGHT ] { 1 } + Constant [ public int STYLE_TYPE_MEDIUM ] { 2 } + Constant [ public int STYLE_TYPE_DARK ] { 3 } + Constant [ public int FUNCTION_NONE ] { 0 } + Constant [ public int FUNCTION_AVERAGE ] { 101 } + Constant [ public int FUNCTION_COUNT_NUMS ] { 102 } + Constant [ public int FUNCTION_COUNT ] { 103 } + Constant [ public int FUNCTION_MAX ] { 104 } + Constant [ public int FUNCTION_MIN ] { 105 } + Constant [ public int FUNCTION_STD_DEV ] { 107 } + Constant [ public int FUNCTION_SUM ] { 109 } + Constant [ public int FUNCTION_VAR ] { 110 } + } + + - Static properties [0] { + } + + - Static methods [0] { + } + + - Properties [0] { + } + + - Methods [11] { + Method [ <internal:xlswriter, ctor> public method __construct ] { + + - Parameters [0] { + } + } + + Method [ <internal:xlswriter> public method name ] { + + - Parameters [1] { + Parameter #0 [ <required> $value ] + } + } + + Method [ <internal:xlswriter> public method noHeaderRow ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method noAutofilter ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method noBandedRows ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method bandedColumns ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method firstColumn ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method lastColumn ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method totalRow ] { + + - Parameters [1] { + Parameter #0 [ <optional> $on = <default> ] + } + } + + Method [ <internal:xlswriter> public method style ] { + + - Parameters [2] { + Parameter #0 [ <required> $type ] + Parameter #1 [ <required> $number ] + } + } + + Method [ <internal:xlswriter> public method columns ] { + + - Parameters [1] { + Parameter #0 [ <required> $columns ] + } } } } diff --git a/composer.json b/composer.json new file mode 100644 index 0000000..e1e2629 --- /dev/null +++ b/composer.json @@ -0,0 +1,19 @@ +{ + "name": "viest/xlswriter", + "type": "php-ext", + "license": "BSD-2-Clause", + "description": "xlswriter is a PHP C Extension that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.", + "require": { + "php": ">= 7.0" + }, + "php-ext": { + "extension-name": "xlswriter", + "download-url-method": "pre-packaged-source", + "configure-options": [ + { + "name": "disable-reader", + "description": "Disable reader support" + } + ] + } +} diff --git a/makesrc.sh b/makesrc.sh new file mode 100755 index 0000000..dfadee6 --- /dev/null +++ b/makesrc.sh @@ -0,0 +1,30 @@ +#!/bin/bash + +NAME=$(basename $PWD) +OWNER=$(sed -n '/^%global gh_vend/{s/.* //;p}' $NAME.spec) +PROJECT=$(sed -n '/^%global gh_proj/{s/.* //;p}' $NAME.spec) +VERSION=$(sed -n '/^Version/{s/.* //;p}' $NAME.spec) + +echo -e "\nCreate git snapshot\nName=$NAME, Owner=$OWNER, Project=$PROJECT, Version=$VERSION\n" + +if [ -f $PROJECT-$VERSION.tgz ]; then + echo $PROJECT-$VERSION.tgz already present + exit 1 +fi + +echo "Cloning..." +rm -rf $PROJECT-$VERSION +git clone --recursive https://github.com/$OWNER/$PROJECT.git -b v$VERSION $PROJECT-$VERSION + +echo "Composer..." +pushd $PROJECT-$VERSION + cp composer.json .. +popd + +echo "Archiving..." +tar czf $PROJECT-$VERSION.tgz --exclude-vcs $PROJECT-$VERSION + +echo "Cleaning..." +rm -rf $PROJECT-$VERSION + +echo "Done." diff --git a/php-pecl-xlswriter.spec b/php-pecl-xlswriter.spec index 4892581..bf648ff 100644 --- a/php-pecl-xlswriter.spec +++ b/php-pecl-xlswriter.spec @@ -1,112 +1,94 @@ # remirepo spec file for php-pecl-xlswriter # -# Copyright (c) 2018-2019 Remi Collet -# License: CC-BY-SA -# http://creativecommons.org/licenses/by-sa/4.0/ +# SPDX-FileCopyrightText: Copyright 2018-2026 Remi Collet +# SPDX-License-Identifier: CECILL-2.1 +# http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt # # Please, preserve the changelog entries # -# we don't want -z defs linker flag -%undefine _strict_symbol_defs_build +%bcond_without tests -%if 0%{?scl:1} -%scl_package php-pecl-xlswriter -%global sub_prefix %{scl_prefix} -%endif +%{?scl:%scl_package php-pecl-xlswriter} -%global with_tests 0%{!?_without_tests:1} -%global with_zts 0%{!?_without_zts:%{?__ztsphp:1}} %global pecl_name xlswriter -# After json +%global with_zts 0%{!?_without_zts:%{?__ztsphp:1}} %global ini_name 40-%{pecl_name}.ini - -# No soname, so manage dependency on available version -%global libxlsxwriter_version 0.8.7 -%global libxlsxio_version 0.2.21 - -Summary: An efficient and fast xlsx file export extension -Name: %{?sub_prefix}php-pecl-%{pecl_name} -Version: 1.3.0 -Release: 1%{?dist}%{!?scl:%{!?nophptag:%(%{__php} -r 'echo ".".PHP_MAJOR_VERSION.".".PHP_MINOR_VERSION;')}} -License: BSD -URL: http://pecl.php.net/package/%{pecl_name} -Source0: http://pecl.php.net/get/%{pecl_name}-%{version}.tgz +%global _configure ../configure +# Github forge +%global gh_vend viest +%global gh_proj php-ext-xlswriter +%global forgeurl https://github.com/%{gh_vend}/%{gh_proj} +# PIE +%global pie_vend %{gh_vend} +%global pie_proj %{pecl_name} + + +Name: %{?scl_prefix}php-pecl-%{pecl_name} +Summary: An efficient and fast xlsx file extension +License: BSD-2-Clause +Version: 2.0.3 +Release: 1%{?dist} +%forgemeta +URL: %{forgeurl} +# use makesrc.sh to create a recursive snapshot +Source0: %{gh_proj}-%{version}.tgz +Source1: makesrc.sh BuildRequires: %{?dtsprefix}gcc -BuildRequires: %{?scl_prefix}php-devel >= 7 -BuildRequires: %{?scl_prefix}php-pear -BuildRequires: libxlsxwriter-devel >= %{libxlsxwriter_version} -BuildRequires: libxlsxio-devel >= %{libxlsxio_version} -BuildRequires: zlib-devel +BuildRequires: make +BuildRequires: %{?scl_prefix}php-devel >= 7.0 Requires: %{?scl_prefix}php(zend-abi) = %{php_zend_api} Requires: %{?scl_prefix}php(api) = %{php_core_api} -Requires: %{?scl_prefix}php-json%{?_isa} -%{?_sclreq:Requires: %{?scl_prefix}runtime%{?_sclreq}%{?_isa}} -Requires: libxlsxwriter%{?_isa} >= %{libxlsxwriter_version} -Requires: libxlsxio%{?_isa} >= %{libxlsxio_version} - -Provides: %{?scl_prefix}php-%{pecl_name} = %{version} -Provides: %{?scl_prefix}php-%{pecl_name}%{?_isa} = %{version} -Provides: %{?scl_prefix}php-pecl(%{pecl_name}) = %{version} -Provides: %{?scl_prefix}php-pecl(%{pecl_name})%{?_isa} = %{version} -%if "%{?scl_prefix}" != "%{?sub_prefix}" -Provides: %{?scl_prefix}php-pecl-%{pecl_name} = %{version}-%{release} -Provides: %{?scl_prefix}php-pecl-%{pecl_name}%{?_isa} = %{version}-%{release} -%endif - -%if "%{?vendor}" == "Remi Collet" && 0%{!?scl:1} && 0%{?rhel} -%if "%{php_version}" > "7.1" -Obsoletes: php71u-pecl-%{pecl_name} <= %{version} -Obsoletes: php71w-pecl-%{pecl_name} <= %{version} -%endif -%if "%{php_version}" > "7.2" -Obsoletes: php72u-pecl-%{pecl_name} <= %{version} -Obsoletes: php72w-pecl-%{pecl_name} <= %{version} -%endif -%if "%{php_version}" > "7.3" -Obsoletes: php73-pecl-%{pecl_name} <= %{version} -Obsoletes: php73w-pecl-%{pecl_name} <= %{version} -%endif -%if "%{php_version}" > "7.4" -Obsoletes: php74-pecl-%{pecl_name} <= %{version} -Obsoletes: php74w-pecl-%{pecl_name} <= %{version} -%endif -%endif - -%if 0%{?fedora} < 20 && 0%{?rhel} < 7 -# Filter shared private -%{?filter_provides_in: %filter_provides_in %{_libdir}/.*\.so$} -%{?filter_setup} -%endif +# see library/libxlsxwriter/include/xlsxwriter.h +Provides: bundled(libxlsxwriter) = 1.1.6 +# self-maintained +Provides: bundled(libxlsreader) + +# Extension +Provides: %{?scl_prefix}php-%{pecl_name} = %{version} +Provides: %{?scl_prefix}php-%{pecl_name}%{?_isa} = %{version} +# PECL +Provides: %{?scl_prefix}php-pecl(%{pecl_name}) = %{version} +Provides: %{?scl_prefix}php-pecl(%{pecl_name})%{?_isa} = %{version} +# PIE +Provides: %{?scl_prefix}php-pie(%{pie_vend}/%{pie_proj}) = %{version} +Provides: %{?scl_prefix}php-%{pie_vend}-%{pie_proj} = %{version} %description -An efficient and fast xlsx file export extension for PHP. - -- Quickly export xlsx files in php projects. -- Export xlsx files under fixed memory. -- Insert a calculation formula in an xlsx file. -- Insert a local picture in an xlsx file. -- Merging cells and cell styles. +xlswriter is a PHP C Extension that can be used to write text, numbers, +formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file. + +Writer + +- 100% compatible Excel XLSX files. +- Full Excel formatting. +- Merged cells. +- Defined names. +- Autofilters. +- Charts. +- Data validation and drop down lists. +- Worksheet PNG/JPEG images. +- Memory optimization mode for writing large files. +- Works on Linux, FreeBSD, OpenBSD, OS X, Windows. +- Compiles for 32 and 64 bit. +- FreeBSD License. +- The only dependency is on zlib. + +Reader + +- Full read data +- Cursor read data +- Read by data type +- Xlsx to csv Package built for PHP %(%{__php} -r 'echo PHP_MAJOR_VERSION.".".PHP_MINOR_VERSION;')%{?scl: as Software Collection (%{scl} by %{?scl_vendor}%{!?scl_vendor:rh})}. %prep -%setup -q -c -mv %{pecl_name}-%{version} NTS - -# Don't install tests -sed -e 's/role="test"/role="src"/' \ - %{?_licensedir:-e '/LICENSE/s/role="doc"/role="src"/' } \ - -e '/name="library/d' \ - -i package.xml - -cd NTS -# we use the system libraries -rm -r library +%forgesetup # Sanity check, really often broken extver=$(sed -n '/#define PHP_XLSWRITER_VERSION/{s/.* "//;s/".*$//;p}' php_xlswriter.h) @@ -114,11 +96,11 @@ if test "x${extver}" != "x%{version}%{?prever:-%{prever}}"; then : Error: Upstream extension version is ${extver}, expecting %{version}%{?prever:-%{prever}}. exit 1 fi -cd .. +mkdir NTS %if %{with_zts} # Duplicate source tree for NTS / ZTS build -cp -pr NTS ZTS +mkdir ZTS %endif # Create configuration file @@ -133,112 +115,80 @@ EOF peclbuild() { %configure \ + --without-openssl \ --with-xlswriter \ - --with-libxlsxwriter=%{_prefix} \ - --with-libxlsxio=%{_prefix} \ --enable-reader \ --with-php-config=$1 -make %{?_smp_mflags} +%make_build } +%{__phpize} +[ -f Makefile.global ] && GLOBAL=Makefile.global || GLOBAL=build/Makefile.global +sed -e 's/INSTALL_ROOT/DESTDIR/' -i $GLOBAL + cd NTS -%{_bindir}/phpize -peclbuild %{_bindir}/php-config +peclbuild %{__phpconfig} %if %{with_zts} cd ../ZTS -%{_bindir}/zts-phpize -peclbuild %{_bindir}/zts-php-config +peclbuild %{__ztsphpconfig} %endif %install %{?dtsenable} -make -C NTS install INSTALL_ROOT=%{buildroot} +%make_install -C NTS # install config file install -D -m 644 %{ini_name} %{buildroot}%{php_inidir}/%{ini_name} -# Install XML package description -install -D -m 644 package.xml %{buildroot}%{pecl_xmldir}/%{name}.xml - %if %{with_zts} -make -C ZTS install INSTALL_ROOT=%{buildroot} +%make_install -C ZTS install -D -m 644 %{ini_name} %{buildroot}%{php_ztsinidir}/%{ini_name} %endif -# Documentation -for i in $(grep 'role="doc"' package.xml | sed -e 's/^.*name="//;s/".*$//') -do install -Dpm 644 NTS/$i %{buildroot}%{pecl_docdir}/%{pecl_name}/$i -done - - -%if 0%{?fedora} < 24 && 0%{?rhel} < 8 -# when pear installed alone, after us -%triggerin -- %{?scl_prefix}php-pear -if [ -x %{__pecl} ] ; then - %{pecl_install} %{pecl_xmldir}/%{name}.xml >/dev/null || : -fi - -# posttrans as pear can be installed after us -%posttrans -if [ -x %{__pecl} ] ; then - %{pecl_install} %{pecl_xmldir}/%{name}.xml >/dev/null || : -fi - -%postun -if [ $1 -eq 0 -a -x %{__pecl} ] ; then - %{pecl_uninstall} %{pecl_name} >/dev/null || : -fi -%endif - %check -modules="-d extension=json.so" +OPT="-q -P --show-diff" +%if "%{php_version}" > "7.4" +OPT="$OPT %{?_smp_mflags}" +%endif -cd NTS : Minimal load test for NTS extension %{__php} --no-php-ini \ - $modules \ --define extension=%{buildroot}%{php_extdir}/%{pecl_name}.so \ - --modules | grep %{pecl_name} + --modules | grep '^%{pecl_name}$' -%if %{with_tests} +%if %{with tests} : Upstream test suite for NTS extension -TEST_PHP_EXECUTABLE=%{__php} \ TEST_PHP_ARGS="-n -d extension=%{buildroot}%{php_extdir}/%{pecl_name}.so" \ -NO_INTERACTION=1 \ REPORT_EXIT_STATUS=1 \ -%{__php} -n run-tests.php --show-diff +%{__php} -n run-tests.php $OPT %endif %if %{with_zts} -cd ../ZTS : Minimal load test for ZTS extension %{__ztsphp} --no-php-ini \ - $modules \ --define extension=%{buildroot}%{php_ztsextdir}/%{pecl_name}.so \ - --modules | grep %{pecl_name} + --modules | grep '^%{pecl_name}$' -%if %{with_tests} +%if %{with tests} : Upstream test suite for ZTS extension -TEST_PHP_EXECUTABLE=%{_bindir}/zts-php \ TEST_PHP_ARGS="-n -d extension=%{buildroot}%{php_ztsextdir}/%{pecl_name}.so" \ -NO_INTERACTION=1 \ REPORT_EXIT_STATUS=1 \ -%{_bindir}/zts-php -n run-tests.php --show-diff +%{__ztsphp} -n run-tests.php $OPT %endif %endif cd .. %files -%{?_licensedir:%license NTS/LICENSE} -%doc %{pecl_docdir}/%{pecl_name} -%{pecl_xmldir}/%{name}.xml +%license LICENSE +%doc CREDITS +%doc *.md %config(noreplace) %{php_inidir}/%{ini_name} %{php_extdir}/%{pecl_name}.so @@ -250,6 +200,161 @@ cd .. %changelog +* Sun Jun 14 2026 Remi Collet <remi@remirepo.net> - 2.0.3-1 +- update to 2.0.3 + +* Wed Jun 3 2026 Remi Collet <remi@remirepo.net> - 2.0.2-1 +- update to 2.0.2 + +* Mon May 25 2026 Remi Collet <remi@remirepo.net> - 2.0.1-1 +- update to 2.0.1 + +* Mon May 18 2026 Remi Collet <remi@remirepo.net> - 2.0.0-2 +- test build with upstream patch + +* Mon May 18 2026 Remi Collet <remi@remirepo.net> - 2.0.0-1 +- update to 2.0.0 +- open https://github.com/viest/php-ext-xlswriter/issues/565 test failures with PHP 7.0 + +* Thu Apr 23 2026 Remi Collet <remi@remirepo.net> - 1.5.8-2 +- drop pear/pecl dependency +- sources from github + +* Tue Nov 12 2024 Remi Collet <remi@remirepo.net> - 1.5.8-1 +- update to 1.5.8 +- drop patch merged upstream +- open https://github.com/viest/php-ext-xlswriter/issues/537 BC break + +* Mon Sep 30 2024 Remi Collet <remi@remirepo.net> - 1.5.7-3 +- fix test suite using patch from + https://github.com/viest/php-ext-xlswriter/pull/531 + +* Tue Sep 24 2024 Remi Collet <remi@remirepo.net> - 1.5.7-2 +- rebuild for 8.4.0RC1 + +* Wed Sep 4 2024 Remi Collet <remi@remirepo.net> - 1.5.7-1 +- update to 1.5.7 + +* Wed Aug 28 2024 Remi Collet <remi@remirepo.net> - 1.5.6-1 +- update to 1.5.6 + +* Wed Aug 30 2023 Remi Collet <remi@remirepo.net> - 1.5.5-2 +- rebuild for PHP 8.3.0RC1 + +* Tue May 16 2023 Remi Collet <remi@remirepo.net> - 1.5.5-1 +- update to 1.5.5 +- build out of sources tree + +* Thu Mar 2 2023 Remi Collet <remi@remirepo.net> - 1.5.4-1 +- update to 1.5.4 +- drop patch merged upstream + +* Wed Mar 1 2023 Remi Collet <remi@remirepo.net> - 1.5.3-1 +- update to 1.5.3 +- drop patch merged upstream +- add another patch for PHP 8.2 from + https://github.com/viest/php-ext-xlswriter/pull/470 + +* Fri Sep 16 2022 Remi Collet <remi@remirepo.net> - 1.5.2-2 +- add patch for PHP 8.2 from + https://github.com/viest/php-ext-xlswriter/pull/451 + +* Thu Apr 28 2022 Remi Collet <remi@remirepo.net> - 1.5.2-1 +- update to 1.5.2 + +* Tue Oct 26 2021 Remi Collet <remi@remirepo.net> - 1.5.1-1 +- update to 1.5.1 + +* Thu Oct 7 2021 Remi Collet <remi@remirepo.net> - 1.5.0-1 +- update to 1.5.0 + +* Wed Sep 01 2021 Remi Collet <remi@remirepo.net> - 1.4.0-2 +- rebuild for 8.1.0RC1 + +* Mon Jul 19 2021 Remi Collet <remi@remirepo.net> - 1.4.0-1 +- update to 1.4.0 + +* Sat Jan 2 2021 Remi Collet <remi@remirepo.net> - 1.3.7-1 +- update to 1.3.7 +- drop patch merged upstream + +* Wed Sep 30 2020 Remi Collet <remi@remirepo.net> - 1.3.6-9 +- rebuild using bundled libraries + +* Wed Sep 30 2020 Remi Collet <remi@remirepo.net> - 1.3.6-8 +- rebuild for PHP 8.0.0RC1 + +* Tue Sep 8 2020 Remi Collet <remi@remirepo.net> - 1.3.6-7 +- build using libxlsxwriter version 1.0.0 + +* Wed Sep 2 2020 Remi Collet <remi@remirepo.net> - 1.3.6-6 +- add patch for PHP 8.0.0beta3 from + https://github.com/viest/php-ext-xlswriter/pull/298 + +* Tue Aug 18 2020 Remi Collet <remi@remirepo.net> - 1.3.6-5 +- build using libxlsxwriter version 0.9.9 + +* Tue Aug 11 2020 Remi Collet <remi@remirepo.net> - 1.3.6-4 +- build using libxlsxwriter version 0.9.8 + +* Fri Aug 7 2020 Remi Collet <remi@remirepo.net> - 1.3.6-3 +- build using libxlsxwriter version 0.9.7 + +* Wed Aug 5 2020 Remi Collet <remi@remirepo.net> - 1.3.6-2 +- rebuild for 8.0.0beta1 + +* Wed Jun 17 2020 Remi Collet <remi@remirepo.net> - 1.3.6-1 +- update to 1.3.6 + +* Mon Jun 1 2020 Remi Collet <remi@remirepo.net> - 1.3.5-2 +- build using libxlsxwriter version 0.9.5 + +* Tue May 26 2020 Remi Collet <remi@remirepo.net> - 1.3.5-1 +- update to 1.3.5 +- drop patch merged upstream + +* Mon Apr 13 2020 Remi Collet <remi@remirepo.net> - 1.3.4.1-1 +- update to 1.3.4.1 + +* Tue Mar 24 2020 Remi Collet <remi@remirepo.net> - 1.3.4-2 +- rebuild using libxlsxio version 0.2.26 + +* Thu Mar 19 2020 Remi Collet <remi@remirepo.net> - 1.3.4-1 +- update to 1.3.4 +- build using libxlsxwriter version 0.9.4 +- build using libxlsxio version 0.2.24-2 + +* Tue Jan 14 2020 Remi Collet <remi@remirepo.net> - 1.3.3.2-2 +- rebuild with libxlsxwriter 0.9.3 +- add patch from https://github.com/viest/php-ext-xlswriter/pull/226 + +* Wed Jan 1 2020 Remi Collet <remi@remirepo.net> - 1.3.3.2-1 +- update to 1.3.3.2 + +* Tue Dec 31 2019 Remi Collet <remi@remirepo.net> - 1.3.3.1-2 +- rebuild with libxlsxwriter 0.9.1 + +* Fri Dec 27 2019 Remi Collet <remi@remirepo.net> - 1.3.3.1-1 +- update to 1.3.3.1 + +* Thu Dec 26 2019 Remi Collet <remi@remirepo.net> - 1.3.3-2 +- update to 1.3.3 + +* Wed Dec 18 2019 Remi Collet <remi@remirepo.net> - 1.3.2-2 +- rebuild with libxlsxwriter 0.8.9 + +* Thu Nov 21 2019 Remi Collet <remi@remirepo.net> - 1.3.2-1 +- update to 1.3.2 +- drop patch merged upstream + +* Mon Nov 18 2019 Remi Collet <remi@remirepo.net> - 1.3.1-2 +- rebuild with libxlsxwriter 0.8.8 +- open https://github.com/viest/php-ext-excel-export/pull/199 + fix compatibility with 0.8.8 + +* Sat Oct 12 2019 Remi Collet <remi@remirepo.net> - 1.3.1-1 +- update to 1.3.1 + * Wed Sep 25 2019 Remi Collet <remi@remirepo.net> - 1.3.0-1 - update to 1.3.0 |