Skip to contents

Wrapper. Reads a spreadsheet file including most formatting information and creates a formatted gt table with the same data and formatting.

Usage

forgts(file, sheet = NULL)

Arguments

file

Path to a spreadsheet.

sheet

A character string with the name of a sheet within a workbook, or an integer with the position of the sheet. Defaults to the first sheet if left unspecified.

Value

A great table!

Examples

example_spreadsheet <- system.file("extdata/rodentsheet.xlsx", package = "forgts")
forgts(example_spreadsheet)
measurement type species sex CBL LR
craniodental Abeomelomys sevia m 30.10 9.65
craniodental Bandicota bengalensis f 39.41 11.21
craniodental Chiruromys forbesi m 30.73 8.27
craniodental Chiruromys forbesi m 34.46 8.13
craniodental Chiruromys lamia m 29.56 8.13
craniodental Chiruromys lamia m 27.45 7.13
craniodental Chiruromys vates m 28.70 7.04