Displaying 1 result from an estimated 1 matches for "worksheetxy".
Did you mean:
worksheet
2006 Jun 29
1
RCOM Package
....
I know the following parameters/commands:
#Connect to the active Workbook
excel <- comGetObject("Excel.Application")
#Set the active sheet
sheet <- comGetProperty(excel,"ActiveSheet")
#Set a specific sheet
sheet <- comGetProperty(excel,"Worksheets","WorksheetXY")
#Create a new Worksheet
comInvoke(comGetProperty(excel,"Worksheets"),"Add")
#Define a range in a defined sheet
range1 <- comGetProperty(sheet,"Range","A1","A20")
#Read out this range from Excel
val1 <- as.double(comGetProperty(range1...