{ "_id": "6ad3105e62c1581dfb2fa3c3", "Package": "forgts", "Title": "Convert Formatted Spreadsheets to Presentation-Ready Display\nTables", "Version": "0.0.1.9000", "Authors@R": "person(\"Luis D.\", \"Verde Arregoitia\", , \"luis@liomys.mx\", role = c(\"aut\", \"cre\", \"cph\"),\ncomment = c(ORCID = \"0000-0001-9520-6543\"))", "Description": "Reads cell contents plus formatting from a spreadsheet\nfile and creates an editable 'gt' object with the same data and\nformatting. Supports the most commonly-used cell and text\nstyles including colors, fills, font weights and decorations,\nand borders.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2.9000", "Config/testthat/edition": "3", "URL": "https://github.com/luisDVA/forgts,\nhttps://luisdva.github.io/forgts/", "BugReports": "https://github.com/luisDVA/forgts/issues", "VignetteBuilder": "knitr", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libxml2-dev\nlibssl-dev libnode-dev", "Repository": "https://luisdva.r-universe.dev", "Date/Publication": "2025-02-04 18:54:51 UTC", "RemoteUrl": "https://github.com/luisdva/forgts", "RemoteRef": "HEAD", "RemoteSha": "7576ca253b998c730d8933c9042dd6d515083ab3", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-17 06:03:35 UTC", "User": "root" }, "Author": "Luis D. Verde Arregoitia [aut, cre, cph] (ORCID:\n)", "Maintainer": "Luis D. Verde Arregoitia ", "_user": "luisdva", "_type": "src", "_file": "forgts_0.0.1.9000.tar.gz", "_fileid": "https://r2.ropensci.org/79b67bc088b86742a0537155011b4eea16629b1fad9f5f4d2bf43965eed6b84a", "_filesize": 769865, "_sha256": "79b67bc088b86742a0537155011b4eea16629b1fad9f5f4d2bf43965eed6b84a", "_expires": "2027-01-25T06:06:20.000Z", "_created": "2026-10-17T06:03:35.000Z", "_published": "2026-10-17T06:06:21.938Z", "_buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 117325852951, "time": 122, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "12091489752" }, { "job": 117325853000, "time": 126, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "12091653281" }, { "job": 117325852948, "time": 106, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "12092221745" }, { "job": 117325853040, "time": 92, "config": "macos-release-arm64", "r": "4.6.1", "check": "NOTE", "artifact": "12092340478" }, { "job": 117325127184, "time": 223, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12090904835" }, { "job": 117325852976, "time": 125, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12092216643" }, { "job": 117325852979, "time": 96, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "12091368539" }, { "job": 117325852943, "time": 73, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "NOTE", "artifact": "12090944669" }, { "job": 117325852994, "time": 77, "config": "windows-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "12091827698" } ], "_upstream": "https://github.com/luisdva/forgts", "_commit": { "id": "7576ca253b998c730d8933c9042dd6d515083ab3", "author": "LuisDVA ", "committer": "LuisDVA ", "message": "add badges\n", "time": 1738695291 }, "_maintainer": { "name": "Luis D. Verde Arregoitia", "email": "luis@liomys.mx", "login": "luisdva", "bluesky": "@liomys.mx", "linkedin": "in/luis-d-verde-arregoitia-a20339209", "orcid": "0000-0001-9520-6543", "description": "mammalogist", "uuid": 5580938 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "dplyr", "role": "Imports" }, { "package": "gt", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "readxl", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "tidyxl", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "luisdva", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 25, "_contributors": [ { "user": "luisdva", "count": 26, "uuid": 5580938 }, { "user": "ddiannae", "count": 1, "uuid": 15936920 } ], "_userbio": { "uuid": 5580938, "type": "user", "name": "Luis Verde Arregoitia", "followers": 174, "description": "mammalogist" }, "_downloads": { "count": 296, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/forgts" }, "_devurl": "https://github.com/luisdva/forgts", "_pkgdown": "https://luisdva.github.io/forgts/", "_searchresults": 10, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/forgts.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/luisdva/forgts", "_realowner": "luisdva", "_cranurl": true, "_releases": [ { "version": "0.0.1", "date": "2025-01-31" } ], "_exports": [ "apply_styling", "forgts", "get_formatting", "translate_defs" ], "_help": [ { "page": "apply_styling", "title": "Apply Spreadsheet Formatting to gt Table", "topics": [ "apply_styling" ] }, { "page": "forgts", "title": "Creat gt from spreadsheet", "topics": [ "forgts" ] }, { "page": "get_formatting", "title": "Get Spreadsheet Formatting", "topics": [ "get_formatting" ] }, { "page": "rodentsheet.xlsx", "title": "rodentsheet.xlsx spreadsheet", "topics": [ "rodentsheet.xlsx" ] }, { "page": "target_var_fmt", "title": "Colwise formatting", "topics": [ "target_var_fmt" ] }, { "page": "translate_defs", "title": "Translate Formatting Definitions", "topics": [ "translate_defs" ] } ], "_pkglogo": "https://github.com/luisdva/forgts/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/luisdva/forgts/raw/HEAD/README.md", "_rundeps": [ "base64enc", "bigD", "bitops", "bslib", "cachem", "cellranger", "cli", "commonmark", "cpp11", "crayon", "curl", "digest", "dplyr", "evaluate", "farver", "fastmap", "fontawesome", "fs", "generics", "glue", "gt", "highr", "hms", "htmltools", "htmlwidgets", "jquerylib", "jsonlite", "juicyjuice", "knitr", "labeling", "lifecycle", "litedown", "magrittr", "markdown", "memoise", "mime", "pillar", "piton", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "rappdirs", "RColorBrewer", "Rcpp", "reactable", "reactR", "readxl", "rematch", "rlang", "rmarkdown", "sass", "scales", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "tidyxl", "tinytex", "utf8", "V8", "vctrs", "viridisLite", "withr", "xfun", "xml2", "yaml" ], "_vignettes": [ { "source": "getting-started.Rmd", "filename": "getting-started.html", "title": "Getting started", "engine": "knitr::rmarkdown", "headings": [], "created": "2025-01-28 17:16:13", "modified": "2025-01-28 17:22:43", "commits": 2 } ], "_score": 5.096910013008056, "_indexed": true, "_nocasepkg": "forgts", "_universes": [ "luisdva" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.1.9000", "date": "2026-10-17T06:05:41.000Z", "distro": "resolute", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/171d39e9c5c62b20cb41ad24d1b36a2619407f433a1028f7e7baf4cd45fa2f0e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074" }, { "r": "4.6.1", "os": "linux", "version": "0.0.1.9000", "date": "2026-10-17T06:05:40.000Z", "distro": "resolute", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/1f8ccd180357bf676c58e71f0e5546604e44ab02b1548bfda73582b3d9c6b5cf", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074" }, { "r": "4.5.3", "os": "mac", "version": "0.0.1.9000", "date": "2026-10-17T06:05:25.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/6726539e1c89e6960a86f6f6c7050eebda99b502bf608aba8f2e3985f21537bc", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074" }, { "r": "4.6.1", "os": "mac", "version": "0.0.1.9000", "date": "2026-10-17T06:05:14.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/653a1a18a2837cc2a3fd130d0a56cf6b2f7da2755f758d94dadd62fa00bf37cd", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.1.9000", "date": "2026-10-17T06:05:55.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/0ed1596ebb1d4e3a49345d05618bd4dc4261f7f2aee446738c921be6f47b424f", "status": "success", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074" }, { "r": "4.7.0", "os": "win", "version": "0.0.1.9000", "date": "2026-10-17T06:05:00.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/1554f1c7a46c72e0fd9ac8eec3dee8e5d2ac1847b6c8d4985980e7029e4708d6", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074" }, { "r": "4.5.3", "os": "win", "version": "0.0.1.9000", "date": "2026-10-17T06:04:42.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/70b148534eb8fe1229016265c9e7ac0dfcffeb777b4ef30943e6d2861c4a93e6", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074" }, { "r": "4.6.1", "os": "win", "version": "0.0.1.9000", "date": "2026-10-17T06:04:45.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/dc40a6e77f4755ca93d6cdf7e4e32cad57c781e026b8632e389cb6775fe4eaa0", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/39008254074" } ] }