Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files


[Up] [Top]

Documentation for package ‘xlsx’ version 0.3.0

Help Pages

xlsx-package Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files
addMergedRegion Functions to do various spreadsheets effects.
addPicture Functions to manipulate images in a spreadsheet.
autoSizeColumn Functions to do various spreadsheets effects.
Cell Functions to manipulate cells.
CellStyle Functions to manipulate cells.
Comment Functions to manipulate cell comments.
createCell Functions to manipulate cells.
createCellComment Functions to manipulate cell comments.
createCellStyle Functions to manipulate cells.
createFont Create a Font object.
createFreezePane Functions to do various spreadsheets effects.
createRange Functions to manipulate named ranges.
createRow Functions to manipulate rows of a worksheet.
createSheet Functions to manipulate worksheets.
createSplitPane Functions to do various spreadsheets effects.
createWorkbook Functions to manipulate Excel 2007 workbooks.
Font Create a Font object.
getCellComment Functions to manipulate cell comments.
getCells Functions to manipulate cells.
getCellStyle Functions to manipulate cells.
getCellValue Functions to manipulate cells.
getMatrixValues Functions to manipulate cells.
getRanges Functions to manipulate named ranges.
getRows Functions to manipulate rows of a worksheet.
getSheets Functions to manipulate worksheets.
loadWorkbook Functions to manipulate Excel 2007 workbooks.
NamedRanges Functions to manipulate named ranges.
OtherEffects Functions to do various spreadsheets effects.
Picture Functions to manipulate images in a spreadsheet.
PrintSetup Function to manipulate print setup.
printSetup Function to manipulate print setup.
Range Functions to manipulate named ranges.
read.xlsx Read the contents of a worksheet into an R data.frame
read.xlsx2 Read the contents of a worksheet into an R data.frame
readRange Functions to manipulate named ranges.
removeCellComment Functions to manipulate cell comments.
removeMergedRegion Functions to do various spreadsheets effects.
removeRow Functions to manipulate rows of a worksheet.
removeSheet Functions to manipulate worksheets.
Row Functions to manipulate rows of a worksheet.
saveWorkbook Functions to manipulate Excel 2007 workbooks.
setCellStyle Functions to manipulate cells.
setCellValue Functions to manipulate cells.
setPrintArea Functions to do various spreadsheets effects.
setZoom Functions to do various spreadsheets effects.
Sheet Functions to manipulate worksheets.
Workbook Functions to manipulate Excel 2007 workbooks.
Worksheet Functions to manipulate worksheets.
write.xlsx Write a data.frame to an Excel 2007 workbook.
write.xlsx2 Write a data.frame to an Excel 2007 workbook.
xlsx Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files