aspose.cells

Class Line

Encapsulates the object that represents the line format.

Example:

$workbook = new cells\Workbook();
$cells = $workbook->getWorksheets()->get(0)->getCells();
$cells->get("a1")->putValue(2);
$cells->get("a2")->putValue(5);
$cells->get("a3")->putValue(3);
$cells->get("a4")->putValue(6);
$cells->get("b1")->putValue(4);
$cells->get("b2")->putValue(3);
$cells->get("b3")->putValue(6);
$cells->get("b4")->putValue(7);
$chartIndex = $workbook->getWorksheets()->get(0)->getCharts()->add(cells\ChartType::COLUMN, 11, 0, 27, 10);
$chart = $workbook->getWorksheets()->get(0)->getCharts()->get($chartIndex);
$chart->getNSeries()->add("A1:B4", true);
//Applying a dotted line style on the lines of an NSeries
$series = $chart->getNSeries()->get(0);
$series->getBorder()->setColor(cells\Color::getRed());
$series->getBorder()->setStyle(cells\LineType::DOT);
//Applying a triangular marker style on the data markers of an NSeries
$series->setMarkerStyle(cells\ChartMarkerType::TRIANGLE);
$series = $chart->getNSeries()->get(1);
//Setting the weight of all lines in an NSeries to medium
$series->getBorder()->setWeight(cells\WeightType::MEDIUM_LINE);
$series->getBorder()->setColor(cells\Color::getGreen());

Property Getters/Setters Summary
functiongetBeginArrowLength()
function
           Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant.
functiongetBeginArrowWidth()
function
           Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant.
functiongetBeginType()
function
           Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant.
functiongetCapType()
function
setCapType(value)
           Specifies the ending caps. The value of the property is LineCapType integer constant.
functiongetColor()
function
setColor(value)
           Represents the com.aspose.cells.Color of the line.
functiongetCompoundType()
function
           Specifies the compound line type The value of the property is MsoLineStyle integer constant.
functiongetDashType()
function
           Specifies the dash line type The value of the property is MsoLineDashStyle integer constant.
functiongetEndArrowLength()
function
           Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant.
functiongetEndArrowWidth()
function
           Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant.
functiongetEndType()
function
setEndType(value)
           Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.
functiongetFormattingType()
function
           Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.
functiongetGradientFill()
Represents gradient fill.
functionisAuto()
function
setAuto(value)
           Indicates whether this line style is auto assigned.
functionisAutomaticColor()
Indicates whether the color of line is auotmatic assigned.
functionisVisible()
function
setVisible(value)
           Represents whether the line is visible.
functiongetJoinType()
function
           Specifies the joining caps. The value of the property is LineJoinType integer constant.
functiongetStyle()
function
setStyle(value)
           Represents the style of the line. The value of the property is LineType integer constant.
functiongetThemeColor()
function
           Gets and sets the theme color.
functiongetTransparency()
function
           Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).
functiongetWeight()
function
setWeight(value)
           Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.
functiongetWeightPt()
function
           Gets or sets the weight of the line in unit of points.
functiongetWeightPx()
function
           Gets or sets the weight of the line in uni of pixels.
 

    • Property Getters/Setters Detail

      • getCompoundType/setCompoundType : Number 

        function getCompoundType() / function setCompoundType(value)
        
        Specifies the compound line type The value of the property is MsoLineStyle integer constant.
      • getDashType/setDashType : Number 

        function getDashType() / function setDashType(value)
        
        Specifies the dash line type The value of the property is MsoLineDashStyle integer constant.
      • getCapType/setCapType : Number 

        function getCapType() / function setCapType(value)
        
        Specifies the ending caps. The value of the property is LineCapType integer constant.
      • getJoinType/setJoinType : Number 

        function getJoinType() / function setJoinType(value)
        
        Specifies the joining caps. The value of the property is LineJoinType integer constant.
      • getBeginType/setBeginType : Number 

        function getBeginType() / function setBeginType(value)
        
        Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant.
      • getEndType/setEndType : Number 

        function getEndType() / function setEndType(value)
        
        Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.
      • getBeginArrowLength/setBeginArrowLength : Number 

        function getBeginArrowLength() / function setBeginArrowLength(value)
        
        Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant.
      • getEndArrowLength/setEndArrowLength : Number 

        function getEndArrowLength() / function setEndArrowLength(value)
        
        Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant.
      • getBeginArrowWidth/setBeginArrowWidth : Number 

        function getBeginArrowWidth() / function setBeginArrowWidth(value)
        
        Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant.
      • getEndArrowWidth/setEndArrowWidth : Number 

        function getEndArrowWidth() / function setEndArrowWidth(value)
        
        Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant.
      • getThemeColor/setThemeColor : ThemeColor 

        function getThemeColor() / function setThemeColor(value)
        
        Gets and sets the theme color. If the forground color is not a theme color, NULL will be returned.
      • getColor/setColor : Color 

        function getColor() / function setColor(value)
        
        Represents the com.aspose.cells.Color of the line.
      • getTransparency/setTransparency : Number 

        function getTransparency() / function setTransparency(value)
        
        Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).
      • getStyle/setStyle : Number 

        function getStyle() / function setStyle(value)
        
        Represents the style of the line. The value of the property is LineType integer constant.
      • getWeight/setWeight : Number 

        function getWeight() / function setWeight(value)
        
        Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.
      • getWeightPt/setWeightPt : Number 

        function getWeightPt() / function setWeightPt(value)
        
        Gets or sets the weight of the line in unit of points.
      • getWeightPx/setWeightPx : Number 

        function getWeightPx() / function setWeightPx(value)
        
        Gets or sets the weight of the line in uni of pixels.
      • getFormattingType/setFormattingType : Number 

        function getFormattingType() / function setFormattingType(value)
        
        Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.
      • isAutomaticColor : boolean 

        function isAutomaticColor()
        
        Indicates whether the color of line is auotmatic assigned.
      • isVisible/setVisible : boolean 

        function isVisible() / function setVisible(value)
        
        Represents whether the line is visible.
      • isAuto/setAuto : boolean 

        function isAuto() / function setAuto(value)
        
        Indicates whether this line style is auto assigned.
      • getGradientFill : GradientFill 

        function getGradientFill()
        
        Represents gradient fill.