{ "_id": "6a16a0d7acfb0bcc41d811ef", "Type": "Package", "Package": "openxlsx", "Title": "Read, Write and Edit xlsx Files", "Version": "4.2.8.1", "Date": "2025-10-30", "Authors@R": "c(person(given = \"Philipp\",\nfamily = \"Schauberger\",\nrole = \"aut\",\nemail = \"philipp@schauberger.co.at\"),\nperson(given = \"Alexander\",\nfamily = \"Walker\",\nrole = \"aut\",\nemail = \"Alexander.Walker1989@gmail.com\"),\nperson(given = \"Luca\",\nfamily = \"Braglia\",\nrole = \"ctb\"),\nperson(given = \"Joshua\",\nfamily = \"Sturm\",\nrole = \"ctb\"),\nperson(given = \"Jan Marvin\",\nfamily = \"Garbuszus\",\nrole = c(\"ctb\", \"cre\"),\nemail = \"jan.garbuszus@ruhr-uni-bochum.de\"),\nperson(given = \"Jordan Mark\",\nfamily = \"Barbone\",\nrole = \"ctb\",\nemail = \"jmbarbone@gmail.com\",\ncomment = c(ORCID = \"0000-0001-9788-3628\")),\nperson(given = \"David\",\nfamily = \"Zimmermann\",\nrole = \"ctb\",\nemail = \"david_j_zimmermann@hotmail.com\"),\nperson(given = \"Reinhold\",\nfamily = \"Kainhofer\",\nrole = \"ctb\",\nemail = \"reinhold@kainhofer.com\"))", "Description": "Simplifies the creation of Excel .xlsx files by providing\na high level interface to writing, styling and editing\nworksheets. Through the use of 'Rcpp', read/write times are\ncomparable to the 'xlsx' and 'XLConnect' packages with the\nadded benefit of removing the dependency on Java.", "License": "MIT + file LICENSE", "URL": "https://ycphs.github.io/openxlsx/index.html,\nhttps://github.com/ycphs/openxlsx", "BugReports": "https://github.com/ycphs/openxlsx/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Language": "en-US", "RoxygenNote": "7.3.3", "Collate": "'CommentClass.R' 'HyperlinkClass.R' 'RcppExports.R'\n'class_definitions.R' 'StyleClass.R' 'WorkbookClass.R'\n'asserts.R' 'baseXML.R' 'borderFunctions.R' 'build_workbook.R'\n'chartsheet_class.R' 'conditional_formatting.R'\n'data-fontSizeLookupTables.R' 'helperFunctions.R'\n'loadWorkbook.R' 'onUnload.R' 'openXL.R' 'openxlsx-package.R'\n'openxlsx.R' 'openxlsxCoerce.R' 'readWorkbook.R'\n'setWindowSize.R' 'sheet_data_class.R' 'utils.R'\n'workbook_column_widths.R' 'workbook_read_workbook.R'\n'workbook_write_data.R' 'worksheet_class.R' 'wrappers.R'\n'writeData.R' 'writeDataTable.R' 'writexlsx.R' 'zzz.R'", "Roxygen": "list(markdown = TRUE)", "LazyData": "true", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://ycphs.r-universe.dev", "Date/Publication": "2026-01-27 09:31:51 UTC", "RemoteUrl": "https://github.com/ycphs/openxlsx", "RemoteRef": "HEAD", "RemoteSha": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-05-27 07:35:29 UTC", "User": "root" }, "Author": "Philipp Schauberger [aut],\nAlexander Walker [aut],\nLuca Braglia [ctb],\nJoshua Sturm [ctb],\nJan Marvin Garbuszus [ctb, cre],\nJordan Mark Barbone [ctb] (ORCID:\n),\nDavid Zimmermann [ctb],\nReinhold Kainhofer [ctb]", "Maintainer": "Jan Marvin Garbuszus ", "MD5sum": "00cca7a32294397c73bfcc82caac24a2", "_user": "ycphs", "_type": "src", "_file": "openxlsx_4.2.8.1.tar.gz", "_fileid": "fedde720f1df8dbafd358fc20230ac5ffb8dff049388b1e6eb681d3ec0a97c3d", "_filesize": 1719395, "_sha256": "fedde720f1df8dbafd358fc20230ac5ffb8dff049388b1e6eb681d3ec0a97c3d", "_created": "2026-05-27T07:35:29.000Z", "_published": "2026-05-27T07:44:23.103Z", "_distro": "noble", "_jobs": [ { "job": 78029648899, "time": 193, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7234611323" }, { "job": 78029648954, "time": 201, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7234613946" }, { "job": 78029648910, "time": 174, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7234605464" }, { "job": 78029648966, "time": 201, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7234613387" }, { "job": 78029648955, "time": 269, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7234653222" }, { "job": 78029648992, "time": 362, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "7234687233" }, { "job": 78029648971, "time": 212, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7234629922" }, { "job": 78029649074, "time": 318, "config": "macos-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7234677644" }, { "job": 78028999104, "time": 258, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7234548502" }, { "job": 78029648841, "time": 144, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7234595468" }, { "job": 78029648897, "time": 233, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7234624225" }, { "job": 78029648928, "time": 220, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7234620385" }, { "job": 78029648917, "time": 218, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7234620088" } ], "_buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/ycphs/openxlsx", "_commit": { "id": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "author": "Jan Marvin Garbuszus ", "committer": "Jan Marvin Garbuszus ", "message": "fix NEWS.md versioning and add note\n\ncloses #534\n", "time": 1769506311 }, "_maintainer": { "name": "Jan Marvin Garbuszus", "email": "jan.garbuszus@ruhr-uni-bochum.de", "login": "janmarvin", "linkedin": "in/jan-marvin-garbuszus", "description": "", "uuid": 1645626 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.3.0", "role": "Depends" }, { "package": "Rcpp", "role": "LinkingTo" }, { "package": "grDevices", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "Rcpp", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "stringi", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "zip", "role": "Imports" }, { "package": "curl", "role": "Suggests" }, { "package": "formula.tools", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "ycphs", "_selfowned": true, "_usedby": 332, "_updates": [ { "week": "2025-44", "n": 2 }, { "week": "2026-05", "n": 1 } ], "_tags": [], "_topics": [ "xlsx", "cpp" ], "_stars": 240, "_contributors": [ { "user": "awalker89", "count": 690, "uuid": 7400673 }, { "user": "ycphs", "count": 477, "uuid": 21127941 }, { "user": "janmarvin", "count": 210, "uuid": 1645626 }, { "user": "jmbarbone", "count": 73, "uuid": 38573843 }, { "user": "joshuasturm", "count": 48, "uuid": 22535419 }, { "user": "kainhofer", "count": 19, "uuid": 4689419 }, { "user": "jeff-m-sullivan", "count": 18, "uuid": 7987295 }, { "user": "shrektan", "count": 17, "uuid": 8368933 }, { "user": "lbraglia", "count": 17, "uuid": 603306 }, { "user": "davzim", "count": 11, "uuid": 15910496 }, { "user": "jmpivette", "count": 10, "uuid": 46813298 }, { "user": "blakeboswell", "count": 7, "uuid": 12782539 }, { "user": "chris-stockbridge", "count": 7, "uuid": 36540350 }, { "user": "vkatti", "count": 6, "uuid": 76277932 }, { "user": "heseber", "count": 5, "uuid": 22882929 }, { "user": "noamross", "count": 5, "uuid": 571752 }, { "user": "phs-orivado", "count": 5, "uuid": 89846465 }, { "user": "david-rattray", "count": 5, "uuid": 16545002 }, { "user": "wleoncio", "count": 5, "uuid": 8234768 }, { "user": "stevenhibble-concurrence", "count": 4, "uuid": 154272986 }, { "user": "t-kalinowski", "count": 4, "uuid": 8462255 }, { "user": "jmuhlenkamp", "count": 3, "uuid": 8418604 }, { "user": "luke-symes-tsy", "count": 3, "uuid": 93558726 }, { "user": "debarros", "count": 3, "uuid": 9647582 }, { "user": "michaelchirico", "count": 2, "uuid": 7606389 }, { "user": "tkunstek", "count": 2, "uuid": 1747963 }, { "user": "rfineman", "count": 2, "uuid": 33735858 }, { "user": "deschen1", "count": 2, "uuid": 25662795 }, { "user": "mkyhos", "count": 2, "uuid": 33769439 }, { "user": "krystian8207", "count": 2, "uuid": 20457043 }, { "user": "epanormaalijakauma", "count": 2, "uuid": 35924156 }, { "user": "christianrickert", "count": 2, "uuid": 19319377 }, { "user": "christiankaindl", "count": 2, "uuid": 15364860 }, { "user": "tentacles-from-outer-space", "count": 1, "uuid": 1562600 }, { "user": "michael-dewar", "count": 1, "uuid": 59778502 }, { "user": "elenius", "count": 1, "uuid": 5310644 }, { "user": "nanxstats", "count": 1, "uuid": 199363 }, { "user": "pbfordev", "count": 1, "uuid": 12495521 }, { "user": "philaris", "count": 1, "uuid": 9732649 }, { "user": "tlapak", "count": 1, "uuid": 55213630 }, { "user": "david-f1976", "count": 1, "uuid": 13930432 }, { "user": "olivroy", "count": 1, "uuid": 52606734 }, { "user": "rpcach", "count": 1, "uuid": 75022649 }, { "user": "shaesen2", "count": 1, "uuid": 47894155 }, { "user": "tobwen", "count": 1, "uuid": 1864057 }, { "user": "yasirs", "count": 1, "uuid": 400538 }, { "user": "moohan", "count": 1, "uuid": 5982260 }, { "user": "hadley", "count": 1, "uuid": 4196 }, { "user": "gfiumara", "count": 1, "uuid": 419642 }, { "user": "fweimer-rh", "count": 1, "uuid": 75532728 }, { "user": "ecortens", "count": 1, "uuid": 3460446 }, { "user": "aariq", "count": 1, "uuid": 25404783 }, { "user": "davidgohel", "count": 1, "uuid": 4331618 }, { "user": "darxor", "count": 1, "uuid": 1351765 }, { "user": "dseynaev", "count": 1, "uuid": 5922581 }, { "user": "arni-magnusson", "count": 1, "uuid": 3720910 }, { "user": "aslomko", "count": 1, "uuid": 11588153 }, { "user": "kloppen", "count": 1, "uuid": 12833793 }, { "user": "retostauffer", "count": 1, "uuid": 13628564 } ], "_userbio": { "uuid": 21127941, "type": "user", "name": "Philipp Schauberger" }, "_downloads": { "count": 471811, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/openxlsx" }, "_mentions": 35, "_devurl": "https://github.com/ycphs/openxlsx", "_searchresults": 31872, "_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/openxlsx.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/ycphs/openxlsx", "_realowner": "ycphs", "_cranurl": true, "_releases": [ { "version": "1.0.3", "date": "2014-04-21" }, { "version": "2.0.1", "date": "2014-05-29" }, { "version": "2.0.15", "date": "2014-07-27" }, { "version": "2.2.1", "date": "2014-10-18" }, { "version": "2.4.0", "date": "2015-03-07" }, { "version": "3.0.0", "date": "2015-07-03" }, { "version": "4.0.0", "date": "2017-01-09" }, { "version": "4.0.17", "date": "2017-03-23" }, { "version": "4.1.0", "date": "2018-05-26" }, { "version": "4.1.0.1", "date": "2019-05-28" }, { "version": "4.1.2", "date": "2019-10-29" }, { "version": "4.1.3", "date": "2019-11-07" }, { "version": "4.1.4", "date": "2019-12-06" }, { "version": "4.1.5", "date": "2020-05-06" }, { "version": "4.2.2", "date": "2020-09-17" }, { "version": "4.2.3", "date": "2020-10-27" }, { "version": "4.2.4", "date": "2021-06-16" }, { "version": "4.2.5", "date": "2021-12-14" }, { "version": "4.2.5.1", "date": "2022-10-24" }, { "version": "4.2.5.2", "date": "2023-02-06" }, { "version": "4.2.6", "date": "2024-07-23" }, { "version": "4.2.6.1", "date": "2024-07-23" }, { "version": "4.2.7", "date": "2024-08-30" }, { "version": "4.2.7.1", "date": "2024-09-20" }, { "version": "4.2.8", "date": "2025-01-25" }, { "version": "4.2.8.1", "date": "2025-10-31" } ], "_exports": [ "activeSheet", "activeSheet<-", "addCreator", "addFilter", "addStyle", "addWorksheet", "auto_heights", "buildWorkbook", "cloneWorksheet", "col2int", "conditionalFormat", "conditionalFormatting", "convertFromExcelRef", "convertToDate", "convertToDateTime", "copyWorkbook", "createComment", "createNamedRegion", "createStyle", "createWorkbook", "dataValidation", "deleteData", "deleteDataColumn", "deleteNamedRegion", "freezePane", "get_worksheet_entries", "getBaseFont", "getCellRefs", "getCreators", "getDateOrigin", "getNamedRegions", "getSheetNames", "getStyles", "getTables", "getWindowSize", "groupColumns", "groupRows", "insertImage", "insertPlot", "int2col", "loadWorkbook", "makeHyperlinkString", "mergeCells", "modifyBaseFont", "op.openxlsx", "openXL", "openxlsx_getOp", "openxlsx_setOp", "pageBreak", "pageSetup", "protectWorkbook", "protectWorksheet", "read.xlsx", "readWorkbook", "removeCellMerge", "removeColWidths", "removeComment", "removeFilter", "removeRowHeights", "removeTable", "removeWorksheet", "renameWorksheet", "replaceStyle", "saveWorkbook", "setColWidths", "setFooter", "setHeader", "setHeaderFooter", "setLastModifiedBy", "setRowHeights", "setWindowSize", "sheets", "sheetVisibility", "sheetVisibility<-", "sheetVisible", "sheetVisible<-", "showGridLines", "temp_xlsx", "ungroupColumns", "ungroupRows", "worksheetOrder", "worksheetOrder<-", "write.xlsx", "writeComment", "writeData", "writeDataTable", "writeFormula" ], "_datasets": [ { "name": "openxlsxFontSizeLookupTable", "title": "Font Size Lookup tables", "object": "openxlsxFontSizeLookupTable", "class": [ "data.frame" ], "fields": [ "agency.fb", "aharoni", "algerian", "andalus", "angsana.new", "angsanaupc", "aparajita", "arial.black", "arial.narrow", "arial.rounded.mt.bold", "arial.unicode.ms", "arial", "calibri.light", "calibri", "californian.fb", "calisto.mt", "cambria.math", "cambria", "candara", "castellar", "centaur", "century.gothic", "century.schoolbook", "century", "chiller", "colonna.mt", "comic.sans.ms", "consolas", "constantia", "cooper.black", "copperplate.gothic.bold", "copperplate.gothic.light", "corbel", "cordia.new", "david", "dfkai.sb", "dilleniaupc", "dokchampa", "dotum", "dotumche", "ebrima", "edwardian.script.itc", "elephant", "engravers.mt", "eras.bold.itc", "eras.demi.itc", "eras.light.itc", "eras.medium.itc", "estrangelo.edessa", "eucrosiaupc", "euphemia", "fangsong", "felix.titling", "fixedsys", "footlight.mt.light", "forte", "franklin.gothic.book", "franklin.gothic.demi.cond", "franklin.gothic.demi", "franklin.gothic.heavy", "franklin.gothic.medium.cond", "franklin.gothic.medium", "frankruehl", "freesiaupc", "freestyle.script", "french.script.mt", "gabriola", "gadugi", "gautami", "georgia", "gigi", "gill.sans.mt.condensed", "gill.sans.mt.ext.condensed.bold", "gill.sans.mt", "gill.sans.ultra.bold.condensed", "gill.sans.ultra.bold", "gisha", "gloucester.mt.extra.condensed", "goudy.old.style", "goudy.stout", "gulim", "gulimche", "gungsuh", "gungsuhche", "haettenschweiler", "harlow.solid.italic", "harrington", "high.tower.text", "impact", "imprint.mt.shadow", "informal.roman", "irisupc", "iskoola.pota", "jasmineupc", "jokerman", "juice.itc", "kaiti", "kalinga", "kartika", "khmer.ui", "kodchiangupc", "kristen.itc", "kunstler.script", "lao.ui", "latha", "leelawadee", "levenim.mt", "lilyupc", "lucida.bright", "lucida.calligraphy", "lucida.console", "lucida.fax", "lucida.handwriting", "lucida.sans.typewriter", "lucida.sans.unicode", "lucida.sans", "magneto", "maiandra.gd", "malgun.gothic", "mangal", "marlett", "matura.mt.script.capitals", "meiryo.ui", "meiryo", "microsoft.himalaya", "microsoft.jhenghei.ui", "microsoft.jhenghei", "microsoft.new.tai.lue", "microsoft.phagspa", "microsoft.sans.serif", "microsoft.tai.le", "microsoft.uighur", "microsoft.yahei.ui", "microsoft.yahei", "microsoft.yi.baiti", "miriam.fixed", "miriam", "mistral", "modern.no..20", "modern", "mongolian.baiti", "monotype.corsiva", "moolboran", "ms.gothic", "ms.mincho", "ms.outlook", "ms.pgothic", "ms.pmincho", "ms.reference.sans.serif", "ms.reference.specialty", "ms.sans.serif", "ms.serif", "ms.ui.gothic", "mt.extra", "mv.boli", "narkisim", "niagara.engraved", "niagara.solid", "nirmala.ui", "nsimsun", "nyala", "ocr.a.extended", "old.english.text.mt", "onyx", "palace.script.mt", "palatino.linotype", "papyrus", "parchment", "perpetua.titling.mt", "perpetua", "plantagenet.cherokee", "playbill", "pmingliu.extb", "pmingliu", "poor.richard", "pristina", "raavi", "rage.italic", "rockwell.condensed", "rockwell.extra.bold", "rockwell", "rod", "roman", "sakkal.majalla", "script.mt.bold", "script", "segoe.print", "segoe.script", "segoe.ui.light", "segoe.ui.semibold", "segoe.ui.semilight", "segoe.ui.symbol", "segoe.ui", "shonar.bangla", "showcard.gothic", "shruti", "simhei", "simplified.arabic.fixed", "simplified.arabic", "simsun.extb", "simsun", "small.fonts", "snap.itc", "sylfaen", "symbol", "tahoma", "tempus.sans.itc", "terminal", "times.new.roman", "traditional.arabic", "trebuchet.ms", "tunga", "tw.cen.mt.condensed.extra.bold", "tw.cen.mt.condensed", "tw.cen.mt", "utsaah", "vani", "verdana", "vijaya", "viner.hand.itc", "vivaldi", "vladimir.script", "vrinda", "webdings", "wide.latin" ], "rows": 29, "table": true, "tojson": true }, { "name": "openxlsxFontSizeLookupTableBold", "title": "Font Size Lookup tables", "object": "openxlsxFontSizeLookupTableBold", "class": [ "data.frame" ], "fields": [ "agency.fb", "aharoni", "algerian", "andalus", "angsana.new", "angsanaupc", "aparajita", "arial", "arial.black", "arial.narrow", "arial.rounded.mt.bold", "arial.unicode.ms", "calibri", "calibri.light", "californian.fb", "calisto.mt", "cambria", "cambria.math", "candara", "castellar", "centaur", "century", "century.gothic", "century.schoolbook", "chiller", "colonna.mt", "comic.sans.ms", "consolas", "constantia", "cooper.black", "copperplate.gothic.bold", "copperplate.gothic.light", "corbel", "cordia.new", "david", "dfkai.sb", "dilleniaupc", "dokchampa", "dotum", "dotumche", "ebrima", "edwardian.script.itc", "elephant", "engravers.mt", "eras.bold.itc", "eras.demi.itc", "eras.light.itc", "eras.medium.itc", "estrangelo.edessa", "eucrosiaupc", "euphemia", "fangsong", "felix.titling", "fixedsys", "footlight.mt.light", "forte", "franklin.gothic.book", "franklin.gothic.demi", "franklin.gothic.demi.cond", "franklin.gothic.heavy", "franklin.gothic.medium", "franklin.gothic.medium.cond", "frankruehl", "freesiaupc", "freestyle.script", "french.script.mt", "gabriola", "gadugi", "gautami", "georgia", "gigi", "gill.sans.mt", "gill.sans.mt.condensed", "gill.sans.mt.ext.condensed.bold", "gill.sans.ultra.bold", "gill.sans.ultra.bold.condensed", "gisha", "gloucester.mt.extra.condensed", "goudy.old.style", "goudy.stout", "gulim", "gulimche", "gungsuh", "gungsuhche", "haettenschweiler", "harlow.solid.italic", "harrington", "high.tower.text", "impact", "imprint.mt.shadow", "informal.roman", "irisupc", "iskoola.pota", "jasmineupc", "jokerman", "juice.itc", "kaiti", "kalinga", "kartika", "khmer.ui", "kodchiangupc", "kristen.itc", "kunstler.script", "lao.ui", "latha", "leelawadee", "levenim.mt", "lilyupc", "lucida.bright", "lucida.calligraphy", "lucida.console", "lucida.fax", "lucida.handwriting", "lucida.sans", "lucida.sans.typewriter", "lucida.sans.unicode", "magneto", "maiandra.gd", "malgun.gothic", "mangal", "marlett", "matura.mt.script.capitals", "meiryo", "meiryo.ui", "microsoft.himalaya", "microsoft.jhenghei", "microsoft.jhenghei.ui", "microsoft.new.tai.lue", "microsoft.phagspa", "microsoft.sans.serif", "microsoft.tai.le", "microsoft.uighur", "microsoft.yahei", "microsoft.yahei.ui", "microsoft.yi.baiti", "miriam", "miriam.fixed", "mistral", "modern", "modern.no..20", "mongolian.baiti", "monotype.corsiva", "moolboran", "ms.gothic", "ms.mincho", "ms.outlook", "ms.pgothic", "ms.pmincho", "ms.reference.sans.serif", "ms.reference.specialty", "ms.sans.serif", "ms.serif", "ms.ui.gothic", "mt.extra", "mv.boli", "narkisim", "niagara.engraved", "niagara.solid", "nirmala.ui", "nsimsun", "nyala", "ocr.a.extended", "old.english.text.mt", "onyx", "palace.script.mt", "palatino.linotype", "papyrus", "parchment", "perpetua", "perpetua.titling.mt", "plantagenet.cherokee", "playbill", "pmingliu", "pmingliu.extb", "poor.richard", "pristina", "raavi", "rage.italic", "rockwell", "rockwell.condensed", "rockwell.extra.bold", "rod", "roman", "sakkal.majalla", "script", "script.mt.bold", "segoe.print", "segoe.script", "segoe.ui", "segoe.ui.light", "segoe.ui.semibold", "segoe.ui.semilight", "segoe.ui.symbol", "shonar.bangla", "showcard.gothic", "shruti", "simhei", "simplified.arabic", "simplified.arabic.fixed", "simsun", "simsun.extb", "small.fonts", "snap.itc", "sylfaen", "symbol", "tahoma", "tempus.sans.itc", "terminal", "times.new.roman", "traditional.arabic", "trebuchet.ms", "tunga", "tw.cen.mt", "tw.cen.mt.condensed", "tw.cen.mt.condensed.extra.bold", "utsaah", "vani", "verdana", "vijaya", "viner.hand.itc", "vivaldi", "vladimir.script", "vrinda", "webdings", "wide.latin" ], "rows": 29, "table": true, "tojson": true } ], "_help": [ { "page": "activeSheet", "title": "Get/set active sheet of the workbook", "topics": [ "activeSheet", "activeSheet<-" ] }, { "page": "addCreator", "title": "Add another author to the meta data of the file.", "topics": [ "addCreator" ] }, { "page": "addFilter", "title": "Add column filters", "topics": [ "addFilter" ] }, { "page": "addStyle", "title": "Add a style to a set of cells", "topics": [ "addStyle" ] }, { "page": "addWorksheet", "title": "Add a worksheet to a workbook", "topics": [ "addWorksheet" ] }, { "page": "all.equal", "title": "Check equality of workbooks", "topics": [ "all.equal", "all.equal.Workbook" ] }, { "page": "as.character.formula", "title": "'as.character.formula()'", "topics": [ "as.character.formula" ] }, { "page": "auto_heights", "title": "Compute optimal row heights", "topics": [ "auto_heights" ] }, { "page": "buildWorkbook", "title": "Build Workbook", "topics": [ "buildWorkbook" ] }, { "page": "cloneWorksheet", "title": "Clone a worksheet to a workbook", "topics": [ "cloneWorksheet" ] }, { "page": "col2int", "title": "Convert Excel column to integer", "topics": [ "col2int" ] }, { "page": "conditionalFormat", "title": "Add conditional formatting to cells", "topics": [ "conditionalFormat" ] }, { "page": "conditionalFormatting", "title": "Add conditional formatting to cells", "topics": [ "conditionalFormatting", "databar" ] }, { "page": "convertFromExcelRef", "title": "Convert excel column name to integer index", "topics": [ "convertFromExcelRef" ] }, { "page": "convertToDate", "title": "Convert from excel date number to R Date type", "topics": [ "convertToDate" ] }, { "page": "convertToDateTime", "title": "Convert from excel time number to R POSIXct type.", "topics": [ "convertToDateTime" ] }, { "page": "copyWorkbook", "title": "Copy a Workbook object.", "topics": [ "copyWorkbook" ] }, { "page": "createComment", "title": "create a Comment object", "topics": [ "createComment" ] }, { "page": "NamedRegion", "title": "Create / delete a named region.", "topics": [ "createNamedRegion", "deleteNamedRegion" ] }, { "page": "createStyle", "title": "Create a cell style", "topics": [ "createStyle" ] }, { "page": "createWorkbook", "title": "Create a new Workbook object", "topics": [ "createWorkbook" ] }, { "page": "dataValidation", "title": "Add data validation to cells", "topics": [ "dataValidation" ] }, { "page": "deleteData", "title": "Delete cell data", "topics": [ "deleteData" ] }, { "page": "deleteDataColumn", "title": "Deletes a whole column from a workbook", "topics": [ "deleteDataColumn" ] }, { "page": "freezePane", "title": "Freeze a worksheet pane", "topics": [ "freezePane" ] }, { "page": "get_worksheet_entries", "title": "Get entries from workbook worksheet", "topics": [ "get_worksheet_entries" ] }, { "page": "getBaseFont", "title": "Return the workbook default font", "topics": [ "getBaseFont" ] }, { "page": "getCellRefs", "title": "Return excel cell coordinates from (x,y) coordinates", "topics": [ "getCellRefs" ] }, { "page": "getCreators", "title": "Get the names of the authors from the meta data of the file.", "topics": [ "getCreators" ] }, { "page": "getDateOrigin", "title": "Get the date origin an xlsx file is using", "topics": [ "getDateOrigin" ] }, { "page": "getNamedRegions", "title": "Get named regions", "topics": [ "getNamedRegions" ] }, { "page": "getSheetNames", "title": "Get names of worksheets", "topics": [ "getSheetNames" ] }, { "page": "getStyles", "title": "Returns a list of all styles in the workbook", "topics": [ "getStyles" ] }, { "page": "getTables", "title": "List Excel tables in a workbook", "topics": [ "getTables" ] }, { "page": "groupColumns", "title": "Group columns", "topics": [ "groupColumns" ] }, { "page": "groupRows", "title": "Group Rows", "topics": [ "groupRows" ] }, { "page": "if_null_then", "title": "If NULL then ...", "topics": [ "%||%", "if_null_then" ] }, { "page": "insertImage", "title": "Insert an image into a worksheet", "topics": [ "insertImage" ] }, { "page": "insertPlot", "title": "Insert the current plot into a worksheet", "topics": [ "insertPlot" ] }, { "page": "int2col", "title": "Convert integer to Excel column", "topics": [ "int2col" ] }, { "page": "loadWorkbook", "title": "Load an existing .xlsx file", "topics": [ "loadWorkbook" ] }, { "page": "makeHyperlinkString", "title": "create Excel hyperlink string", "topics": [ "makeHyperlinkString" ] }, { "page": "mergeCells", "title": "Merge cells within a worksheet", "topics": [ "mergeCells" ] }, { "page": "modifyBaseFont", "title": "Modify the default font", "topics": [ "modifyBaseFont" ] }, { "page": "names", "title": "get or set worksheet names", "topics": [ "names", "names.Workbook", "names<-.Workbook" ] }, { "page": "openXL", "title": "Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook", "topics": [ "openXL" ] }, { "page": "openxlsx", "title": "xlsx reading, writing and editing.", "topics": [ "openxlsx-package", "openxlsx" ] }, { "page": "openxlsx_options", "title": "openxlsx Options", "topics": [ "op.openxlsx", "openxlsx_getOp", "openxlsx_options", "openxlsx_setOp" ] }, { "page": "openxlsxFontSizeLookupTable", "title": "Font Size Lookup tables", "topics": [ "openxlsxFontSizeLookupTable", "openxlsxFontSizeLookupTableBold" ] }, { "page": "pageBreak", "title": "add a page break to a worksheet", "topics": [ "pageBreak" ] }, { "page": "pageSetup", "title": "Set page margins, orientation and print scaling", "topics": [ "pageSetup" ] }, { "page": "protectWorkbook", "title": "Protect a workbook from modifications", "topics": [ "protectWorkbook" ] }, { "page": "protectWorksheet", "title": "Protect a worksheet from modifications", "topics": [ "protectWorksheet" ] }, { "page": "read.xlsx", "title": "Read from an Excel file or Workbook object", "topics": [ "read.xlsx" ] }, { "page": "readWorkbook", "title": "Read from an Excel file or Workbook object", "topics": [ "readWorkbook" ] }, { "page": "removeCellMerge", "title": "Create a new Workbook object", "topics": [ "removeCellMerge" ] }, { "page": "removeColWidths", "title": "Remove column widths from a worksheet", "topics": [ "removeColWidths" ] }, { "page": "removeComment", "title": "Remove a comment from a cell", "topics": [ "removeComment" ] }, { "page": "removeFilter", "title": "Remove a worksheet filter", "topics": [ "removeFilter" ] }, { "page": "removeRowHeights", "title": "Remove custom row heights from a worksheet", "topics": [ "removeRowHeights" ] }, { "page": "removeTable", "title": "Remove an Excel table in a workbook", "topics": [ "removeTable" ] }, { "page": "removeWorksheet", "title": "Remove a worksheet from a workbook", "topics": [ "removeWorksheet" ] }, { "page": "renameWorksheet", "title": "Rename a worksheet", "topics": [ "renameWorksheet" ] }, { "page": "replaceStyle", "title": "Replace an existing cell style", "topics": [ "replaceStyle" ] }, { "page": "saveWorkbook", "title": "save Workbook to file", "topics": [ "saveWorkbook" ] }, { "page": "setColWidths", "title": "Set worksheet column widths", "topics": [ "setColWidths" ] }, { "page": "setFooter", "title": "Set footer for all worksheets", "topics": [ "setFooter" ] }, { "page": "setHeader", "title": "Set header for all worksheets", "topics": [ "setHeader" ] }, { "page": "setHeaderFooter", "title": "Set document headers and footers", "topics": [ "setHeaderFooter" ] }, { "page": "setLastModifiedBy", "title": "Set the author who modified the file last.", "topics": [ "setLastModifiedBy" ] }, { "page": "setRowHeights", "title": "Set worksheet row heights", "topics": [ "setRowHeights" ] }, { "page": "setWindowSize", "title": "Set and Get Window Size for xlsx file", "topics": [ "getWindowSize", "setWindowSize" ] }, { "page": "sheets", "title": "Returns names of worksheets.", "topics": [ "sheets" ] }, { "page": "sheetVisibility", "title": "Get/set worksheet visible state", "topics": [ "sheetVisibility", "sheetVisibility<-" ] }, { "page": "sheetVisible", "title": "Get worksheet visible state.", "topics": [ "sheetVisible", "sheetVisible<-" ] }, { "page": "showGridLines", "title": "Set worksheet gridlines to show or hide.", "topics": [ "showGridLines" ] }, { "page": "temp_xlsx", "title": "helper function to create tempory directory for testing purpose", "topics": [ "temp_xlsx" ] }, { "page": "ungroupColumns", "title": "Ungroup Columns", "topics": [ "ungroupColumns" ] }, { "page": "ungroupRows", "title": "Ungroup Rows", "topics": [ "ungroupRows" ] }, { "page": "worksheetOrder", "title": "Order of worksheets in xlsx file", "topics": [ "worksheetOrder", "worksheetOrder<-" ] }, { "page": "write.xlsx", "title": "write data to an xlsx file", "topics": [ "write.xlsx" ] }, { "page": "writeComment", "title": "write a cell comment", "topics": [ "writeComment" ] }, { "page": "writeData", "title": "Write an object to a worksheet", "topics": [ "writeData" ] }, { "page": "writeDataTable", "title": "Write to a worksheet as an Excel table", "topics": [ "writeDataTable" ] }, { "page": "writeFormula", "title": "Write a character vector as an Excel Formula", "topics": [ "writeFormula" ] } ], "_pkglogo": "https://github.com/ycphs/openxlsx/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/ycphs/openxlsx/raw/HEAD/README.md", "_rundeps": [ "Rcpp", "stringi", "zip" ], "_sysdeps": [ { "shlib": "libstdc++", "package": "libstdc++6", "source": "gcc", "version": "14.2.0-4ubuntu2~24.04.1", "name": "c++", "homepage": "http://gcc.gnu.org/", "description": "GNU Standard C++ Library v3" } ], "_vignettes": [ { "source": "Formatting.Rmd", "filename": "Formatting.html", "title": "Formating with xlsx", "author": "Alexander Walker, Philipp Schauberger", "engine": "knitr::rmarkdown", "headings": [ "Formatting with writeData and writeDataTable", "Use of pre-defined table styles", "Date Formatting", "DateTime Formatting", "Conditional Formatting", "Numeric Formatting" ], "created": "2020-08-11 19:28:24", "modified": "2024-08-30 08:34:50", "commits": 4 }, { "source": "Introduction.Rmd", "filename": "Introduction.html", "title": "Introduction", "author": "Alexander Walker, Philipp Schauberger", "engine": "knitr::rmarkdown", "headings": [ "Basic Examples", "write.xlsx", "write list of data.frames to xlsx-file", "write.xlsx also accepts styling parameters", "The simplest way is to set default options and set column class", "Workbook styles", "define a style for column headers", "When writing a list, the stylings will apply to all list elements", "write.xlsx returns the workbook object for further editing", "Workbook creation walk-through", "create workbook and set default border Colour and style", "Add Sheets", "write data to sheet 1", "write data to sheet 2", "add write group means", "add write group variances", "add style mean & variance table headers", "save workbook", "Gallery", "Further Examples", "Stock Price", "Image Compression using PCA" ], "created": "2020-08-11 19:28:24", "modified": "2024-08-11 13:03:21", "commits": 5 } ], "_score": 18.620105948097567, "_indexed": true, "_nocasepkg": "openxlsx", "_universes": [ "ycphs", "janmarvin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "4.2.8.1", "date": "2026-05-27T07:38:24.000Z", "distro": "noble", "arch": "aarch64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "16fa6ced9b14613688664c23fea402138a764f197dc677f44bf065c8117ac8c1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.7.0", "os": "linux", "version": "4.2.8.1", "date": "2026-05-27T07:38:25.000Z", "distro": "noble", "arch": "x86_64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "0d6c73dc39a8d2103a1af525b44d3b20461152d119ad9786abf96a37fbe7ce48", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.6.0", "os": "linux", "version": "4.2.8.1", "date": "2026-05-27T07:38:12.000Z", "distro": "noble", "arch": "aarch64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "da3cb798745ad98dbb5ab86e18f8e69f901bd444e25c94e984a3b5a4ae3cae81", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.6.0", "os": "linux", "version": "4.2.8.1", "date": "2026-05-27T07:38:46.000Z", "distro": "noble", "arch": "x86_64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "164cc1d4d583a866790a57c463932919a8287f693f1a68d28d87aa0544749a06", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.5.3", "os": "mac", "version": "4.2.8.1", "date": "2026-05-27T07:40:30.000Z", "arch": "aarch64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "82d3905d21d7a216f8c90127c87d79fc851e51e53c00073eb63032399a6d88d2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.5.3", "os": "mac", "version": "4.2.8.1", "date": "2026-05-27T07:41:12.000Z", "arch": "x86_64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "887a0f3ce0efb10fb465f55e4f9f9641914c3bdcc7a46f65f13abb8c30996cf7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.6.0", "os": "mac", "version": "4.2.8.1", "date": "2026-05-27T07:39:19.000Z", "arch": "aarch64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "17c73fff90ce46789ac24c2ca340590181d500ca3fbe380e86352fb897454558", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.6.0", "os": "mac", "version": "4.2.8.1", "date": "2026-05-27T07:41:00.000Z", "arch": "x86_64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "4710ec1d505d8531d1f18490885d290b0ab8f3ad655af3be6b17baecaf59303d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.6.0", "os": "wasm", "version": "4.2.8.1", "date": "2026-05-27T07:38:22.000Z", "arch": "emscripten", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "088113a131f3d80fde66d0b35787a1e0347a18137d98787921911666a76e870e", "status": "success", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.7.0", "os": "win", "version": "4.2.8.1", "date": "2026-05-27T07:37:34.000Z", "arch": "x86_64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "8c65ff774eca0c8fc54978d91597e5965c42d03e2c9085212285af4e01de5206", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.5.3", "os": "win", "version": "4.2.8.1", "date": "2026-05-27T07:37:28.000Z", "arch": "x86_64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "d0de5870110e0a2f78306c5af08c950c4695d28829a3a34a42e4c6778f3d2f15", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" }, { "r": "4.6.0", "os": "win", "version": "4.2.8.1", "date": "2026-05-27T07:37:44.000Z", "arch": "x86_64", "commit": "2ec82a0d60703b37b786016e37f28e6d8bfcd416", "fileid": "904d5c6f7923e62f2be63431f2c2753b661e9324297703c6c365644aa43c4d45", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ycphs/actions/runs/26497417164" } ] }