{ "_id": "6a27af9a24555f66ed535202", "Package": "XLConnect", "Type": "Package", "Title": "Excel Connector for R", "Version": "1.3.1.9999", "Authors@R": "c(person(\"Mirai Solutions GmbH\", role = \"aut\",\nemail = \"xlconnect@mirai-solutions.com\"),\nperson(\"Martin\", \"Studer\", role = \"cre\",\nemail = \"martin.studer@mirai-solutions.com\",\ncomment = c(ORCID = \"0009-0004-8250-7303\")),\nperson(\"The Apache Software Foundation\", role = c(\"ctb\", \"cph\"),\ncomment = \"Apache POI\"),\nperson(\"Graph Builder\", role = c(\"ctb\", \"cph\"),\ncomment = \"Curvesapi Java library\"),\nperson(\"Brett Woolridge\", role = c(\"ctb\", \"cph\"),\ncomment = \"SparseBitSet Java library\"))", "URL": "https://mirai-solutions.ch\nhttps://github.com/miraisolutions/xlconnect", "BugReports": "https://github.com/miraisolutions/xlconnect/issues", "SystemRequirements": "Java (>= 8)", "Description": "Provides comprehensive functionality to read, write and\nformat Excel data.", "License": "GPL-3", "Copyright": "See file COPYRIGHTS", "LazyData": "yes", "Config/testthat/edition": "3", "Config/pak/sysreqs": "make default-jdk", "Repository": "https://miraisolutions.r-universe.dev", "Date/Publication": "2026-03-10 08:59:40 UTC", "RemoteUrl": "https://github.com/miraisolutions/xlconnect", "RemoteRef": "HEAD", "RemoteSha": "9e54f8efc3071b788c45752ddde610611150d145", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-08 07:59:52 UTC", "User": "root" }, "Author": "Mirai Solutions GmbH [aut],\nMartin Studer [cre] (ORCID: ),\nThe Apache Software Foundation [ctb, cph] (Apache POI),\nGraph Builder [ctb, cph] (Curvesapi Java library),\nBrett Woolridge [ctb, cph] (SparseBitSet Java library)", "Maintainer": "Martin Studer ", "MD5sum": "8984a6d56450b602edf94f08309b60aa", "_user": "miraisolutions", "_type": "src", "_file": "XLConnect_1.3.1.9999.tar.gz", "_fileid": "b3a207d5b9edd95f3c0da9ef53398aae08911cd3c43f08e9643eadb94ca58b27", "_filesize": 2332204, "_sha256": "b3a207d5b9edd95f3c0da9ef53398aae08911cd3c43f08e9643eadb94ca58b27", "_created": "2026-06-08T07:59:52.000Z", "_published": "2026-06-09T06:15:54.935Z", "_distro": "noble", "_jobs": [ { "job": 80256779787, "time": 162, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7474556503" }, { "job": 80256779767, "time": 226, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7474572766" }, { "job": 80256779252, "time": 161, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7499880463" }, { "job": 80256779244, "time": 243, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7499679873" }, { "job": 80256779505, "time": 293, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7474503148" }, { "job": 80256779677, "time": 127, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7474545757" }, { "job": 80256779486, "time": 203, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7474569859" }, { "job": 80256779278, "time": 246, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7499547860" }, { "job": 80256779290, "time": 192, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7499535910" } ], "_buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/miraisolutions/xlconnect", "_commit": { "id": "9e54f8efc3071b788c45752ddde610611150d145", "author": "Martin Studer ", "committer": "Martin Studer ", "message": "Set development version\n", "time": 1773133180 }, "_maintainer": { "name": "Martin Studer", "email": "martin.studer@mirai-solutions.com", "login": "martinstuder", "linkedin": "in/mastuder", "description": "", "uuid": 1091843 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.6.0", "role": "Depends" }, { "package": "methods", "role": "Imports" }, { "package": "rJava", "version": ">= 1.0-1", "role": "Imports" }, { "package": "lattice", "role": "Suggests" }, { "package": "ggplot2", "version": ">= 0.9.3", "role": "Suggests" }, { "package": "zoo", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "miraisolutions", "_selfowned": true, "_usedby": 2, "_updates": [ { "week": "2025-23", "n": 2 }, { "week": "2025-36", "n": 3 }, { "week": "2025-43", "n": 1 }, { "week": "2025-48", "n": 1 }, { "week": "2025-49", "n": 3 }, { "week": "2026-09", "n": 1 }, { "week": "2026-11", "n": 1 } ], "_tags": [ { "name": "1.3.0", "date": "2026-02-24" } ], "_topics": [ "cross-platform", "excel", "r-language", "xlconnect", "openjdk" ], "_stars": 131, "_contributors": [ { "user": "spoltier", "count": 212, "uuid": 19765083 }, { "user": "martinstuder", "count": 135, "uuid": 1091843 }, { "user": "rolandasc", "count": 25, "uuid": 8598957 }, { "user": "themel", "count": 4, "uuid": 160316 }, { "user": "lambiase", "count": 1, "uuid": 3520786 } ], "_userbio": { "uuid": 3518285, "type": "organization", "name": "Mirai Solutions GmbH", "description": "open-source software, utilities, guides, best practices" }, "_downloads": { "count": 5445, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/XLConnect" }, "_mentions": 8, "_devurl": "https://github.com/miraisolutions/xlconnect", "_searchresults": 1680, "_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/XLConnect.html", "manual.pdf" ], "_homeurl": "https://github.com/miraisolutions/xlconnect", "_realowner": "miraisolutions", "_cranurl": true, "_releases": [ { "version": "0.1-3", "date": "2011-02-27" }, { "version": "0.1-4", "date": "2011-05-26" }, { "version": "0.1-5", "date": "2011-07-07" }, { "version": "0.1-7", "date": "2011-10-20" }, { "version": "0.1-8", "date": "2012-02-11" }, { "version": "0.1-9", "date": "2012-03-09" }, { "version": "0.2-0", "date": "2012-07-20" }, { "version": "0.2-1", "date": "2012-08-17" }, { "version": "0.2-2", "date": "2012-10-15" }, { "version": "0.2-3", "date": "2012-11-05" }, { "version": "0.2-4", "date": "2013-02-02" }, { "version": "0.2-5", "date": "2013-03-18" }, { "version": "0.2-6", "date": "2013-12-31" }, { "version": "0.2-7", "date": "2014-01-03" }, { "version": "0.2-8", "date": "2014-08-06" }, { "version": "0.2-9", "date": "2014-08-14" }, { "version": "0.2-10", "date": "2015-01-25" }, { "version": "0.2-11", "date": "2015-03-01" }, { "version": "0.2-12", "date": "2016-06-24" }, { "version": "0.2-13", "date": "2017-05-14" }, { "version": "0.2-14", "date": "2018-01-23" }, { "version": "0.2-15", "date": "2018-04-05" }, { "version": "1.0.0", "date": "2020-03-20" }, { "version": "1.0.1", "date": "2020-03-23" }, { "version": "1.0.2", "date": "2021-02-15" }, { "version": "1.0.3", "date": "2021-04-11" }, { "version": "1.0.4", "date": "2021-07-29" }, { "version": "1.0.5", "date": "2021-10-01" }, { "version": "1.0.6", "date": "2022-10-21" }, { "version": "1.0.7", "date": "2023-01-24" }, { "version": "1.0.8", "date": "2024-01-30" }, { "version": "1.0.9", "date": "2024-04-17" }, { "version": "1.0.10", "date": "2024-04-30" }, { "version": "1.1.0", "date": "2024-08-26" }, { "version": "1.2.0", "date": "2025-02-18" }, { "version": "1.2.1", "date": "2025-04-29" }, { "version": "1.2.2", "date": "2025-05-27" }, { "version": "1.3.0", "date": "2026-02-24" } ], "_exports": [ "addImage", "appendNamedRegion", "appendWorksheet", "aref", "aref2idx", "clearNamedRegion", "clearRange", "clearRangeFromReference", "clearSheet", "cloneSheet", "col2idx", "configurePOI", "createCellStyle", "createFreezePane", "createName", "createSheet", "createSplitPane", "cref2idx", "existsCellStyle", "existsName", "existsSheet", "extractSheetName", "getActiveSheetIndex", "getActiveSheetName", "getBoundingBox", "getCellFormula", "getCellStyle", "getCellStyleForType", "getDefinedNames", "getForceFormulaRecalculation", "getLastColumn", "getLastRow", "getOrCreateCellStyle", "getReferenceCoordinates", "getReferenceCoordinatesForName", "getReferenceCoordinatesForTable", "getReferenceFormula", "getSheetPos", "getSheets", "getTables", "hideSheet", "idx2aref", "idx2col", "idx2cref", "isSheetHidden", "isSheetVeryHidden", "isSheetVisible", "loadWorkbook", "mergeCells", "mirai", "normalizeDataframe", "onErrorCell", "print", "readNamedRegion", "readNamedRegionFromFile", "readTable", "readWorksheet", "readWorksheetFromFile", "removeName", "removePane", "removeSheet", "renameSheet", "saveWorkbook", "setActiveSheet", "setAutoFilter", "setBorder", "setCellFormula", "setCellStyle", "setCellStyleForType", "setColumnWidth", "setDataFormat", "setDataFormatForType", "setFillBackgroundColor", "setFillForegroundColor", "setFillPattern", "setForceFormulaRecalculation", "setHyperlink", "setMissingValue", "setRowHeight", "setSheetColor", "setSheetPos", "setStyleAction", "setStyleNamePrefix", "setWrapText", "show", "summary", "unhideSheet", "unmergeCells", "writeNamedRegion", "writeNamedRegionToFile", "writeWorksheet", "writeWorksheetToFile", "XLC", "xlcDump", "xlcEdit", "xlcFreeMemory", "xlcMemoryReport", "xlcRestore" ], "_datasets": [ { "name": "swissfranc", "title": "Historical Exchange Rates: CHF vs EUR, USD and GBP", "object": "swissfranc", "class": [ "data.frame" ], "fields": [ "Date", "EUR", "USD", "GBP" ], "rows": 420, "table": true, "tojson": true } ], "_help": [ { "page": "XLConnect-package", "title": "Excel Connector for R", "topics": [ "XLConnect-package", "XLConnect" ] }, { "page": "dollar-methods", "title": "Executing workbook methods in object$method(...) form", "topics": [ "$", "$,cellstyle-method", "$,workbook-method", "$-methods" ] }, { "page": "addImage-methods", "title": "Adding images to a worksheet", "topics": [ "addImage", "addImage,workbook-method", "addImage-methods" ] }, { "page": "appendNamedRegion-methods", "title": "Appending data to a named region", "topics": [ "appendNamedRegion", "appendNamedRegion,workbook,ANY-method", "appendNamedRegion,workbook-method", "appendNamedRegion-methods" ] }, { "page": "appendWorksheet-methods", "title": "Appending data to worksheets", "topics": [ "appendWorksheet", "appendWorksheet,workbook,ANY,character-method", "appendWorksheet,workbook,ANY,numeric-method", "appendWorksheet-methods" ] }, { "page": "aref", "title": "Constructing Excel area references", "topics": [ "aref" ] }, { "page": "aref2idx", "title": "Converting Excel cell references to row and column based cell references", "topics": [ "aref2idx" ] }, { "page": "cellstyle-class", "title": "Class \"cellstyle\"", "topics": [ "cellstyle-class" ] }, { "page": "clearNamedRegion-methods", "title": "Clearing named regions in a workbook", "topics": [ "clearNamedRegion", "clearNamedRegion,workbook,character-method", "clearNamedRegion-methods" ] }, { "page": "clearRange-methods", "title": "Clearing cell ranges in a workbook", "topics": [ "clearRange", "clearRange,workbook,character-method", "clearRange,workbook,numeric-method", "clearRange-methods" ] }, { "page": "clearRangeFromReference-methods", "title": "Clearing cell ranges in a workbook", "topics": [ "clearRangeFromReference", "clearRangeFromReference,workbook,character-method", "clearRangeFromReference-methods" ] }, { "page": "clearSheet-methods", "title": "Clearing worksheets in a workbook", "topics": [ "clearSheet", "clearSheet,workbook,character-method", "clearSheet,workbook,numeric-method", "clearSheet-methods" ] }, { "page": "cloneSheet-methods", "title": "Cloning/copying worksheets", "topics": [ "cloneSheet", "cloneSheet,workbook,character-method", "cloneSheet,workbook,numeric-method", "cloneSheet-methods" ] }, { "page": "col2idx", "title": "Converting Excel column names to indices", "topics": [ "col2idx" ] }, { "page": "configurePOI", "title": "Configuring Apache POI", "topics": [ "configurePOI" ] }, { "page": "createCellStyle-methods", "title": "Creating custom named and anonymous cell styles", "topics": [ "createCellStyle", "createCellStyle,workbook,character-method", "createCellStyle,workbook,missing-method", "createCellStyle-methods" ] }, { "page": "createFreezePane-methods", "title": "Creating a freeze pane on a worksheet", "topics": [ "createFreezePane", "createFreezePane,workbook,character-method", "createFreezePane,workbook,numeric-method", "createFreezePane-methods" ] }, { "page": "createName-methods", "title": "Creating names in a workbook", "topics": [ "createName", "createName,workbook-method", "createName-methods" ] }, { "page": "createSheet-methods", "title": "Creating worksheets in a workbook", "topics": [ "createSheet", "createSheet,workbook-method", "createSheet-methods" ] }, { "page": "createSplitPane-methods", "title": "Creating a split pane on a worksheet", "topics": [ "createSplitPane", "createSplitPane,workbook,character-method", "createSplitPane,workbook,numeric-method", "createSplitPane-methods" ] }, { "page": "cref2idx", "title": "Converting Excel cell references to indices", "topics": [ "cref2idx" ] }, { "page": "existsCellStyle-methods", "title": "Retrieving named cell styles", "topics": [ "existsCellStyle", "existsCellStyle,workbook-method", "existsCellStyle-methods" ] }, { "page": "existsName-methods", "title": "Checking existence of named ranges in a workbook", "topics": [ "existsName", "existsName,workbook-method", "existsName-methods" ] }, { "page": "existsSheet-methods", "title": "Checking for existence of worksheets in a workbook", "topics": [ "existsSheet", "existsSheet,workbook-method", "existsSheet-methods" ] }, { "page": "extraction-methods", "title": "Workbook data extraction & replacement operators", "topics": [ "[", "[,workbook-method", "[-methods", "[<-", "[<-,workbook-method", "[<--methods", "[[", "[[,workbook-method", "[[-methods", "[[<-", "[[<-,workbook-method", "[[<--methods" ] }, { "page": "extractSheetName", "title": "Extracting the sheet name from a formula", "topics": [ "extractSheetName" ] }, { "page": "getActiveSheetIndex-methods", "title": "Querying the active worksheet index", "topics": [ "getActiveSheetIndex", "getActiveSheetIndex,workbook-method", "getActiveSheetIndex-methods" ] }, { "page": "getActiveSheetName-methods", "title": "Querying the active worksheet name", "topics": [ "getActiveSheetName", "getActiveSheetName,workbook-method", "getActiveSheetName-methods" ] }, { "page": "getBoundingBox-methods", "title": "Querying the coordinates of a worksheet bounding box", "topics": [ "getBoundingBox", "getBoundingBox,workbook,character-method", "getBoundingBox,workbook,numeric-method", "getBoundingBox-methods" ] }, { "page": "getCellFormula-methods", "title": "Retrieving formula definitions from cells", "topics": [ "getCellFormula", "getCellFormula,workbook,character-method", "getCellFormula,workbook,numeric-method", "getCellFormula-methods" ] }, { "page": "getCellStyle-methods", "title": "Retrieving named cell styles", "topics": [ "getCellStyle", "getCellStyle,workbook-method", "getCellStyle-methods" ] }, { "page": "getCellStyleForType-methods", "title": "Querying the cell style per data type for the DATATYPE style action", "topics": [ "getCellStyleForType", "getCellStyleForType,workbook-method", "getCellStyleForType-methods" ] }, { "page": "getDefinedNames-methods", "title": "Retrieving defined names in a workbook", "topics": [ "getDefinedNames", "getDefinedNames,workbook-method", "getDefinedNames-methods" ] }, { "page": "getForceFormulaRecalculation-methods", "title": "Querying the coordinates of the range reference by an Excel name", "topics": [ "getForceFormulaRecalculation", "getForceFormulaRecalculation,workbook,character-method", "getForceFormulaRecalculation,workbook,numeric-method", "getForceFormulaRecalculation-methods" ] }, { "page": "getLastColumn-methods", "title": "Querying the last (non-empty) column on a worksheet", "topics": [ "getLastColumn", "getLastColumn,workbook,character-method", "getLastColumn,workbook,numeric-method", "getLastColumn-methods" ] }, { "page": "getLastRow-methods", "title": "Querying the last (non-empty) row on a worksheet", "topics": [ "getLastRow", "getLastRow,workbook,character-method", "getLastRow,workbook,numeric-method", "getLastRow-methods" ] }, { "page": "getOrCreateCellStyle-methods", "title": "Retrieving or creating named cell styles", "topics": [ "getOrCreateCellStyle", "getOrCreateCellStyle,workbook,character-method", "getOrCreateCellStyle-methods" ] }, { "page": "getReferenceCoordinates-methods", "title": "Querying the coordinates of the range reference by an Excel name", "topics": [ "getReferenceCoordinates", "getReferenceCoordinates,workbook-method", "getReferenceCoordinates-methods" ] }, { "page": "getReferenceCoordinatesForName-methods", "title": "Querying the coordinates of the range reference by an Excel name", "topics": [ "getReferenceCoordinatesForName", "getReferenceCoordinatesForName,workbook-method", "getReferenceCoordinatesForName-methods" ] }, { "page": "getReferenceCoordinatesForTable-methods", "title": "Querying the coordinates of the range of an Excel table", "topics": [ "getReferenceCoordinatesForTable", "getReferenceCoordinatesForTable,workbook,character-method", "getReferenceCoordinatesForTable,workbook,numeric-method", "getReferenceCoordinatesForTable-methods" ] }, { "page": "getReferenceFormula-methods", "title": "Querying reference formulas of Excel names", "topics": [ "getReferenceFormula", "getReferenceFormula,workbook-method", "getReferenceFormula-methods" ] }, { "page": "getSheetPos-methods", "title": "Querying worksheet position", "topics": [ "getSheetPos", "getSheetPos,workbook,character-method", "getSheetPos-methods" ] }, { "page": "getSheets-methods", "title": "Querying available worksheets in a workbook", "topics": [ "getSheets", "getSheets,workbook-method", "getSheets-methods" ] }, { "page": "getTables-methods", "title": "Querying available Excel tables in a workbook", "topics": [ "getTables", "getTables,workbook,character-method", "getTables,workbook,numeric-method", "getTables-methods" ] }, { "page": "hideSheet-methods", "title": "Hiding worksheets in a workbook", "topics": [ "hideSheet", "hideSheet,workbook,character-method", "hideSheet,workbook,numeric-method", "hideSheet-methods" ] }, { "page": "idx2aref", "title": "Converting row and column based area references to Excel area references", "topics": [ "idx2aref" ] }, { "page": "idx2col", "title": "Converting column indices to Excel column names", "topics": [ "idx2col" ] }, { "page": "idx2cref", "title": "Converting indices to Excel cell references", "topics": [ "idx2cref" ] }, { "page": "isSheetHidden-methods", "title": "Checking if worksheets are hidden in a workbook", "topics": [ "isSheetHidden", "isSheetHidden,workbook,character-method", "isSheetHidden,workbook,numeric-method", "isSheetHidden-methods" ] }, { "page": "isSheetVeryHidden-methods", "title": "Checking if worksheets are very hidden in a workbook", "topics": [ "isSheetVeryHidden", "isSheetVeryHidden,workbook,character-method", "isSheetVeryHidden,workbook,numeric-method", "isSheetVeryHidden-methods" ] }, { "page": "isSheetVisible-methods", "title": "Checking if worksheets are visible in a workbook", "topics": [ "isSheetVisible", "isSheetVisible,workbook,character-method", "isSheetVisible,workbook,numeric-method", "isSheetVisible-methods" ] }, { "page": "loadWorkbook", "title": "Loading Microsoft Excel workbooks", "topics": [ "loadWorkbook" ] }, { "page": "mergeCells-methods", "title": "Merging cells", "topics": [ "mergeCells", "mergeCells,workbook,character-method", "mergeCells,workbook,numeric-method", "mergeCells-methods" ] }, { "page": "mirai", "title": "Mirai Solutions GmbH", "topics": [ "mirai" ] }, { "page": "onErrorCell-methods", "title": "Behavior when error cells are detected", "topics": [ "onErrorCell", "onErrorCell,workbook-method", "onErrorCell-methods" ] }, { "page": "print-methods", "title": "Print a workbook's filename", "topics": [ "print", "print,workbook-method", "print-methods" ] }, { "page": "readNamedRegion-methods", "title": "Reading named regions from a workbook", "topics": [ "readNamedRegion", "readNamedRegion,workbook-method", "readNamedRegion-methods" ] }, { "page": "readNamedRegionFromFile", "title": "Reading named regions from an Excel file (wrapper function)", "topics": [ "readNamedRegionFromFile" ] }, { "page": "readTable-methods", "title": "Reading Excel tables from a workbook", "topics": [ "readTable", "readTable,workbook,character-method", "readTable,workbook,numeric-method", "readTable-methods" ] }, { "page": "readWorksheet-methods", "title": "Reading data from worksheets", "topics": [ "readWorksheet", "readWorksheet,workbook,character-method", "readWorksheet,workbook,numeric-method", "readWorksheet-methods" ] }, { "page": "readWorksheetFromFile", "title": "Reading data from worksheets in an Excel file (wrapper function)", "topics": [ "readWorksheetFromFile" ] }, { "page": "removeName-methods", "title": "Removing names from workbooks", "topics": [ "removeName", "removeName,workbook-method", "removeName-methods" ] }, { "page": "removePane-methods", "title": "Removing panes from worksheet", "topics": [ "removePane", "removePane,workbook,character-method", "removePane,workbook,numeric-method", "removePane-methods" ] }, { "page": "removeSheet-methods", "title": "Removing worksheets from workbooks", "topics": [ "removeSheet", "removeSheet,workbook,character-method", "removeSheet,workbook,numeric-method", "removeSheet-methods" ] }, { "page": "renameSheet-methods", "title": "Renaming worksheets from workbooks", "topics": [ "renameSheet", "renameSheet,workbook,character-method", "renameSheet,workbook,numeric-method", "renameSheet-methods" ] }, { "page": "saveWorkbook-methods", "title": "Saving Microsoft Excel workbooks", "topics": [ "saveWorkbook", "saveWorkbook,workbook,character-method", "saveWorkbook,workbook,missing-method", "saveWorkbook-methods" ] }, { "page": "setActiveSheet-methods", "title": "Setting the active worksheet in a workbook", "topics": [ "setActiveSheet", "setActiveSheet,workbook,character-method", "setActiveSheet,workbook,numeric-method", "setActiveSheet-methods" ] }, { "page": "setAutoFilter-methods", "title": "Setting auto-filters on worksheets", "topics": [ "setAutoFilter", "setAutoFilter,workbook,character-method", "setAutoFilter,workbook,numeric-method", "setAutoFilter-methods" ] }, { "page": "setBorder-methods", "title": "Specifying borders for cell styles", "topics": [ "setBorder", "setBorder,cellstyle-method", "setBorder-methods" ] }, { "page": "setCellFormula-methods", "title": "Setting cell formulas", "topics": [ "setCellFormula", "setCellFormula,workbook,character-method", "setCellFormula,workbook,numeric-method", "setCellFormula-methods" ] }, { "page": "setCellStyle-methods", "title": "Setting cell styles", "topics": [ "setCellStyle", "setCellStyle,workbook,character,missing-method", "setCellStyle,workbook,missing,character-method", "setCellStyle,workbook,missing,numeric-method", "setCellStyle-methods" ] }, { "page": "setCellStyleForType-methods", "title": "Setting the cell style per data type for the DATATYPE style action", "topics": [ "setCellStyleForType", "setCellStyleForType,workbook-method", "setCellStyleForType-methods" ] }, { "page": "setColumnWidth-methods", "title": "Setting the width of a column in a worksheet", "topics": [ "setColumnWidth", "setColumnWidth,workbook,character-method", "setColumnWidth,workbook,numeric-method", "setColumnWidth-methods" ] }, { "page": "setDataFormat-methods", "title": "Specifying custom data formats for cell styles", "topics": [ "setDataFormat", "setDataFormat,cellstyle-method", "setDataFormat-methods" ] }, { "page": "setDataFormatForType-methods", "title": "Setting the data format for the DATA_FORMAT_ONLY style action", "topics": [ "setDataFormatForType", "setDataFormatForType,workbook-method", "setDataFormatForType-methods" ] }, { "page": "setFillBackgroundColor-methods", "title": "Specifying the fill background color for cell styles", "topics": [ "setFillBackgroundColor", "setFillBackgroundColor,cellstyle,numeric-method", "setFillBackgroundColor-methods" ] }, { "page": "setFillForegroundColor-methods", "title": "Specifying the fill foreground color for cell styles", "topics": [ "setFillForegroundColor", "setFillForegroundColor,cellstyle,numeric-method", "setFillForegroundColor-methods" ] }, { "page": "setFillPattern-methods", "title": "Specifying the fill pattern for cell styles", "topics": [ "setFillPattern", "setFillPattern,cellstyle-method", "setFillPattern-methods" ] }, { "page": "setForceFormulaRecalculation-methods", "title": "Forcing Excel to recalculate formula values when opening a workbook", "topics": [ "setForceFormulaRecalculation", "setForceFormulaRecalculation,workbook,character-method", "setForceFormulaRecalculation,workbook,numeric-method", "setForceFormulaRecalculation-methods" ] }, { "page": "setHyperlink-methods", "title": "Setting hyperlinks", "topics": [ "setHyperlink", "setHyperlink,workbook,character,missing-method", "setHyperlink,workbook,missing,character-method", "setHyperlink,workbook,missing,numeric-method", "setHyperlink-methods" ] }, { "page": "setMissingValue-methods", "title": "Setting missing value identifiers", "topics": [ "setMissingValue", "setMissingValue,workbook,ANY-method", "setMissingValue,workbook-method", "setMissingValue-methods" ] }, { "page": "setRowHeight-methods", "title": "Setting the height of a row in a worksheet", "topics": [ "setRowHeight", "setRowHeight,workbook,character-method", "setRowHeight,workbook,numeric-method", "setRowHeight-methods" ] }, { "page": "setSheetColor-methods", "title": "Setting colors on worksheet tabs", "topics": [ "setSheetColor", "setSheetColor,workbook,character-method", "setSheetColor,workbook,numeric-method", "setSheetColor-methods" ] }, { "page": "setSheetPos-methods", "title": "Setting worksheet position", "topics": [ "setSheetPos", "setSheetPos,workbook,character,missing-method", "setSheetPos,workbook,character,numeric-method", "setSheetPos-methods" ] }, { "page": "setStyleAction-methods", "title": "Controlling application of cell styles when writing data to Excel", "topics": [ "setStyleAction", "setStyleAction,workbook-method", "setStyleAction-methods" ] }, { "page": "setStyleNamePrefix-methods", "title": "Setting the style name prefix for the \"name prefix\" style action", "topics": [ "setStyleNamePrefix", "setStyleNamePrefix,workbook-method", "setStyleNamePrefix-methods" ] }, { "page": "setWrapText-methods", "title": "Specifying text wrapping behaviour", "topics": [ "setWrapText", "setWrapText,cellstyle-method", "setWrapText-methods" ] }, { "page": "show-methods", "title": "Display a workbook object", "topics": [ "show", "show,workbook-method", "show-methods" ] }, { "page": "summary-methods", "title": "Summarizing workbook objects", "topics": [ "summary", "summary,workbook-method", "summary-methods" ] }, { "page": "swissfranc", "title": "Historical Exchange Rates: CHF vs EUR, USD and GBP", "topics": [ "swissfranc" ] }, { "page": "unhideSheet-methods", "title": "Unhiding worksheets in a workbook", "topics": [ "unhideSheet", "unhideSheet,workbook,character-method", "unhideSheet,workbook,numeric-method", "unhideSheet-methods" ] }, { "page": "unmergeCells-methods", "title": "Unmerging cells", "topics": [ "unmergeCells", "unmergeCells,workbook,character-method", "unmergeCells,workbook,numeric-method", "unmergeCells-methods" ] }, { "page": "with.workbook", "title": "Evaluate an R expression in a workbook environment", "topics": [ "with.workbook" ] }, { "page": "workbook-class", "title": "Class \"workbook\"", "topics": [ "workbook-class" ] }, { "page": "writeNamedRegion-methods", "title": "Writing named regions to a workbook", "topics": [ "writeNamedRegion", "writeNamedRegion,workbook,ANY-method", "writeNamedRegion,workbook-method", "writeNamedRegion-methods" ] }, { "page": "writeNamedRegionToFile", "title": "Writing named regions to an Excel file (wrapper function)", "topics": [ "writeNamedRegionToFile" ] }, { "page": "writeWorksheet-methods", "title": "Writing data to worksheets", "topics": [ "writeWorksheet", "writeWorksheet,workbook,ANY,character-method", "writeWorksheet,workbook,ANY,numeric-method", "writeWorksheet-methods" ] }, { "page": "writeWorksheetToFile", "title": "Writing data to worksheets in an Excel file (wrapper function)", "topics": [ "writeWorksheetToFile" ] }, { "page": "XLC", "title": "XLConnect Constants", "topics": [ "XLC" ] }, { "page": "xlcDump", "title": "Dumping data sets to Excel files", "topics": [ "xlcDump" ] }, { "page": "xlcEdit", "title": "Editing data sets in an Excel file editor", "topics": [ "xlcEdit" ] }, { "page": "xlcFreeMemory", "title": "Freeing Java Virtual Machine memory", "topics": [ "xlcFreeMemory" ] }, { "page": "xlcMemoryReport", "title": "Reporting free Java Virtual Machine memory", "topics": [ "xlcMemoryReport" ] }, { "page": "XLConnect-deprecated", "title": "Deprecated functions in package 'XLConnect'", "topics": [ "XLConnect-deprecated" ] }, { "page": "xlcRestore", "title": "Restoring objects from Excel files", "topics": [ "xlcRestore" ] } ], "_pkglogo": "https://github.com/miraisolutions/xlconnect/raw/HEAD/man/figures/logo.png", "_rundeps": [ "rJava" ], "_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": "XLConnect.Rnw", "filename": "XLConnect.pdf", "title": "The XLConnect Package", "engine": "utils::Sweave", "headings": [ "Introduction", "Installation", "Basic Usage and Examples", "Advanced Usage and Examples", "What's new in XLConnect version 1.3.1.9999", "Frequently Asked Questions", "Contact and Support", "Further Resources and References" ], "created": "2013-11-13 20:49:20", "modified": "2024-08-21 11:18:22", "commits": 20 }, { "source": "XLConnectImpatient.Rnw", "filename": "XLConnectImpatient.pdf", "title": "XLConnect for the Impatient", "engine": "utils::Sweave", "headings": [], "created": "2013-11-13 20:49:20", "modified": "2021-12-30 20:03:24", "commits": 8 } ], "_score": 11.508007725855208, "_indexed": true, "_nocasepkg": "xlconnect", "_universes": [ "miraisolutions", "martinstuder" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.3.1.9999", "date": "2026-06-08T08:03:34.000Z", "distro": "noble", "commit": "9e54f8efc3071b788c45752ddde610611150d145", "fileid": "c2eb0b76d00f5e5620414742a6c8d390ad1256a4c6c2f2b8de19e64304879660", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379" }, { "r": "4.6.0", "os": "linux", "version": "1.3.1.9999", "date": "2026-06-08T08:04:16.000Z", "distro": "noble", "commit": "9e54f8efc3071b788c45752ddde610611150d145", "fileid": "474d722e4288f93817c6dd7184f0f84251c72a6d8a9ea1484e193f041f69b118", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379" }, { "r": "4.5.3", "os": "mac", "version": "1.3.1.9999", "date": "2026-06-09T06:14:45.000Z", "commit": "9e54f8efc3071b788c45752ddde610611150d145", "fileid": "c3232f987fbc4bfc10f1b8eff839ce95f08d7182dd4962207fc547f2e74ecd83", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379" }, { "r": "4.6.0", "os": "mac", "version": "1.3.1.9999", "date": "2026-06-09T06:00:56.000Z", "commit": "9e54f8efc3071b788c45752ddde610611150d145", "fileid": "1bbe3b619059a6f15b2a114dc68bd313399c61380356bb6e3eb8aab581a87bbb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379" }, { "r": "4.6.0", "os": "wasm", "version": "1.3.1.9999", "date": "2026-06-08T08:03:39.000Z", "commit": "9e54f8efc3071b788c45752ddde610611150d145", "fileid": "cd64b296e70b8e5613d92a091b167c4a7c20bc5e5c58e49bdbb629250cfd6472", "status": "success", "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379" }, { "r": "4.7.0", "os": "win", "version": "1.3.1.9999", "date": "2026-06-08T08:02:31.000Z", "commit": "9e54f8efc3071b788c45752ddde610611150d145", "fileid": "c2c414eed4e457a2fe81b1fb54ffbcf1350c088efdb34a2a61a034aeb42408b2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379" }, { "r": "4.5.3", "os": "win", "version": "1.3.1.9999", "date": "2026-06-09T05:49:35.000Z", "commit": "9e54f8efc3071b788c45752ddde610611150d145", "fileid": "bf3d6abab8351e307176ba170bdf0adbc8192ad70801fea7d5ff1a40cf7cf5f3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379" }, { "r": "4.6.0", "os": "win", "version": "1.3.1.9999", "date": "2026-06-09T05:49:17.000Z", "commit": "9e54f8efc3071b788c45752ddde610611150d145", "fileid": "6165762513fc82a89f1fccd8da611b9749b466d7f6d566043828efa10b168ed6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/27123779379" } ] }