R能不能将数据导入到excel特定工作簿、特定工作表、特定单元格里？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

如题，R能不能将数据导入到excel特定工作簿、特定工作表、特定单元格里？

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：EXCEL exce 数据导入 xcel 单元格

openxlsx,试试

nieqiang110 发表于 2019-9-5 20:42
openxlsx,试试

貌似不成功，可否具体点解释

看看openxilsx包write.xlsx 函数里面的参数，应该可以解决

Optional parameters are:
createWorkbook Parameters
• creator A string specifying the workbook author
addWorksheet Parameters
• sheetName Name of the worksheet
• gridLines A logical. If FALSE, the worksheet grid lines will be hidden.
• tabColour Colour of the worksheet tab. A valid colour (belonging to colours()) or a valid hex
colour beginning with "#".
• zoom A numeric between 10 and 400. Worksheet zoom level as a percentage.
writeData/writeDataTable Parameters
• startCol A vector specifying the starting column(s) to write df
• startRow A vector specifying the starting row(s) to write df
• xy An alternative to specifying startCol and startRow individually. A vector of the form
c(startCol, startRow)
• colNames or col.names If TRUE, column names of x are written.
• rowNames or row.names If TRUE, row names of x are written.
• headerStyle Custom style to apply to column names.
• borders Either "surrounding", "columns" or "rows" or NULL. If "surrounding", a border is
drawn around the data. If "rows", a surrounding border is drawn a border around each row.
If "columns", a surrounding border is drawn with a border between each column. If "all" all
cell borders are drawn.
• borderColour Colour of cell border
• borderStyle Border line style.
• keepNA If TRUE, NA values are converted to #N/A in Excel else NA cells will be empty.
Defaults to FALSE.

writeData Write an object to a worksheet
Description
Write an object to worksheet with optional styling.
Usage
writeData(wb, sheet, x, startCol = 1, startRow = 1, xy = NULL,
colNames = TRUE, rowNames = FALSE, headerStyle = NULL,
borders = c("none", "surrounding", "rows", "columns", "all"),
borderColour = getOption("openxlsx.borderColour", "black"),
borderStyle = getOption("openxlsx.borderStyle", "thin"),
withFilter = FALSE, keepNA = FALSE, name = NULL, sep = ", ")
Arguments
wb A Workbook object containing a worksheet.
sheet The worksheet to write to. Can be the worksheet index or name.
x Object to be written. For classes supported look at the examples.
startCol A vector specifying the starting column to write to.
startRow A vector specifying the starting row to write to.
xy An alternative to specifying startCol and startRow individually. A vector of
the form c(startCol, startRow).
colNames If TRUE, column names of x are written.
rowNames If TRUE, data.frame row names of x are written.
headerStyle Custom style to apply to column names.
borders Either "none" (default), "surrounding", "columns", "rows" or respective abbreviations.
If "surrounding", a border is drawn around the data. If "rows",
a surrounding border is drawn with a border around each row. If "columns", a
surrounding border is drawn with a border between each column. If "all" all
cell borders are drawn.
borderColour Colour of cell border. A valid colour (belonging to colours() or a hex colour
code, eg see here).
borderStyle Border line style
• none no border
• thin thin border
• medium medium border
• dashed dashed border
• dotted dotted border
• thick thick border

weidongyi156 发表于 2019-9-6 08:54
貌似不成功，可否具体点解释

看看write.xlsx和writeData两个函数以及参数

nieqiang110 发表于 2019-9-7 07:14
看看write.xlsx和writeData两个函数以及参数

能否给个成功的例子？搞不定