{
  "_id": "6ac3a1794ba63dfb3181e9b7",
  "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-10-05 13:06:01 UTC",
    "User": "root"
  },
  "Author": "Adrian Dragulescu [aut], Cole Arendt [aut, cre]",
  "Maintainer": "Cole Arendt <cole.arendt@outlook.com>",
  "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",
  "_user": "cran",
  "_type": "src",
  "_file": "xlsx_0.6.5.tar.gz",
  "_fileid": "https://r2.ropensci.org/e9335709865de0b5aca3b262d8047b7f68144eba997937b483f970ff8b718d23",
  "_filesize": 693707,
  "_sha256": "e9335709865de0b5aca3b262d8047b7f68144eba997937b483f970ff8b718d23",
  "_expires": "2027-01-13T13:09:10.000Z",
  "_created": "2026-10-05T13:06:01.000Z",
  "_published": "2026-10-05T13:09:12.985Z",
  "_jobs": [
    {
      "job": 111776931055,
      "time": 151,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11347441203"
    },
    {
      "job": 111776930999,
      "time": 129,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11347441150"
    },
    {
      "job": 111775578727,
      "time": 192,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11347690499"
    },
    {
      "job": 111776931187,
      "time": 101,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11347456088"
    },
    {
      "job": 111776931368,
      "time": 111,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11347311265"
    },
    {
      "job": 111776930861,
      "time": 100,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11347690879"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/37313807343",
  "_status": "success",
  "_upstream": "https://github.com/cran/xlsx",
  "_commit": {
    "id": "5a31898db0370e0de2bbce13c414550558cba02b",
    "author": "Cole Arendt <cole.arendt@outlook.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 0.6.5\n",
    "time": 1605016802
  },
  "_maintainer": {
    "name": "Cole Arendt",
    "email": "cole.arendt@outlook.com",
    "login": "colearendt",
    "twitter": "@colearendt_",
    "description": "",
    "uuid": 23075542
  },
  "_distro": "resolute",
  "_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": 29,
  "_updates": [],
  "_tags": [],
  "_stars": 1,
  "_contributors": [
    {
      "user": "dragua",
      "count": 16,
      "uuid": 13407103
    },
    {
      "user": "colearendt",
      "count": 4,
      "uuid": 23075542
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "followers": 631,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 30266,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/xlsx"
  },
  "_mentions": 95,
  "_devurl": "https://github.com/colearendt/xlsx",
  "_searchresults": 11264,
  "_topics": [
    "openjdk"
  ],
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/xlsx.html"
  ],
  "_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-25-jre-headless",
      "headers": "openjdk-25-jre-headless",
      "source": "openjdk",
      "version": "25.0.4.1+1-1~26.04.4",
      "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.171136926490991,
  "_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-10-05T13:08:33.000Z",
      "distro": "resolute",
      "commit": "5a31898db0370e0de2bbce13c414550558cba02b",
      "fileid": "https://r2.ropensci.org/f26e2a6238cc38f0bcdb307aa01b3ef210fd66e4d81e6747be9099ffe433dafd",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37313807343"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.6.5",
      "date": "2026-10-05T13:08:12.000Z",
      "distro": "resolute",
      "commit": "5a31898db0370e0de2bbce13c414550558cba02b",
      "fileid": "https://r2.ropensci.org/a1ef841e57803ee95405ca9f6ebf5355f61450ae1320e2594246e42fa47a2246",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37313807343"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.6.5",
      "date": "2026-10-05T13:08:06.000Z",
      "commit": "5a31898db0370e0de2bbce13c414550558cba02b",
      "fileid": "https://r2.ropensci.org/63d1c2670116a33c6d1c535d5b584a0c9ace1b233195a0e713d703244b8b9137",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37313807343"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.6.5",
      "date": "2026-10-05T13:07:20.000Z",
      "commit": "5a31898db0370e0de2bbce13c414550558cba02b",
      "fileid": "https://r2.ropensci.org/22cbe1cd3c2fb86cd43d8ba0891234044b07947f10801308660fc334c6487695",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37313807343"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.6.5",
      "date": "2026-10-05T13:07:16.000Z",
      "commit": "5a31898db0370e0de2bbce13c414550558cba02b",
      "fileid": "https://r2.ropensci.org/f01c053eca99d0315d898fb172c904f3fbbb7617208681cc76dd632a5e68f626",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37313807343"
    }
  ]
}