Regressions        
////////////////////////////////
 MarinStatsLectures- R Programming & Statistics,2013, Import Data, Copy Data from Excel to R CSV 
    & TXT Files | R Tutorial 1.5 | MarinStatsLectures
   (617k,s67k,t6:58)
   https://www.youtube.com/watch?v=qPk0YEKhqB8

 MrClean1796,2015,R Studio: Importing & Analyzing Data
   (v212k,s20k,t7:21)
   https://www.youtube.com/watch?v=Uo1C7Iligw0

 Tuke,Jonathan, 2012, Entering data into R
   (v26k,s366k,t9:47)
   https://www.youtube.com/watch?v=dBZ_vBqkSug
////////////////////////////////

error for require(XLConnect)
////////////////////////////

>  require(XLConnect)
Loading required package: XLConnect
Error: package or namespace load failed for 'XLConnect':
 .onLoad failed in loadNamespace() for 'rJava', details:
  call: fun(libname, pkgname)
  error: JAVA_HOME cannot be determined from the Registry

////////////////////////////

lower case issues
////////////////////////////

when using the R readLines() function to retrieve a website, it returns all the lower case, such as 
amexCap.xlsx became amexcap.xlsx. How do we solve this problem?

library(httr)
url <- "https://datayyy.com/data_excel/"
response <- GET(url)

# Check if the request was successful (status code 200)
if (http_status(response)$status == 200) {
  # Read the content as text
  content <- content(response, as = "text")

  # Now 'content' contains the raw content of the website, and case sensitivity should be preserved.
  # You can further process or save the content as needed.
} else {
  warning("Failed to retrieve the content. HTTP Status Code: ", http_status(response)$status)
}

////////////////////////////

New Excel-related package
////////////////////////////
Step 1: Search the list of R packages to find one Excel-related package
Step 2: Use help(package=packageName) to find a set of functions
Step 3: Choose a few functions to see their explanations. 
Step 4: Test a few related examples. 
////////////////////////////

Related functions
////////////////////////////

# Using tidyxl as an example

> library(tidyxl)
> help(package=tidyxl)

////////////////////////////