Prev BackgroundColor	ExcelExplorer Manual	Next EEFont class

(ExcelExplorer 4.0)

Get borders styles and colors.

false EEBorders Borders(  )

None

Returns EEBorders object containing info about borders styles and colors used.

This method returns FALSE if file have been explored with option read_border set to FALSE. So before using any methods of EEBorders object you should always check if this function returns valid object.

Print cell's top border style

<?php



$borders = $ee->Cell($sheet,$col,$row)->Style()->Borders();

if( $borders ) {



  echo 'Top border style: ';



  switch( $borders->Top()->Style() ) {

    case EE_BORDER_NONE:

      echo 'EE_BORDER_NONE';

      break;

    case EE_BORDER_HAIR:

      echo 'EE_BORDER_HAIR';

      break;

    case EE_BORDER_DOTTED:

      echo 'EE_BORDER_DOTTED';

      break;

    case EE_BORDER_DASHDOTDOTTED:

      echo 'EE_BORDER_DASHDOTDOTTED';

      break;

    case EE_BORDER_DASHDOTTED:

      echo 'EE_BORDER_DASHDOTTED';

      break;

    case EE_BORDER_DASHED:

      echo 'EE_BORDER_DASHED';

      break;

    case EE_BORDER_THIN:

      echo 'EE_BORDER_THIN';

      break;

    case EE_BORDER_MEDIUM_DASHDOTDOTTED:

      echo 'EE_BORDER_MEDIUM_DASHDOTDOTTED';

      break;

    case EE_BORDER_SLANTED_MEDIUM_DASHDOTTED:

      echo 'EE_BORDER_SLANTED_MEDIUM_DASHDOTTED';

      break;

    case EE_BORDER_MEDIUM_DASHDOTTED:

      echo 'EE_BORDER_MEDIUM_DASHDOTTED';

      break;

    case EE_BORDER_MEDIUM_DASHED:

      echo 'EE_BORDER_MEDIUM_DASHED';

      break;

    case EE_BORDER_MEDIUM:

      echo 'EE_BORDER_MEDIUM';

      break;

    case EE_BORDER_THICK:

      echo 'EE_BORDER_THICK';

      break;

    case EE_BORDER_DOUBLE:

      echo 'EE_BORDER_DOUBLE';

      break;

    default:

      echo 'Unknown';

      break;

  }



}



?>

Prev BackgroundColor	Home Up	Next EEFont class