library(readxl)

read_excel("~/Documents/metro-cities.xlsx")

read_excel("~/Documents/metro-cities.xlsx", sheet = "metro1")

read_excel("~/Documents/metro-cities.xlsx", sheet = 1)

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro1", 
           skip = 1,
           col_names = c("CITY", "N_Lines", "N_Stations"))

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro1",
           col_types = c("text", "numeric", "numeric"))

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro1",
           range = "A1:C5",
           col_types = c("text", "numeric", "numeric"))

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro1",
           col_names = FALSE)

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro1",
           col_names = FALSE,
           col_types = c("text", "numeric", "numeric"))



read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro2")

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro2", 
           skip = 1)


read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro3")

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro3",
           range = "B2:D8")


read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro4")


read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro5")

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro5", 
           col_names = FALSE)

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro5", 
           col_names = c("city", "lines", "stations"))

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro5", 
           col_names = c("CITY", "N_Lines", "N_Stations"))

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro1", 
           skip = 1,
           col_names = c("CITY", "N_Lines", "N_Stations"))


read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro6")


read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro6", 
           na = "*")


read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro7")

read_excel("~/Documents/metro-cities.xlsx", 
           sheet = "metro7",
           skip = 3,
           na = c("*", "?"))