{ "_id": "6a252f0a4b233be198395705", "Type": "Package", "Package": "xlsx", "Title": "Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files", "Version": "0.6.5.9000", "Authors@R": "c(person(given = \"Adrian\",\nfamily = \"Dragulescu\",\nrole = \"aut\",\nemail = \"adrian.dragulescu@gmail.com\"),\nperson(given = \"Cole\",\nfamily = \"Arendt\",\nrole = c(\"aut\", \"cre\"),\nemail = \"cole.arendt@outlook.com\"))", "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", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "LazyLoad": "yes", "RoxygenNote": "7.1.0", "SystemRequirements": "java (>= 1.6)", "Config/pak/sysreqs": "make default-jdk", "Repository": "https://colearendt.r-universe.dev", "Date/Publication": "2022-01-30 09:30:59 UTC", "RemoteUrl": "https://github.com/colearendt/xlsx", "RemoteRef": "HEAD", "RemoteSha": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-07 08:38:40 UTC", "User": "root" }, "Author": "Adrian Dragulescu [aut],\nCole Arendt [aut, cre]", "Maintainer": "Cole Arendt ", "MD5sum": "2deaef5d850d9943e329e9aa0e5dd4eb", "_user": "colearendt", "_type": "src", "_file": "xlsx_0.6.5.9000.tar.gz", "_fileid": "fc2f43dd57d470ed852fb795a71cd10f4dbf6a363d36e10ef74314d19a03b6cc", "_filesize": 697386, "_sha256": "fc2f43dd57d470ed852fb795a71cd10f4dbf6a363d36e10ef74314d19a03b6cc", "_created": "2026-06-07T08:38:40.000Z", "_published": "2026-06-07T08:42:50.692Z", "_distro": "noble", "_jobs": [ { "job": 79944971528, "time": 148, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7462454443" }, { "job": 79944971534, "time": 150, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7462454541" }, { "job": 79944971533, "time": 218, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7462462701" }, { "job": 79944971542, "time": 89, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7462447077" }, { "job": 79944788739, "time": 201, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7462436377" }, { "job": 79944971531, "time": 105, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7462448980" }, { "job": 79944971540, "time": 118, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7462450624" }, { "job": 79944971539, "time": 101, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7462448395" }, { "job": 79944971536, "time": 111, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7462449659" } ], "_buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/colearendt/xlsx", "_commit": { "id": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "author": "Cole Arendt ", "committer": "GitHub ", "message": "Merge pull request #173 from colearendt/dependabot/maven/other/junit-junit-4.13.1\n\nBump junit from 4.10 to 4.13.1 in /other", "time": 1643535059 }, "_maintainer": { "name": "Cole Arendt", "email": "cole.arendt@outlook.com", "login": "colearendt", "twitter": "@colearendt_", "description": "", "uuid": 23075542 }, "_registered": true, "_dependencies": [ { "package": "grDevices", "role": "Imports" }, { "package": "rJava", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "xlsxjars", "role": "Imports" }, { "package": "covr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "rprojroot", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "tibble", "role": "Suggests" } ], "_owner": "colearendt", "_selfowned": true, "_usedby": 32, "_updates": [], "_tags": [], "_topics": [ "excel", "java", "rjava", "xlsx", "openjdk" ], "_stars": 83, "_contributors": [ { "user": "colearendt", "count": 216, "uuid": 23075542 }, { "user": "dragua", "count": 58, "uuid": 13407103 }, { "user": "alyst", "count": 9, "uuid": 348591 }, { "user": "zeehio", "count": 4, "uuid": 75441 }, { "user": "tk3369", "count": 2, "uuid": 1159782 }, { "user": "jeroen", "count": 1, "uuid": 216319 }, { "user": "lawilliams", "count": 1, "uuid": 248061 }, { "user": "sherrillmix", "count": 1, "uuid": 1217152 } ], "_userbio": { "uuid": 23075542, "type": "user", "name": "Cole Arendt" }, "_downloads": { "count": 33104, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/xlsx" }, "_mentions": 95, "_devurl": "https://github.com/colearendt/xlsx", "_searchresults": 12480, "_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": true, "_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/colearendt/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-06 22:58:29", "modified": "2020-09-12 09:54:27", "commits": 2 } ], "_score": 14.061512428433984, "_indexed": true, "_nocasepkg": "xlsx", "_universes": [ "colearendt" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.6.5.9000", "date": "2026-06-07T08:40:53.000Z", "distro": "noble", "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "fileid": "f488121553afa4beab1d7f7d6111f09eecccdb76d28281b74121d3eb483e8a7d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532" }, { "r": "4.6.0", "os": "linux", "version": "0.6.5.9000", "date": "2026-06-07T08:40:54.000Z", "distro": "noble", "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "fileid": "fec406ec16209cfdca19fce2c5e2b48aeede329f244c87eddf1251aa232607b6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532" }, { "r": "4.5.3", "os": "mac", "version": "0.6.5.9000", "date": "2026-06-07T08:41:42.000Z", "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "fileid": "031a9379fe6da399021ee0cfac622556c06e2b23186e1be47cdfb090a9a38866", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532" }, { "r": "4.6.0", "os": "mac", "version": "0.6.5.9000", "date": "2026-06-07T08:40:05.000Z", "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "fileid": "4a92247e2f63d8ea282455581fc0876a4286903effe691c6266c0ee0943e4ab1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532" }, { "r": "4.6.0", "os": "wasm", "version": "0.6.5.9000", "date": "2026-06-07T08:40:42.000Z", "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "fileid": "4c9528c2fc9866f962422ce6c74edcd640bf8889c496c83361de29f6dbd84f2e", "status": "success", "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532" }, { "r": "4.7.0", "os": "win", "version": "0.6.5.9000", "date": "2026-06-07T08:39:54.000Z", "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "fileid": "ab483b42752be9ee8b13a8d507b8b53cf544ac2f24c7f69b7b438b6557a47fa7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532" }, { "r": "4.5.3", "os": "win", "version": "0.6.5.9000", "date": "2026-06-07T08:39:49.000Z", "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "fileid": "d9bb1c5c3d708351ab249517750a6dbada3c6bbb90ad4c8172535b4b9d8738b2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532" }, { "r": "4.6.0", "os": "win", "version": "0.6.5.9000", "date": "2026-06-07T08:39:50.000Z", "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd", "fileid": "56e279a53edb3c01e094e3be408c71dbda8104280f5e7841ff856089a9ec5606", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27087520532" } ] }