xl.sheet.add: Basic operations with worksheets.

Description Usage Arguments Details Value See Also Examples

View source: R/xl.sheet.add.R

Description

Basic operations with worksheets.

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

Arguments

xl.sheet.name

character. sheet name/new sheet name

before

character/numeric. sheet name or sheet number in active workbook before which new sheet will be added

xl.sheet

character/numeric. sheet name or sheet number in active workbook

Details

Value

See Also

xl.workbooks

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
## Not run:  
xl.workbook.add()
sheets = xl.sheets()
xl.sheet.add("Second")
xl.sheet.add("First", before="Second")
for (sheet in sheets) xl.sheet.delete(sheet) # only 'First' and 'Second' exist in workbook now
xl.sheet.activate("Second") #last sheet activated 
xl.sheet.duplicate() # duplicate second sheet
xl.sheet.name() # "Second (2)"
xl.sheet.name("Third") # "Third"


## End(Not run)

gdemin/excel.link documentation built on May 24, 2018, 9:31 p.m.