{ "_id": "6a2d31c43efcd9bda42fb34b", "Package": "xlsx", "Type": "Package", "Title": "Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files", "Version": "0.6.5", "LazyLoad": "yes", "Authors@R": "c(person(given = \"Adrian\",\nfamily = \"Dragulescu\",\nrole = c(\"aut\"),\nemail = \"adrian.dragulescu@gmail.com\"),\nperson(given = \"Cole\",\nfamily = \"Arendt\",\nrole = c(\"aut\", \"cre\"),\nemail = \"cole.arendt@outlook.com\")\n)", "Description": "Provide R functions to read/write/format Excel 2007 and\nExcel 97/2000/XP/2003 file formats.", "License": "GPL-3", "URL": "https://github.com/colearendt/xlsx", "BugReports": "https://github.com/colearendt/xlsx/issues", "SystemRequirements": "java (>= 1.6)", "RoxygenNote": "7.1.0", "VignetteBuilder": "knitr", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-13 10:29:09 UTC", "User": "root" }, "Author": "Adrian Dragulescu [aut], Cole Arendt [aut, cre]", "Maintainer": "Cole Arendt ", "Config/pak/sysreqs": "default-jdk", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2020-11-10 14:00:02 UTC", "RemoteUrl": "https://github.com/cran/xlsx", "RemoteRef": "HEAD", "RemoteSha": "5a31898db0370e0de2bbce13c414550558cba02b", "MD5sum": "e9f0123062d40e21dec3521310be0ef6", "_user": "cran", "_type": "src", "_file": "xlsx_0.6.5.tar.gz", "_fileid": "2d74c09742a5c133507732f68e3bb847372a70e044bb1f5cbfcbe6e106d21ecf", "_filesize": 692482, "_sha256": "2d74c09742a5c133507732f68e3bb847372a70e044bb1f5cbfcbe6e106d21ecf", "_created": "2026-06-13T10:29:09.000Z", "_published": "2026-06-13T10:32:36.594Z", "_distro": "noble", "_jobs": [ { "job": 81183480663, "time": 171, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7609950396" }, { "job": 81183480642, "time": 151, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7609948296" }, { "job": 81183284355, "time": 209, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7609930672" }, { "job": 81183480637, "time": 127, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7609945753" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/27464120531", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/xlsx", "_commit": { "id": "5a31898db0370e0de2bbce13c414550558cba02b", "author": "Cole Arendt ", "committer": "cran-robot ", "message": "version 0.6.5\n", "time": 1605016802 }, "_maintainer": { "name": "Cole Arendt", "email": "cole.arendt@outlook.com", "login": "colearendt", "twitter": "@colearendt_", "description": "", "uuid": 23075542 }, "_registered": true, "_dependencies": [ { "package": "rJava", "role": "Imports" }, { "package": "xlsxjars", "role": "Imports" }, { "package": "grDevices", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "rprojroot", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "covr", "role": "Suggests" }, { "package": "tibble", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 32, "_updates": [], "_tags": [], "_stars": 1, "_contributors": [ { "user": "dragua", "count": 16, "uuid": 13407103 }, { "user": "colearendt", "count": 4, "uuid": 23075542 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 32046, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/xlsx" }, "_mentions": 95, "_devurl": "https://github.com/colearendt/xlsx", "_searchresults": 12512, "_topics": [ "openjdk" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/xlsx.html", "manual.pdf" ], "_homeurl": "https://github.com/colearendt/xlsx", "_realowner": "colearendt", "_cranurl": false, "_releases": [ { "version": "0.1.1", "date": "2010-01-03" }, { "version": "0.1.3", "date": "2010-03-17" }, { "version": "0.2.0", "date": "2010-05-01" }, { "version": "0.2.1", "date": "2010-05-16" }, { "version": "0.2.2", "date": "2010-07-24" }, { "version": "0.2.3", "date": "2010-08-27" }, { "version": "0.2.4", "date": "2010-10-13" }, { "version": "0.3.0", "date": "2011-03-03" }, { "version": "0.4.0", "date": "2012-01-15" }, { "version": "0.4.1", "date": "2012-01-24" }, { "version": "0.4.2", "date": "2012-02-11" }, { "version": "0.5.0", "date": "2012-09-26" }, { "version": "0.5.1", "date": "2013-05-20" }, { "version": "0.5.5", "date": "2013-12-10" }, { "version": "0.5.7", "date": "2014-08-02" }, { "version": "0.6.1", "date": "2018-06-11" }, { "version": "0.6.2", "date": "2020-02-12" }, { "version": "0.6.3", "date": "2020-02-28" }, { "version": "0.6.4.2", "date": "2020-09-12" }, { "version": "0.6.5", "date": "2020-11-10" } ], "_exports": [ "addAutoFilter", "addDataFrame", "addHyperlink", "addMergedRegion", "addPicture", "Alignment", "autoSizeColumn", "Border", "BORDER_STYLES_", "CB.setBorder", "CB.setColData", "CB.setFill", "CB.setFont", "CB.setMatrixData", "CB.setRowData", "CELL_STYLES_", "CellBlock", "CellProtection", "CellStyle", "createCell", "createCellComment", "createFreezePane", "createRange", "createRow", "createSheet", "createSplitPane", "createWorkbook", "DataFormat", "Fill", "FILL_STYLES_", "Font", "forceFormulaRefresh", "forcePivotTableRefresh", "get_java_tmp_dir", "getCellComment", "getCells", "getCellStyle", "getCellValue", "getRanges", "getRows", "getSheets", "HALIGN_STYLES_", "INDEXED_COLORS_", "is.Alignment", "is.Border", "is.CellBlock", "is.CellProtection", "is.CellStyle", "is.DataFormat", "is.Fill", "is.Font", "loadWorkbook", "printSetup", "read.xlsx", "read.xlsx2", "readColumns", "readRange", "readRows", "removeCellComment", "removeMergedRegion", "removeRow", "removeSheet", "saveWorkbook", "set_java_tmp_dir", "setCellStyle", "setCellValue", "setColumnWidth", "setPrintArea", "setRowHeight", "setZoom", "VALIGN_STYLES_", "write.xlsx", "write.xlsx2" ], "_help": [ { "page": "xlsx-package", "title": "Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files", "topics": [ "xlsx-package", "xlsx" ] }, { "page": "addDataFrame", "title": "Add a 'data.frame' to a sheet.", "topics": [ "addDataFrame" ] }, { "page": "addHyperlink", "title": "Add a hyperlink to a cell.", "topics": [ "addHyperlink" ] }, { "page": "Cell", "title": "Functions to manipulate cells.", "topics": [ "Cell", "createCell", "getCells", "getCellValue", "setCellValue" ] }, { "page": "CellBlock", "title": "Create and style a block of cells.", "topics": [ "CB.setBorder", "CB.setColData", "CB.setFill", "CB.setFont", "CB.setMatrixData", "CB.setRowData", "CellBlock", "CellBlock.default", "is.CellBlock" ] }, { "page": "CellStyle", "title": "Functions to manipulate cells.", "topics": [ "CellStyle", "CellStyle.default", "getCellStyle", "is.CellStyle", "setCellStyle" ] }, { "page": "CellStyle-plus", "title": "CellStyle construction.", "topics": [ "+.CellStyle", "CellStyle-plus" ] }, { "page": "Comment", "title": "Functions to manipulate cell comments.", "topics": [ "Comment", "createCellComment", "getCellComment", "removeCellComment" ] }, { "page": "autoRefresh", "title": "Force Refresh Pivot Tables and Formulae", "topics": [ "forceFormulaRefresh", "forcePivotTableRefresh" ] }, { "page": "Alignment", "title": "Create an Alignment object.", "topics": [ "Alignment", "is.Alignment" ] }, { "page": "Border", "title": "Create an Border object.", "topics": [ "Border", "is.Border" ] }, { "page": "CellProtection", "title": "Create a CellProtection object.", "topics": [ "CellProtection", "is.CellProtection" ] }, { "page": "DataFormat", "title": "Create an DataFormat object.", "topics": [ "DataFormat", "is.DataFormat" ] }, { "page": "Fill", "title": "Create an Fill object.", "topics": [ "Fill", "is.Fill" ] }, { "page": "Font", "title": "Create a Font object.", "topics": [ "Font", "is.Font" ] }, { "page": "NamedRanges", "title": "Functions to manipulate (contiguous) named ranges.", "topics": [ "createRange", "getRanges", "NamedRanges", "readRange" ] }, { "page": "OtherEffects", "title": "Functions to do various spreadsheets effects.", "topics": [ "addAutoFilter", "addMergedRegion", "autoSizeColumn", "createFreezePane", "createSplitPane", "OtherEffects", "removeMergedRegion", "setColumnWidth", "setPrintArea", "setZoom" ] }, { "page": "Picture", "title": "Functions to manipulate images in a spreadsheet.", "topics": [ "addPicture", "Picture" ] }, { "page": "POI_constants", "title": "Constants used in the project.", "topics": [ "BORDER_STYLES_", "CELL_STYLES_", "FILL_STYLES_", "HALIGN_STYLES_", "INDEXED_COLORS_", "POI_constants", "VALIGN_STYLES_" ] }, { "page": "PrintSetup", "title": "Function to manipulate print setup.", "topics": [ "PrintSetup", "printSetup" ] }, { "page": "read.xlsx", "title": "Read the contents of a worksheet into an R 'data.frame'.", "topics": [ "read.xlsx", "read.xlsx2" ] }, { "page": "readColumns", "title": "Read a contiguous set of columns from sheet into an R data.frame", "topics": [ "readColumns" ] }, { "page": "readRows", "title": "Read a contiguous set of rows into an R matrix", "topics": [ "readRows" ] }, { "page": "Row", "title": "Functions to manipulate rows of a worksheet.", "topics": [ "createRow", "getRows", "removeRow", "Row", "setRowHeight" ] }, { "page": "set_java_tmp_dir", "title": "Set Java Temp Directory", "topics": [ "get_java_tmp_dir", "set_java_tmp_dir" ] }, { "page": "Sheet", "title": "Functions to manipulate worksheets.", "topics": [ "createSheet", "getSheets", "removeSheet", "Sheet", "Worksheet" ] }, { "page": "Workbook", "title": "Functions to manipulate Excel 2007 workbooks.", "topics": [ "createWorkbook", "loadWorkbook", "saveWorkbook", "Workbook" ] }, { "page": "write.xlsx", "title": "Write a data.frame to an Excel workbook.", "topics": [ "write.xlsx", "write.xlsx2" ] } ], "_readme": "https://github.com/cran/xlsx/raw/HEAD/README.md", "_rundeps": [ "rJava", "xlsxjars" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-21-jre-headless", "headers": "openjdk-21-jre-headless", "source": "openjdk", "version": "21.0.11+10-1~24.04.2", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_vignettes": [ { "source": "excel_report.Rmd", "filename": "excel_report.html", "title": "Build Excel Reports from R", "author": "Cole Arendt", "engine": "knitr::rmarkdown", "headings": [ "Building Excel Reports in R", "From Scratch", "Functional Cell Styles" ], "created": "2020-02-12 15:50:02", "modified": "2020-09-12 05:00:03", "commits": 2 } ], "_score": 10.28434180144414, "_indexed": false, "_nocasepkg": "xlsx", "_universes": [ "cran" ], "_indexurl": "https://colearendt.r-universe.dev/xlsx", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.6.5", "date": "2026-06-13T10:31:50.000Z", "distro": "noble", "commit": "5a31898db0370e0de2bbce13c414550558cba02b", "fileid": "9607966f61a3d1fd691c2700542e9096a505141efa24fad01b75afc95d2e1f78", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27464120531" }, { "r": "4.6.0", "os": "linux", "version": "0.6.5", "date": "2026-06-13T10:31:31.000Z", "distro": "noble", "commit": "5a31898db0370e0de2bbce13c414550558cba02b", "fileid": "08245fcea3ae22840e8e4ff467289f89c065b79654d44a543711635fad876689", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27464120531" }, { "r": "4.6.0", "os": "wasm", "version": "0.6.5", "date": "2026-06-13T10:31:40.000Z", "commit": "5a31898db0370e0de2bbce13c414550558cba02b", "fileid": "bed55f31a09bc0bd2190bf9b5033de57703e3bdcc422f899e3e9ab14f343ac3e", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/27464120531" } ] }