xlrd is a library for reading data and formatting information from Excel files in the historical .xls format.

xlrd.formatting.fmt_bracketed_sub(repl, string, count=0) ¶ Return the string obtained by replacing the leftmost non-overlapping occurrences of pattern in string by the replacement repl.

This collection of features, new in xlrd version 0.6.1, is intended to provide the information needed to: display/render spreadsheet contents (say) on a screen or in a PDF file

Loading worksheets on demand ¶ This feature, new in version 0.7.1, is governed by the on_demand argument to the open_workbook() function and allows saving memory and time by loading only those …

Named references, constants, formulas, and macros ¶ A name is used to refer to a cell, a group of cells, a constant value, a formula, or a macro. Usually the scope of a name is global across the whole …

Dates in Excel spreadsheets ¶ In reality, there are no such things. What you have are floating point numbers and pious hope. There are several problems with Excel dates: Dates are not stored as a …

Older files (Excel 95 and earlier) don’t keep strings in Unicode; a CODEPAGE record provides a codepage number (for example, 1252) which is used by xlrd to derive the encoding (for same …

Thanks to Didrik Pinte for reporting the need for xlrd to be more tolerant of the idiosyncracies of other software, for supplying sample files, and for performing alpha testing.

To make a release, just update the version in xlrd.info.__VERSION__, update the change log and push to https://github.com/python-excel/xlrd and Carthorse should take care of the rest.

xlrd.formatting.fmt_bracketed_sub(repl, string, count=0) ¶ Return the string obtained by replacing the leftmost non-overlapping occurrences of pattern in string by the replacement repl.