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.
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 |