{
  "_id": "6af31bb9535793c85332662e",
  "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-11-10 13:10:40 UTC",
    "User": "root"
  },
  "Author": "Adrian Dragulescu [aut],\nCole Arendt [aut, cre]",
  "Maintainer": "Cole Arendt <cole.arendt@outlook.com>",
  "_user": "colearendt",
  "_type": "src",
  "_file": "xlsx_0.6.5.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/56e719e1ed27375c1fb498ec9287d51de75f3b25406a7edde1cb54f7c074096e",
  "_filesize": 693875,
  "_sha256": "56e719e1ed27375c1fb498ec9287d51de75f3b25406a7edde1cb54f7c074096e",
  "_expires": "2027-02-18T13:27:19.000Z",
  "_created": "2026-11-10T13:10:40.000Z",
  "_published": "2026-11-10T13:27:21.014Z",
  "_upstream": "https://github.com/colearendt/xlsx",
  "_status": "success",
  "_maintainer": {
    "name": "Cole Arendt",
    "email": "cole.arendt@outlook.com",
    "login": "colearendt",
    "twitter": "@colearendt_",
    "description": "",
    "uuid": 23075542
  },
  "_jobs": [
    {
      "job": 129850257727,
      "time": 140,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13766983346"
    },
    {
      "job": 129850257867,
      "time": 140,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13767577909"
    },
    {
      "job": 129850257670,
      "time": 450,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13766924506"
    },
    {
      "job": 129850257767,
      "time": 184,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13768835443"
    },
    {
      "job": 129848032954,
      "time": 257,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13767217446"
    },
    {
      "job": 129850257718,
      "time": 144,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13766434100"
    },
    {
      "job": 129850257845,
      "time": 112,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13766768502"
    },
    {
      "job": 129850257752,
      "time": 104,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13766288467"
    },
    {
      "job": 129850257764,
      "time": 100,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13766573149"
    }
  ],
  "_buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275",
  "_commit": {
    "id": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
    "author": "Cole Arendt <cole.arendt@outlook.com>",
    "committer": "GitHub <noreply@github.com>",
    "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
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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": 28,
  "_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",
    "followers": 212
  },
  "_downloads": {
    "count": 26577,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/xlsx"
  },
  "_mentions": 95,
  "_devurl": "https://github.com/colearendt/xlsx",
  "_searchresults": 11184,
  "_rbuild": "4.6.2",
  "_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": 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-25-jre-headless",
      "headers": "openjdk-25-jre-headless",
      "source": "openjdk",
      "version": "25.0.5.0.3+1-1~26.04.1",
      "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": 13.86052853759424,
  "_indexed": true,
  "_nocasepkg": "xlsx",
  "_universes": [
    "colearendt"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.6.5.9000",
      "date": "2026-11-10T13:13:04.000Z",
      "distro": "resolute",
      "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
      "fileid": "https://r2.ropensci.org/6f56b2b9cdfd50521faa32482263996fb9c728d0082e73ce26b8f61c3f77a298",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.6.5.9000",
      "date": "2026-11-10T13:13:02.000Z",
      "distro": "resolute",
      "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
      "fileid": "https://r2.ropensci.org/b9d047238a85bfe31e84ccf82de93c60139318ec93fe47d791a2c965e4d1a5fb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.6.5.9000",
      "date": "2026-11-10T13:18:36.000Z",
      "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
      "fileid": "https://r2.ropensci.org/d528d444f823616fc3a6bbed41b3c1c47172d66ea7507e4470a361319427c713",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.6.5.9000",
      "date": "2026-11-10T13:25:51.000Z",
      "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
      "fileid": "https://r2.ropensci.org/04791c4a7e5376fccd8ed4e803d0e83e5e10fc8adf95accfa04b6e2c01d0487b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.6.5.9000",
      "date": "2026-11-10T13:13:26.000Z",
      "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
      "fileid": "https://r2.ropensci.org/8021f07441353a34999eddec4be958c5e604bbde9c9d418db156b9223749921d",
      "status": "success",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.6.5.9000",
      "date": "2026-11-10T13:12:00.000Z",
      "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
      "fileid": "https://r2.ropensci.org/d92a01e98f0637ddc3e03d708f1a2db0937db71fb1b434d4cac870f4fae7c75c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.6.5.9000",
      "date": "2026-11-10T13:12:02.000Z",
      "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
      "fileid": "https://r2.ropensci.org/7110ccdd3f82bee2a368b6ec9d1a8cacdf9bbdfe700ce547de1b352db3fc60ea",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.6.5.9000",
      "date": "2026-11-10T13:11:58.000Z",
      "commit": "4ed1d0127fdec1581808656b9c636b0fbd0ac4fd",
      "fileid": "https://r2.ropensci.org/4224283e32e31a50a6e9d7ab04a44082795096e661d15570b8aa89b7091b49c1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/42821493275"
    }
  ]
}