In paul4forest/tradeflows: Process forest products trade flow data from COMTRADE and COMEXT

library(knitr)
library(xlsx)
file <- system.file("tests", "test_import.xlsx", 
                    package = "xlsx")

From an Excel sheet to a data frame

Simple function read.xlsx()

sheet <- read.xlsx(file, 2)
kable(sheet)

Lower level, with access to workbook and sheet objects

wb <- loadWorkbook(file)  
sheets <- getSheets(wb)
sheet  <- sheets[[2]]  # extract the second sheet

List of java methods available

# see all the available java methods that you can call
.jmethods(sheet)

# for example
sheet$getLastRowNum()

paul4forest/tradeflows documentation built on Oct. 8, 2019, 10:35 a.m.