Рекурсивный акроним словосочетания «PHP: Hypertext Preprocessor»
Добро пожаловать на форум PHP программистов!
За последние 24 часа нас посетили 69672 программиста и 3582 робота. Сейчас ищут 2727 программистов ...
Spreadsheet_Excel_Writer
Вернуться к: Форматы файлов
Package for generating Excel spreadsheets
- Introduction — how to generate Excel files
- Formatting Tutorial — how to format cells in a spreadsheet
- Workbook::close — Calls finalization methods for the workbook
- Workbook::&addWorksheet — Add a new worksheet to the Excel workbook.
- Workbook::&addFormat — Add a new format to the Excel workbook.
- Workbook::setCountry — Set the country identifier for the workbook
- Workbook::&setTempDir — Sets the temp dir used for storing the OLE file.
- Workbook::setVersion — Sets the BIFF version.
- Workbook::setCustomColor — Change the RGB components of the elements in the colour palette.
- Workbook::worksheets — An accessor for the _worksheets[] array.
- Worksheet::getName — Retrieve the worksheet name. This is usefull when creating worksheets
- Worksheet::setInputEncoding — Allow writing for different charsets.
- Worksheet::select — Set this worksheet as a selected worksheet, i.e. the worksheet has its tab
- Worksheet::activate — Set this worksheet as the active worksheet, i.e. the worksheet that is
- Worksheet::setFirstSheet — Set this worksheet as the first visible sheet. This is necessary
- Worksheet::protect — Set the worksheet protection flag
- Worksheet::setColumn — Set the width of a single column or a range of columns.
- Worksheet::writeCol — Write an array of values as a column
- Worksheet::writeRow — Write an array of values as a row
- Worksheet::setSelection — Set which cell or cells are selected in a worksheet
- Worksheet::freezePanes — Set panes and mark them as frozen.
- Worksheet::thawPanes — Set panes and mark them as unfrozen.
- Worksheet::hideScreenGridlines — Set the option to hide gridlines on the worksheet (as seen on the screen).
- Worksheet::setPortrait — Set the page orientation as portrait.
- Worksheet::setLandscape — Set the page orientation as landscape.
- Worksheet::setPaper — Set the paper type. Ex. 1 = US Letter, 9 = A4
- Worksheet::setHeader — Set the page header caption and optional margin.
- Worksheet::setFooter — Set the page footer caption and optional margin.
- Worksheet::setMerge — Sets a merged cell range
- Worksheet::centerHorizontally — Center the page horizontally.
- Worksheet::centerVertically — Center the page vertically.
- Worksheet::setMargins — Set all the page margins to the same value in inches.
- Worksheet::setMargins_LR — Set the left and right margins to the same value in inches.
- Worksheet::setMargins_TB — Set the top and bottom margins to the same value in inches.
- Worksheet::setMarginLeft — Set the left margin in inches.
- Worksheet::setMarginRight — Set the right margin in inches.
- Worksheet::setMarginTop — Set the top margin in inches.
- Worksheet::setMarginBottom — Set the bottom margin in inches.
- Worksheet::repeatRows — Set the rows to repeat at the top of each printed page.
- Worksheet::repeatColumns — Set the columns to repeat at the left hand side of each printed page.
- Worksheet::printArea — Set the area of each worksheet that will be printed.
- Worksheet::hideGridlines — Set the option to hide gridlines on the printed page.
- Worksheet::printRowColHeaders — Set the option to print the row and column headers on the printed page.
- Worksheet::fitToPages — Store the vertical and horizontal number of pages that will define the
- Worksheet::setHPagebreaks — Store the horizontal page breaks on a worksheet (for printing).
- Worksheet::setVPagebreaks — Store the vertical page breaks on a worksheet (for printing).
- Worksheet::setZoom — Set the worksheet zoom factor.
- Worksheet::setPrintScale — Set the scale factor for the printed page.
- Worksheet::write — Map to the appropriate write method acording to the token recieved.
- Worksheet::writeNumber — Write a double to the specified row and column (zero indexed).
- Worksheet::writeString — Write a string to the specified row and column (zero indexed).
- Worksheet::writeNote — Writes a note associated with the cell given by the row and column.
- Worksheet::writeBlank — Write a blank cell to the specified row and column (zero indexed).
- Worksheet::writeFormula — Write a formula to the specified row and column (zero indexed).
- Worksheet::writeUrl — Write a hyperlink. This is comprised of two elements: the visible label and
- Worksheet::setRow — This method is used to set the height and XF format for a row.
- Worksheet::mergeCells — This is an Excel97/2000 method. It is required to perform more complicated
- Worksheet::insertBitmap — Insert a 24bit bitmap image in a worksheet. The main record required is
- Worksheet::setOutline — This method sets the properties for outlining and grouping
- Spreadsheet_Excel_Writer::Spreadsheet_Excel_Writer — The constructor. It just creates a Workbook
- Spreadsheet_Excel_Writer::send — Send HTTP headers for the Excel file.
- Spreadsheet_Excel_Writer::rowcolToCell — Utility function for writing formulas.
- Format::setAlign — Set cell alignment.
- Format::setVAlign — Set cell alignment.
- Format::setHAlign — Set cell alignment.
- Format::setMerge — This is an alias for the unintuitive setAlign('merge')
- Format::setLocked — Locks a cell.
- Format::setUnLocked — Unlocks a cell. Useful for unprotecting particular cells of a protected sheet.
- Format::setBold — Sets the boldness of the text.
- Format::setBottom — Sets the width for the bottom border of the cell
- Format::setTop — Sets the width for the top border of the cell
- Format::setLeft — Sets the width for the left border of the cell
- Format::setRight — Sets the width for the right border of the cell
- Format::setBorder — Set cells borders to the same style
- Format::setBorderColor — Sets all the cell's borders to the same color
- Format::setBottomColor — Sets the cell's bottom border color
- Format::setTopColor — Sets the cell's top border color
- Format::setLeftColor — Sets the cell's left border color
- Format::setRightColor — Sets the cell's right border color
- Format::setFgColor — Sets the cell's foreground color
- Format::setBgColor — Sets the cell's background color
- Format::setColor — Sets the color of a cell's content
- Format::setPattern — Sets the fill pattern attribute of a cell
- Format::setUnderline — Sets the underline of the text
- Format::setItalic — Sets the font style as italic
- Format::setSize — Sets the font size
- Format::setTextWrap — Sets text wrapping
- Format::setTextRotation — Sets the orientation of the text
- Format::setNumFormat — Sets the numeric format.
- Format::setStrikeOut — Sets font as strikeout.
- Format::setOutLine — Sets outlining for a font.
- Format::setShadow — Sets font as shadow.
- Format::setScript — Sets the script type of the text
- Format::setFontFamily — Sets the font family.
Вернуться к: Форматы файлов