R - link excel to r - Code Answer

Search

R

link excel to r

#XLConnect Package
library(XLConnect)

##Build Connection to excel 
x <- loadWorkbook("data.xlsx")

##Get Sheet name
getSheets("data.xlsx")

#Read Sheet
readWorksheet("data.xlsx", sheet = 2, 
              startRow = 3, endRow = 5, 
              startCol = 2, endCol = 4,
              header = FALSE)

# Add a worksheet to x
createSheet(x, "data_summary")

# Remove the fourth sheet
removeSheet(my_book, 4) # 4 is interchangeable with sheet name

# Add data in summ to "data_summary" sheet
writeWorksheet(x, data = summ, sheet = "data_summary")

# Rename "data_summary" sheet to "summary"
renameSheet(x, "data_summary", "summary")

# Save workbook as summary.xlsx
saveWorkbook(x "summary.xlsx")

Comment

PREVIOUS	NEXT

Code Example
R :: R construct a named list
R :: geom_boxplot line width
R :: generate pair in r
R :: r: network randomization test igprah stakoverflow
R :: R change column to row names
R :: Now to find the r2 score
R :: How to use group_by inside a function?
R :: stacked bar plot r with age groups
R :: hypergeometric distribution on r
R :: linear regression r text label coefficient ggplot
R :: XLConnect
R :: how to get the r2 value in r
R :: r - if value in a df is between two number then add 1
Rust :: rust reverse for loop
Rust :: bevy assets image as sprite
Rust :: how to open a file rust
Rust :: get length of vector rust
Rust :: find last element of vec rust
Rust :: armanriazi•rust•error•E0282•type annotations needed
Rust :: check if an item is in vec in rust
Rust :: unwrap_or_else in rust
Rust :: armanriazi•rust•clone•vs•copy
Rust :: armanriazi•rust•concept•oop•state•pattern
Rust :: armanriazi•rust•rc•vs•refcell
Rust :: armanriazi•rust•error•E0277•the trait bound `` is not satisfied
Lua :: lua string.split
Lua :: lua for each in table
Lua :: how to detect if part had children roblox
Lua :: dictionnary lua
Lua :: roblox luau random number

Search

R

link excel to r

ADD CONTENT