excel-libxl
Advanced tools
Changelog
Version 0.0.5
SCRIPT_*
), underline styles (UNDERLINE_*
), colors (COLOR_*
)Changelog
Version 0.0.4
Format
(libxl::Format), Font
(libxl::Font)Book
API:
sheetCount()
gives number of sheets in the workbookaddFormat(initFormat)
adds new formatformat(idx)
returns format defined under given indexformatSize()
returns number of formats defined in the bookaddFont(initFont
/ font(idx)
/ fontSize()
Sheet::cellType()
- was throwing error if cell has error typeChangelog
Version 0.0.3
Sheet
API:
cellType(row, col)
readString(row, col)
writeString(row, col, string)
CELLTYPE_*
)Changelog
Version 0.0.2
Sheet
class (libxl::Sheet):
getName()
setName(name)
Book
API:
load(path, cb)
/ loadSync(path)
save(path, cb)
/ saveSync(path)
setKey(customerName, customerKey)
sets license keyrelease()
- release all the book memory, does libxl::Book::release()
addSheetSync(name, initSheet)
insertSheetSync(idx, name, initSheet)
getSheet(idx)
deleteSheet(idx)
Changelog
Version 0.0.1
Book
class (libxl::Book)createBook()
is equivalent to xlCreateBook()
createXMLBook()
is equivalent to xlCreateXMLBook()
Book
can be instantiated via constructor: new Book(type)
where type
is one of the constants:
BOOK_TYPE_XLS
, BOOK_TYPE_XLSX