Skip to contents
a1_heading()
Format A1 cell in every sheet to Heading style for accessibility purposes
addSuperScriptToCell()
Writes text to a cell within a workbook object and adds a superscript or a subscript
check_package_v()
Check and Update Package Version
clean_metadata()
Remove creator names from the metadata of an ods file and add new tags if wanted
convert_to_ods()
Convert an Excel file to the equivalent ods object in Cloud R. Note that this function will not work in local versions of R.
export_sharepoint()
Export an R object as a CSV or XLSX file to a specified Sharepoint location
export_sharepoint_file()
Export an R object as a CSV or XLSX file to a specified Sharepoint location
import_sharepoint()
Import a file from a specified Sharepoint location
left()
Equivalent of left in SQL; takes the specified number of characters from the left hand side of a string.
list_sharepoint_drives()
List the sharepoint drives available in the specified site, useful for finding their names
recent_file()
Find the most recently modified file in a folder Can use a matching pattern to specify a specific file type or name.
remove_colours()
Remove font colours from ODS files to ensure they only use automatic colours (exception for hyperlinks)
remove_notes()
Remove notes from DfT publication table headers
right()
Equivalent of right in SQL; takes the specified number of characters from the right hand side of a string.
round()
Round numbers according to statistical principles rather than data science ones i.e. numbers ending in a 5 will always be rounded up, regardless of preceeding number
sqlConnect()
Connect to a SQL database on the Cloud R computing environment
update_renv()
Update Renv Lockfile
writeClipboard()
Copy data to an appropriately-sized clipboard where available