Gitee
\
app
admin
controller
model
validate
base
controller
chengji
controller
model
validate
event
facade
index
controller
kaohao
controller
model
validate
Kaoshi
controller
model
kaoshi
controller
model
validate
keti
controller
model
validate
Keti
model
listener
login
controller
validate
luru
controller
middleware
rongyu
controller
model
validate
student
controller
model
validate
studentSearchChengji
controller
system
controller
model
validate
teach
controller
model
validate
teacher
controller
model
validate
teacherSearchChengji
controller
tools
controller
model
zhengli
controller
Complex
Composer
Autoload
League
Flysystem
Adapter
Polyfill
Cached
Storage
Plugin
Util
liliuwei
think
Matrix
Operators
Opis
Closure
Overtrue
Pinyin
Phinx
Db
Adapter
Table
Migration
Seed
Util
PhpOffice
PhpSpreadsheet
Calculation
Engine
Token
Cell
Chart
Renderer
Collection
Document
Helper
Reader
Ods
Security
Xls
Color
Style
Xlsx
RichText
Shared
Escher
DgContainer
SpgrContainer
DggContainer
BstoreContainer
BSE
JAMA
OLE
PPS
Trend
Style
Worksheet
AutoFilter
Column
Drawing
Writer
Ods
Cell
Pdf
Xls
Xlsx
Psr
Cache
Container
Log
Test
SimpleCache
Samples
Sample09
Sample10
Sample12
Sample14
spec
League
Flysystem
Cached
Symfony
Component
VarDumper
Caster
Cloner
Command
Descriptor
Dumper
Exception
Server
Test
Polyfill
Mbstring
Php72
think
app
command
cache
driver
captcha
facade
console
command
make
optimize
input
output
descriptor
driver
formatter
question
contract
db
concern
connector
exception
event
exception
facade
file
filesystem
driver
helper
initializer
log
driver
middleware
migration
command
factory
migrate
seed
db
model
concern
relation
paginator
driver
response
route
dispatch
service
session
driver
template
driver
exception
taglib
tests
trace
validate
view
driver
WhiteHat101
Crypt

\PhpOffice\PhpSpreadsheet\SharedFont

Summary

Methods
Properties
Constants
setAutoSizeMethod()
getAutoSizeMethod()
setTrueTypeFontPath()
getTrueTypeFontPath()
calculateColumnWidth()
getTextWidthPixelsExact()
getTextWidthPixelsApprox()
fontSizeToPixels()
inchSizeToPixels()
centimeterSizeToPixels()
getTrueTypeFontFileFromFont()
getCharsetFromFontName()
getDefaultColumnWidthByFont()
getDefaultRowHeightByFont()
$defaultColumnWidths
AUTOSIZE_METHOD_APPROX
AUTOSIZE_METHOD_EXACT
CHARSET_ANSI_LATIN
CHARSET_SYSTEM_DEFAULT
CHARSET_SYMBOL
CHARSET_APPLE_ROMAN
CHARSET_ANSI_JAPANESE_SHIFTJIS
CHARSET_ANSI_KOREAN_HANGUL
CHARSET_ANSI_KOREAN_JOHAB
CHARSET_ANSI_CHINESE_SIMIPLIFIED
CHARSET_ANSI_CHINESE_TRADITIONAL
CHARSET_ANSI_GREEK
CHARSET_ANSI_TURKISH
CHARSET_ANSI_VIETNAMESE
CHARSET_ANSI_HEBREW
CHARSET_ANSI_ARABIC
CHARSET_ANSI_BALTIC
CHARSET_ANSI_CYRILLIC
CHARSET_ANSI_THAI
CHARSET_ANSI_LATIN_II
CHARSET_OEM_LATIN_I
ARIAL
ARIAL_BOLD
ARIAL_ITALIC
ARIAL_BOLD_ITALIC
CALIBRI
CALIBRI_BOLD
CALIBRI_ITALIC
CALIBRI_BOLD_ITALIC
COMIC_SANS_MS
COMIC_SANS_MS_BOLD
COURIER_NEW
COURIER_NEW_BOLD
COURIER_NEW_ITALIC
COURIER_NEW_BOLD_ITALIC
GEORGIA
GEORGIA_BOLD
GEORGIA_ITALIC
GEORGIA_BOLD_ITALIC
IMPACT
LIBERATION_SANS
LIBERATION_SANS_BOLD
LIBERATION_SANS_ITALIC
LIBERATION_SANS_BOLD_ITALIC
LUCIDA_CONSOLE
LUCIDA_SANS_UNICODE
MICROSOFT_SANS_SERIF
PALATINO_LINOTYPE
PALATINO_LINOTYPE_BOLD
PALATINO_LINOTYPE_ITALIC
PALATINO_LINOTYPE_BOLD_ITALIC
SYMBOL
TAHOMA
TAHOMA_BOLD
TIMES_NEW_ROMAN
TIMES_NEW_ROMAN_BOLD
TIMES_NEW_ROMAN_ITALIC
TIMES_NEW_ROMAN_BOLD_ITALIC
TREBUCHET_MS
TREBUCHET_MS_BOLD
TREBUCHET_MS_ITALIC
TREBUCHET_MS_BOLD_ITALIC
VERDANA
VERDANA_BOLD
VERDANA_ITALIC
VERDANA_BOLD_ITALIC
No protected methods found
No protected properties found
N/A
No private methods found
$autoSizeMethods
$autoSizeMethod
$trueTypeFontPath
N/A

Constants

AUTOSIZE_METHOD_APPROX

AUTOSIZE_METHOD_APPROX = 'approx'

AUTOSIZE_METHOD_EXACT

AUTOSIZE_METHOD_EXACT = 'exact'

CHARSET_ANSI_LATIN

CHARSET_ANSI_LATIN = 0

Character set codes used by BIFF5-8 in Font records

CHARSET_SYSTEM_DEFAULT

CHARSET_SYSTEM_DEFAULT = 1

CHARSET_SYMBOL

CHARSET_SYMBOL = 2

CHARSET_APPLE_ROMAN

CHARSET_APPLE_ROMAN = 77

CHARSET_ANSI_JAPANESE_SHIFTJIS

CHARSET_ANSI_JAPANESE_SHIFTJIS = 128

CHARSET_ANSI_KOREAN_HANGUL

CHARSET_ANSI_KOREAN_HANGUL = 129

CHARSET_ANSI_KOREAN_JOHAB

CHARSET_ANSI_KOREAN_JOHAB = 130

CHARSET_ANSI_CHINESE_SIMIPLIFIED

CHARSET_ANSI_CHINESE_SIMIPLIFIED = 134

CHARSET_ANSI_CHINESE_TRADITIONAL

CHARSET_ANSI_CHINESE_TRADITIONAL = 136

CHARSET_ANSI_GREEK

CHARSET_ANSI_GREEK = 161

CHARSET_ANSI_TURKISH

CHARSET_ANSI_TURKISH = 162

CHARSET_ANSI_VIETNAMESE

CHARSET_ANSI_VIETNAMESE = 163

CHARSET_ANSI_HEBREW

CHARSET_ANSI_HEBREW = 177

CHARSET_ANSI_ARABIC

CHARSET_ANSI_ARABIC = 178

CHARSET_ANSI_BALTIC

CHARSET_ANSI_BALTIC = 186

CHARSET_ANSI_CYRILLIC

CHARSET_ANSI_CYRILLIC = 204

CHARSET_ANSI_THAI

CHARSET_ANSI_THAI = 221

CHARSET_ANSI_LATIN_II

CHARSET_ANSI_LATIN_II = 238

CHARSET_OEM_LATIN_I

CHARSET_OEM_LATIN_I = 255

ARIAL

ARIAL = 'arial.ttf'

Font filenames

ARIAL_BOLD

ARIAL_BOLD = 'arialbd.ttf'

ARIAL_ITALIC

ARIAL_ITALIC = 'ariali.ttf'

ARIAL_BOLD_ITALIC

ARIAL_BOLD_ITALIC = 'arialbi.ttf'

CALIBRI

CALIBRI = 'CALIBRI.TTF'

CALIBRI_BOLD

CALIBRI_BOLD = 'CALIBRIB.TTF'

CALIBRI_ITALIC

CALIBRI_ITALIC = 'CALIBRII.TTF'

CALIBRI_BOLD_ITALIC

CALIBRI_BOLD_ITALIC = 'CALIBRIZ.TTF'

COMIC_SANS_MS

COMIC_SANS_MS = 'comic.ttf'

COMIC_SANS_MS_BOLD

COMIC_SANS_MS_BOLD = 'comicbd.ttf'

COURIER_NEW

COURIER_NEW = 'cour.ttf'

COURIER_NEW_BOLD

COURIER_NEW_BOLD = 'courbd.ttf'

COURIER_NEW_ITALIC

COURIER_NEW_ITALIC = 'couri.ttf'

COURIER_NEW_BOLD_ITALIC

COURIER_NEW_BOLD_ITALIC = 'courbi.ttf'

GEORGIA

GEORGIA = 'georgia.ttf'

GEORGIA_BOLD

GEORGIA_BOLD = 'georgiab.ttf'

GEORGIA_ITALIC

GEORGIA_ITALIC = 'georgiai.ttf'

GEORGIA_BOLD_ITALIC

GEORGIA_BOLD_ITALIC = 'georgiaz.ttf'

IMPACT

IMPACT = 'impact.ttf'

LIBERATION_SANS

LIBERATION_SANS = 'LiberationSans-Regular.ttf'

LIBERATION_SANS_BOLD

LIBERATION_SANS_BOLD = 'LiberationSans-Bold.ttf'

LIBERATION_SANS_ITALIC

LIBERATION_SANS_ITALIC = 'LiberationSans-Italic.ttf'

LIBERATION_SANS_BOLD_ITALIC

LIBERATION_SANS_BOLD_ITALIC = 'LiberationSans-BoldItalic.ttf'

LUCIDA_CONSOLE

LUCIDA_CONSOLE = 'lucon.ttf'

LUCIDA_SANS_UNICODE

LUCIDA_SANS_UNICODE = 'l_10646.ttf'

MICROSOFT_SANS_SERIF

MICROSOFT_SANS_SERIF = 'micross.ttf'

PALATINO_LINOTYPE

PALATINO_LINOTYPE = 'pala.ttf'

PALATINO_LINOTYPE_BOLD

PALATINO_LINOTYPE_BOLD = 'palab.ttf'

PALATINO_LINOTYPE_ITALIC

PALATINO_LINOTYPE_ITALIC = 'palai.ttf'

PALATINO_LINOTYPE_BOLD_ITALIC

PALATINO_LINOTYPE_BOLD_ITALIC = 'palabi.ttf'

SYMBOL

SYMBOL = 'symbol.ttf'

TAHOMA

TAHOMA = 'tahoma.ttf'

TAHOMA_BOLD

TAHOMA_BOLD = 'tahomabd.ttf'

TIMES_NEW_ROMAN

TIMES_NEW_ROMAN = 'times.ttf'

TIMES_NEW_ROMAN_BOLD

TIMES_NEW_ROMAN_BOLD = 'timesbd.ttf'

TIMES_NEW_ROMAN_ITALIC

TIMES_NEW_ROMAN_ITALIC = 'timesi.ttf'

TIMES_NEW_ROMAN_BOLD_ITALIC

TIMES_NEW_ROMAN_BOLD_ITALIC = 'timesbi.ttf'

TREBUCHET_MS

TREBUCHET_MS = 'trebuc.ttf'

TREBUCHET_MS_BOLD

TREBUCHET_MS_BOLD = 'trebucbd.ttf'

TREBUCHET_MS_ITALIC

TREBUCHET_MS_ITALIC = 'trebucit.ttf'

TREBUCHET_MS_BOLD_ITALIC

TREBUCHET_MS_BOLD_ITALIC = 'trebucbi.ttf'

VERDANA

VERDANA = 'verdana.ttf'

VERDANA_BOLD

VERDANA_BOLD = 'verdanab.ttf'

VERDANA_ITALIC

VERDANA_ITALIC = 'verdanai.ttf'

VERDANA_BOLD_ITALIC

VERDANA_BOLD_ITALIC = 'verdanaz.ttf'

Properties

$defaultColumnWidths

$defaultColumnWidths : array

How wide is a default column for a given default font and size? Empirical data found by inspecting real Excel files and reading off the pixel width in Microsoft Office Excel 2007.

Type

array

$autoSizeMethods

$autoSizeMethods :

Type

$autoSizeMethod

$autoSizeMethod : string

AutoSize method.

Type

string

$trueTypeFontPath

$trueTypeFontPath : string

Path to folder containing TrueType font .ttf files.

Type

string

Methods

setAutoSizeMethod()

setAutoSizeMethod(string  $pValue) : boolean

Set autoSize method.

Parameters

string $pValue

see self::AUTOSIZEMETHOD*

Returns

boolean —

Success or failure

getAutoSizeMethod()

getAutoSizeMethod() : string

Get autoSize method.

Returns

string

setTrueTypeFontPath()

setTrueTypeFontPath(string  $pValue)

Set the path to the folder containing .ttf files. There should be a trailing slash.

Typical locations on variout some platforms:

  • C:/Windows/Fonts/
  • /usr/share/fonts/truetype/
  • ~/.fonts/
.

Parameters

string $pValue

getTrueTypeFontPath()

getTrueTypeFontPath() : string

Get the path to the folder containing .ttf files.

Returns

string

calculateColumnWidth()

calculateColumnWidth(\PhpOffice\PhpSpreadsheet\Style\Font  $font, \PhpOffice\PhpSpreadsheet\RichText\RichText|string  $cellText = '', integer  $rotation, null|\PhpOffice\PhpSpreadsheet\Style\Font  $defaultFont = null) : integer

Calculate an (approximate) OpenXML column width, based on font size and text contained.

Parameters

\PhpOffice\PhpSpreadsheet\Style\Font $font

Font object
\PhpOffice\PhpSpreadsheet\RichText\RichText|string $cellText

Text to calculate width
integer $rotation

Rotation angle
null|\PhpOffice\PhpSpreadsheet\Style\Font $defaultFont

Font object

Returns

integer —

Column width

getTextWidthPixelsExact()

getTextWidthPixelsExact(string  $text, \PhpOffice\PhpSpreadsheet\Style\Font  $font, integer  $rotation) : integer

Get GD text width in pixels for a string of text in a certain font at a certain rotation angle.

Parameters

string $text
\PhpOffice\PhpSpreadsheet\Style\Font $font
integer $rotation

Throws

\PhpOffice\PhpSpreadsheet\Exception

Returns

integer

getTextWidthPixelsApprox()

getTextWidthPixelsApprox(string  $columnText, \PhpOffice\PhpSpreadsheet\Style\Font  $font, integer  $rotation) : integer

Get approximate width in pixels for a string of text in a certain font at a certain rotation angle.

Parameters

string $columnText
\PhpOffice\PhpSpreadsheet\Style\Font $font
integer $rotation

Returns

integer —

Text width in pixels (no padding added)

fontSizeToPixels()

fontSizeToPixels(integer  $fontSizeInPoints) : integer

Calculate an (approximate) pixel size, based on a font points size.

Parameters

integer $fontSizeInPoints

Font size (in points)

Returns

integer —

Font size (in pixels)

inchSizeToPixels()

inchSizeToPixels(integer  $sizeInInch) : integer

Calculate an (approximate) pixel size, based on inch size.

Parameters

integer $sizeInInch

Font size (in inch)

Returns

integer —

Size (in pixels)

centimeterSizeToPixels()

centimeterSizeToPixels(integer  $sizeInCm) : float

Calculate an (approximate) pixel size, based on centimeter size.

Parameters

integer $sizeInCm

Font size (in centimeters)

Returns

float —

Size (in pixels)

getTrueTypeFontFileFromFont()

getTrueTypeFontFileFromFont(\PhpOffice\PhpSpreadsheet\Style\Font  $font) : string

Returns the font path given the font.

Parameters

\PhpOffice\PhpSpreadsheet\Style\Font $font

Returns

string —

Path to TrueType font file

getCharsetFromFontName()

getCharsetFromFontName(string  $name) : integer

Returns the associated charset for the font name.

Parameters

string $name

Font name

Returns

integer —

Character set code

getDefaultColumnWidthByFont()

getDefaultColumnWidthByFont(\PhpOffice\PhpSpreadsheet\Style\Font  $font, boolean  $pPixels = false) : mixed

Get the effective column width for columns without a column dimension or column with width -1 For example, for Calibri 11 this is 9.140625 (64 px).

Parameters

\PhpOffice\PhpSpreadsheet\Style\Font $font

The workbooks default font
boolean $pPixels

true = return column width in pixels, false = return in OOXML units

Returns

mixed —

Column width

getDefaultRowHeightByFont()

getDefaultRowHeightByFont(\PhpOffice\PhpSpreadsheet\Style\Font  $font) : float

Get the effective row height for rows without a row dimension or rows with height -1 For example, for Calibri 11 this is 15 points.

Parameters

\PhpOffice\PhpSpreadsheet\Style\Font $font

The workbooks default font

Returns

float —

Row height in points