{ "_id": "6a0f63adacfb0bcc41c5c8c8", "Package": "basictabler", "Type": "Package", "Title": "Construct Rich Tables for Output to 'HTML'/'Excel'", "Version": "1.0.4", "Authors@R": "person(\"Christopher\", \"Bailiss\", email = \"cbailiss@gmail.com\",\nrole = c(\"aut\", \"cre\"))", "Description": "Easily create tables from data frames/matrices.\nCreate/manipulate tables row-by-row, column-by-column or\ncell-by-cell. Use common formatting/styling to output rich\ntables as 'HTML', 'HTML widgets' or to 'Excel'.", "License": "GPL-3", "Encoding": "UTF-8", "LazyData": "true", "URL": "http://www.basictabler.org.uk/,\nhttps://github.com/cbailiss/basictabler", "BugReports": "https://github.com/cbailiss/basictabler/issues", "VignetteBuilder": "knitr", "RoxygenNote": "7.3.2", "Config/pak/sysreqs": "cmake make libuv1-dev", "Repository": "https://cbailiss.r-universe.dev", "Date/Publication": "2025-04-22 07:53:24 UTC", "RemoteUrl": "https://github.com/cbailiss/basictabler", "RemoteRef": "HEAD", "RemoteSha": "e694357f977345f218789a05afef07e6bbe9bf1a", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-21 10:28:10 UTC", "User": "root" }, "Author": "Christopher Bailiss [aut, cre]", "Maintainer": "Christopher Bailiss ", "MD5sum": "685a19764356fcee729b0dc039fee3b9", "_user": "cbailiss", "_type": "src", "_file": "basictabler_1.0.4.tar.gz", "_fileid": "098e12230da2a350c1a28ca31be38defd75ca1aa9f9c78f4fc5eb46691621389", "_filesize": 1032800, "_sha256": "098e12230da2a350c1a28ca31be38defd75ca1aa9f9c78f4fc5eb46691621389", "_created": "2026-05-21T10:28:10.000Z", "_published": "2026-05-21T19:57:33.742Z", "_distro": "noble", "_jobs": [ { "job": 77256996673, "time": 162, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7133402313" }, { "job": 77256997305, "time": 153, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7133399589" }, { "job": 77256997384, "time": 194, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7133410709" }, { "job": 77256996726, "time": 153, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7133402265" }, { "job": 77256996299, "time": 208, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7133349452" }, { "job": 77256996481, "time": 123, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7145831882" }, { "job": 77256996944, "time": 180, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7133408071" }, { "job": 77256997222, "time": 103, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7133383244" }, { "job": 77256996956, "time": 106, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7133384000" } ], "_buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cbailiss/basictabler", "_commit": { "id": "e694357f977345f218789a05afef07e6bbe9bf1a", "author": "Chris Bailiss ", "committer": "Chris Bailiss ", "message": "Update cran-comments.md\n", "time": 1745308404 }, "_maintainer": { "name": "Christopher Bailiss", "email": "cbailiss@gmail.com", "login": "cbailiss", "description": "BI Solution Architect", "uuid": 11745789 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.3.0", "role": "Depends" }, { "package": "R6", "version": ">= 2.2.0", "role": "Imports" }, { "package": "dplyr", "version": ">= 0.5.0", "role": "Imports" }, { "package": "htmltools", "version": ">= 0.3.5", "role": "Imports" }, { "package": "htmlwidgets", "version": ">= 0.8", "role": "Imports" }, { "package": "jsonlite", "version": ">= 1.1", "role": "Suggests" }, { "package": "lubridate", "version": ">= 1.5.0", "role": "Suggests" }, { "package": "listviewer", "version": ">= 1.4.0", "role": "Suggests" }, { "package": "openxlsx", "version": ">= 4.0.17", "role": "Suggests" }, { "package": "flextable", "version": ">= 0.6.6", "role": "Suggests" }, { "package": "officer", "version": ">= 0.3.18", "role": "Suggests" }, { "package": "shiny", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "cbailiss", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "html", "htmlwidget", "tables", "visualization" ], "_stars": 36, "_contributors": [ { "user": "cbailiss", "count": 135, "uuid": 11745789 } ], "_userbio": { "uuid": 11745789, "type": "user", "name": "Chris Bailiss", "description": "BI Solution Architect" }, "_downloads": { "count": 457, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/basictabler" }, "_devurl": "https://github.com/cbailiss/basictabler", "_searchresults": 139, "_rbuild": "4.6.0", "_assets": [ "extra/basictabler.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/cbailiss/basictabler", "_realowner": "cbailiss", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2017-09-30" }, { "version": "0.1.1", "date": "2019-01-07" }, { "version": "0.2.0", "date": "2019-02-07" }, { "version": "0.3.0", "date": "2019-03-21" }, { "version": "0.3.1", "date": "2020-03-07" }, { "version": "1.0.0", "date": "2021-03-10" }, { "version": "1.0.1", "date": "2021-05-12" }, { "version": "1.0.2", "date": "2021-06-26" }, { "version": "1.0.4", "date": "2025-04-21" } ], "_exports": [ "BasicTable", "basictabler", "basictablerOutput", "basictablerSample", "getSimpleColoredTblTheme", "getTblTheme", "qhtbl", "qtbl", "renderBasictabler", "TableCell", "TableStyle", "TableStyles" ], "_datasets": [ { "name": "bhmsummary", "title": "A Summary of Birmingham Trains, Dec 2016-Feb 2017.", "object": "bhmsummary", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Status", "TOC", "TrainCategory", "PowerType", "SchedSpeedMPH", "GbttWeekDate", "GbttMonth", "Origin", "Destination", "TrainCount", "OnTimeArrivals", "OnTimeDepartures", "TotalArrivalDelayMinutes", "TotalDepartureDelayMinutes" ], "rows": 4839, "table": true, "tojson": false }, { "name": "trainstations", "title": "Train Stations", "object": "trainstations", "class": [ "data.frame" ], "fields": [ "CrsCode", "StationName", "OsEasting", "OsNorthing", "GridReference", "Latitude", "Longitude" ], "rows": 2568, "table": true, "tojson": true } ], "_help": [ { "page": "BasicTable", "title": "R6 class that defines a basic table.", "topics": [ "BasicTable" ] }, { "page": "basictabler", "title": "Render a table as a HTML widget.", "topics": [ "basictabler" ] }, { "page": "basictablerOutput", "title": "Standard function for Shiny scaffolding.", "topics": [ "basictablerOutput" ] }, { "page": "basictablerSample", "title": "Generate a sample basic table.", "topics": [ "basictablerSample" ] }, { "page": "bhmsummary", "title": "A Summary of Birmingham Trains, Dec 2016-Feb 2017.", "topics": [ "bhmsummary" ] }, { "page": "checkArgument", "title": "Perform basic checks on a function argument.", "topics": [ "checkArgument" ] }, { "page": "cleanCssValue", "title": "Cleans up a CSS attribute value.", "topics": [ "cleanCssValue" ] }, { "page": "containsText", "title": "Check whether a text value is present in another text value.", "topics": [ "containsText" ] }, { "page": "FlexTableRenderer", "title": "R6 class that converts a table to a flextable from the `flextabler` package.", "topics": [ "FlexTableRenderer" ] }, { "page": "FlexTableStyle", "title": "R6 class that specifies styling as used by the `flextable` package.", "topics": [ "FlexTableStyle" ] }, { "page": "FlexTableStyles", "title": "R6 class that defines a collection of styles as used by the `flextable` package.", "topics": [ "FlexTableStyles" ] }, { "page": "getBlankTblTheme", "title": "Get an empty theme for applying no styling to a table.", "topics": [ "getBlankTblTheme" ] }, { "page": "getCompactTblTheme", "title": "Get the compact theme for styling a table.", "topics": [ "getCompactTblTheme" ] }, { "page": "getDefaultTblTheme", "title": "Get the default theme for styling a table.", "topics": [ "getDefaultTblTheme" ] }, { "page": "getFtBorderFromCssBorder", "title": "Convert CSS border values to those used by the flextable package.", "topics": [ "getFtBorderFromCssBorder" ] }, { "page": "getFtBorderStyleFromCssBorder", "title": "Convert CSS border style values to those used by the flextable package.", "topics": [ "getFtBorderStyleFromCssBorder" ] }, { "page": "getFtBorderWidthFromCssBorder", "title": "Convert CSS border width to those used by the flextable package.", "topics": [ "getFtBorderWidthFromCssBorder" ] }, { "page": "getLargePlainTblTheme", "title": "Get the large plain theme for styling a table.", "topics": [ "getLargePlainTblTheme" ] }, { "page": "getNextPosition", "title": "Find the first value in an array that is larger than the specified value.", "topics": [ "getNextPosition" ] }, { "page": "getSimpleColoredTblTheme", "title": "Get a simple coloured theme.", "topics": [ "getSimpleColoredTblTheme" ] }, { "page": "getTblTheme", "title": "Get a built-in theme for styling a table.", "topics": [ "getTblTheme" ] }, { "page": "getXlBorderFromCssBorder", "title": "Convert CSS border style values to those used by the openxlsx package.", "topics": [ "getXlBorderFromCssBorder" ] }, { "page": "getXlBorderStyleFromCssBorder", "title": "Convert CSS border values to those used by the openxlsx package.", "topics": [ "getXlBorderStyleFromCssBorder" ] }, { "page": "isNumericValue", "title": "Check whether a numeric value is present.", "topics": [ "isNumericValue" ] }, { "page": "isTextValue", "title": "Check whether a text value is present.", "topics": [ "isTextValue" ] }, { "page": "oneToNULL", "title": "Convert a value of 1 to a NULL value.", "topics": [ "oneToNULL" ] }, { "page": "parseColor", "title": "Convert a CSS colour into a hex based colour code.", "topics": [ "parseColor" ] }, { "page": "parseCssBorder", "title": "Parse a CSS border value.", "topics": [ "parseCssBorder" ] }, { "page": "parseCssSizeToPt", "title": "Convert a CSS size value into points.", "topics": [ "parseCssSizeToPt" ] }, { "page": "parseCssSizeToPx", "title": "Convert a CSS size value into pixels", "topics": [ "parseCssSizeToPx" ] }, { "page": "parseCssString", "title": "Split a CSS attribute value into a vector/array.", "topics": [ "parseCssString" ] }, { "page": "parseFtBorder", "title": "Parse an ft-border value.", "topics": [ "parseFtBorder" ] }, { "page": "parseXlBorder", "title": "Parse an xl-border value.", "topics": [ "parseXlBorder" ] }, { "page": "PxToPt", "title": "Convert a number of pixels to points", "topics": [ "PxToPt" ] }, { "page": "qhtbl", "title": "Quickly render a basic table in HTML.", "topics": [ "qhtbl" ] }, { "page": "qtbl", "title": "Quickly build a basic table.", "topics": [ "qtbl" ] }, { "page": "renderBasictabler", "title": "Standard function for Shiny scaffolding.", "topics": [ "renderBasictabler" ] }, { "page": "TableCell", "title": "R6 class that represents a cell in a table.", "topics": [ "TableCell" ] }, { "page": "TableCellRanges", "title": "R6 class that manages cell ranges (e.g. for merged cells).", "topics": [ "TableCellRanges" ] }, { "page": "TableCells", "title": "R6 class that manages cells in a table.", "topics": [ "TableCells" ] }, { "page": "TableHtmlRenderer", "title": "R6 class that renders a table in HTML.", "topics": [ "TableHtmlRenderer" ] }, { "page": "TableOpenXlsxRenderer", "title": "R6 class that renders a table into an Excel worksheet.", "topics": [ "TableOpenXlsxRenderer" ] }, { "page": "TableOpenXlsxStyle", "title": "R6 class that specifies Excel styling as used by the openxlsx package.", "topics": [ "TableOpenXlsxStyle" ] }, { "page": "TableOpenXlsxStyles", "title": "R6 class that defines a collection of Excel styles as used by the `openxlsx` package.", "topics": [ "TableOpenXlsxStyles" ] }, { "page": "TableStyle", "title": "R6 class that specifies styling.", "topics": [ "TableStyle" ] }, { "page": "TableStyles", "title": "R6 class that defines a collection of styles.", "topics": [ "TableStyles" ] }, { "page": "trainstations", "title": "Train Stations", "topics": [ "trainstations" ] }, { "page": "vreConvertSimpleNumericRange", "title": "Convert a simple range expression to a standard R logical expression.", "topics": [ "vreConvertSimpleNumericRange" ] }, { "page": "vreGetSingleValue", "title": "Read the value from a single-valued value range expression.", "topics": [ "vreGetSingleValue" ] }, { "page": "vreHexToClr", "title": "Convert a colour in hex format (#RRGGBB) into a list.", "topics": [ "vreHexToClr" ] }, { "page": "vreIsEqual", "title": "Test if two numeric values are equal within tolerance.", "topics": [ "vreIsEqual" ] }, { "page": "vreIsMatch", "title": "Test whether a value matches a value range expression.", "topics": [ "vreIsMatch" ] }, { "page": "vreIsSimpleNumericRange", "title": "Determine if a value range expression is a simple range expression.", "topics": [ "vreIsSimpleNumericRange" ] }, { "page": "vreIsSingleValue", "title": "Determine if a value range expression is a single value.", "topics": [ "vreIsSingleValue" ] }, { "page": "vreScale2Colours", "title": "Scale a number from a range into a colour gradient.", "topics": [ "vreScale2Colours" ] }, { "page": "vreScaleNumber", "title": "Rescale a number from one range into another range.", "topics": [ "vreScaleNumber" ] } ], "_readme": "https://github.com/cbailiss/basictabler/raw/HEAD/README.md", "_rundeps": [ "base64enc", "bslib", "cachem", "cli", "digest", "dplyr", "evaluate", "fastmap", "fontawesome", "fs", "generics", "glue", "highr", "htmltools", "htmlwidgets", "jquerylib", "jsonlite", "knitr", "lifecycle", "magrittr", "memoise", "mime", "pillar", "pkgconfig", "R6", "rappdirs", "rlang", "rmarkdown", "sass", "tibble", "tidyselect", "tinytex", "utf8", "vctrs", "withr", "xfun", "yaml" ], "_vignettes": [ { "source": "v01-introduction.Rmd", "filename": "v01-introduction.html", "title": "Introduction ", "author": "Chris Bailiss", "engine": "knitr::rmarkdown", "headings": [ "In This Vignette", "Introducing basictabler", "Sample Data: Trains in Birmingham", "Quick-Table Functions", "Cell-by-Cell Construction", "Further Manipulation", "Examples Gallery", "Styling", "Conditional Formatting", "Further Reading" ], "created": "2017-09-28 19:11:56", "modified": "2021-03-09 21:32:28", "commits": 8 }, { "source": "v02-workingwithcells.Rmd", "filename": "v02-workingwithcells.html", "title": "Working with Cells ", "author": "Chris Bailiss", "engine": "knitr::rmarkdown", "headings": [ "In This Vignette", "Table Cells", "Properties of a Table Cell", "Creating a Table Cell-by-Cell", "Creating a Table Column-by-Column", "Creating a Table Row-by-Row", "Retrieving Cell Values", "Retrieving Cells", "Merging Cells", "Manipulating Tables", "Summary of Table Cells Functions", "Further Reading" ], "created": "2017-09-28 19:11:56", "modified": "2021-03-09 21:32:28", "commits": 10 }, { "source": "v03-outputs.Rmd", "filename": "v03-outputs.html", "title": "Outputs ", "author": "Chris Bailiss", "engine": "knitr::rmarkdown", "headings": [ "In This Vignette", "Overview", "Example Table", "Output as Plain Text", "Output as HTML", "Rendering a htmlwidget", "Retrieving HTML", "Output in Excel", "Output as FlexTable", "Output in Word", "Output in PowerPoint", "Output as an R Matrix", "Output as an R Data Frame", "Further Reading" ], "created": "2017-09-28 19:11:56", "modified": "2021-06-26 14:21:16", "commits": 5 }, { "source": "v04-styling.Rmd", "filename": "v04-styling.html", "title": "Styling ", "author": "Chris Bailiss", "engine": "knitr::rmarkdown", "headings": [ "In This Vignette", "Quick Styling", "Styles and Themes", "Styles and CSS", "XL Styles", "Included Themes", "Default Theme", "Compact Theme", "Large Plain Theme", "Simple Themes", "Styling with the quick table functions", "Styling Rows/Columns/Cells", "Specifying cell appearance while creating a table from a data frame", "Specifying cell appearance while creating a table column-by-column", "Specifying cell appearance while creating a table row-by-row", "Specifying cell appearance while creating a table cell-by-cell", "Changing styling/formatting after table creation using tbl$setStyling()", "Formatting cell borders for specific cells", "Changing styling/formatting using pt$mapStyling()", "Examples", "Style mapping example with mapType=\"logic\"", "Style mapping example with mapType=\"range\"", "Style mapping example with mapType=\"continuous\"", "Style mapping example with mapType=\"function\"", "Creating a New Theme", "Summary of Styling Rules", "Styling Output", "Further Reading" ], "created": "2017-09-28 19:11:56", "modified": "2021-06-26 12:52:19", "commits": 19 }, { "source": "v05-findingandformatting.Rmd", "filename": "v05-findingandformatting.html", "title": "Finding and Formatting ", "author": "Chris Bailiss", "engine": "knitr::rmarkdown", "headings": [ "In This Vignette", "Finding and Formatting", "Example Table", "Getting Cells By Row and/or Column Numbers", "Getting cells when specifyCellsAsList=TRUE", "Retrieving whole rows of cells when specifyCellsAsList=TRUE", "Retrieving whole columns of cells when specifyCellsAsList=TRUE", "Retrieving specific cells when specifyCellsAsList=TRUE", "Retrieving a mixture of rows, columns and cells when specifyCellsAsList=TRUE", "Getting cells when specifyCellsAsList=FALSE", "Retrieving whole rows of cells when specifyCellsAsList=FALSE", "Retrieving whole columns of cells when specifyCellsAsList=FALSE", "Retrieving specific cells when specifyCellsAsList=FALSE", "Retrieving multiple cells (2nd row-3rd column, 3rd row-4th column and 5th row-6th column):", "Retrieving a mixture of rows, columns and cells when specifyCellsAsList=FALSE", "Finding Cells", "Conditional Formatting", "Further Reading" ], "created": "2017-09-28 19:11:56", "modified": "2021-03-09 21:32:28", "commits": 9 }, { "source": "v06-shiny.Rmd", "filename": "v06-shiny.html", "title": "Shiny ", "author": "Chris Bailiss", "engine": "knitr::rmarkdown", "headings": [ "In This Vignette", "About Shiny", "Examples", "Minimal Example", "Further Reading" ], "created": "2017-09-28 19:11:56", "modified": "2025-04-21 20:58:27", "commits": 4 }, { "source": "v07-excelexport.Rmd", "filename": "v07-excelexport.html", "title": "Excel Export ", "author": "Chris Bailiss", "engine": "knitr::rmarkdown", "headings": [ "In This Vignette", "Overview", "Basic Export (no styling)", "Styling and Formatting", "Formatting Values", "Raw Value", "Formatted Values (as text)", "Formatted Values (as numbers)", "Using Excel to format the values", "Column Widths and Row Heights", "Performance", "Styling Reference", "Further Reading" ], "created": "2017-09-28 19:11:56", "modified": "2021-03-09 21:32:28", "commits": 5 } ], "_score": 7.243385345371658, "_indexed": true, "_nocasepkg": "basictabler", "_universes": [ "cbailiss" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.4", "date": "2026-05-21T10:30:40.000Z", "distro": "noble", "commit": "e694357f977345f218789a05afef07e6bbe9bf1a", "fileid": "827f5d7f0a1dbb55f5b0985ebd8356ee36e00e32beedd5f50117916c639ad508", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078" }, { "r": "4.6.0", "os": "linux", "version": "1.0.4", "date": "2026-05-21T10:30:35.000Z", "distro": "noble", "commit": "e694357f977345f218789a05afef07e6bbe9bf1a", "fileid": "a18d8da0a13a13024f25588183a234aff7526eaf75ce81e672f345db59f8061a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078" }, { "r": "4.5.3", "os": "mac", "version": "1.0.4", "date": "2026-05-21T10:31:10.000Z", "commit": "e694357f977345f218789a05afef07e6bbe9bf1a", "fileid": "fb9fa18c4b787be7b15fee69e9a2d1908af7556c05a4260d3a275ee28599c4b0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078" }, { "r": "4.6.0", "os": "mac", "version": "1.0.4", "date": "2026-05-21T10:30:51.000Z", "commit": "e694357f977345f218789a05afef07e6bbe9bf1a", "fileid": "fb138123a76296a1e7b234235a95edc2ffdef62ce0102aa475e180285424778c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.4", "date": "2026-05-21T19:57:13.000Z", "commit": "e694357f977345f218789a05afef07e6bbe9bf1a", "fileid": "149e36030a4f8d4e030aabe9a5b7b23c274c400f71da67b4ab5dfea0d13b8579", "status": "success", "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078" }, { "r": "4.7.0", "os": "win", "version": "1.0.4", "date": "2026-05-21T10:30:54.000Z", "commit": "e694357f977345f218789a05afef07e6bbe9bf1a", "fileid": "842d66d8d03e98fe6276bc3e0e7d239585ed5ca723ed7ef26a7df2de350c1fff", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078" }, { "r": "4.5.3", "os": "win", "version": "1.0.4", "date": "2026-05-21T10:29:34.000Z", "commit": "e694357f977345f218789a05afef07e6bbe9bf1a", "fileid": "fdbea28abd128e3cebeeead4cf01e86b47b72dc989a0346f9d1a5af8eb27403b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078" }, { "r": "4.6.0", "os": "win", "version": "1.0.4", "date": "2026-05-21T10:29:37.000Z", "commit": "e694357f977345f218789a05afef07e6bbe9bf1a", "fileid": "1f0547bd8d8d8ed7a20108ca153268d5456dd84eb8745bfcdb89ad360ae30fcd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/26220279078" } ] }