Functions to manipulate Excel 2007 workbooks.
函数来处理Excel 2007工作簿。
译者:生物统计家园网 机器人LoveR
描述----------Description----------
Functions to manipulate Excel 2007 workbooks.
函数来处理Excel 2007工作簿。
用法----------Usage----------
createWorkbook(type="xlsx")
loadWorkbook(file)
saveWorkbook(wb, file)
参数----------Arguments----------
参数:type
a String, either xlsx for Excel 2007 OOXML format, or xls for Excel 95 binary format.
一个字符串,是xlsxExcel 2007的OOXML格式,或xls为Excel 95的二进制格式。
参数:file
the absolute path to the file which the data are to be read from.
该数据要被读取的文件的绝对路径。
参数:wb
a workbook object as returned by createWorkbook or loadWorkbook.
一个工作簿对象返回的createWorkbook或loadWorkbook。
Details
详细信息----------Details----------
createWorkbook creates an empty workbook object.
createWorkbook创建一个空白工作簿对象。
loadWorkbook loads a workbook from a file.
loadWorkbook从文件加载一个工作簿。
saveWorkbook saves an existing workook to an Excel 2007 file.
saveWorkbook保存现有workook,Excel 2007文件。
值----------Value----------
createWorkbook returns a java object reference pointing to an empty workbook object.
createWorkbook返回一个Java对象引用指向一个空工作簿对象。
loadWorkbook creates a java object reference corresponding to the file to load.
loadWorkbook对应要加载的文件创建一个Java对象的引用。
(作者)----------Author(s)----------
Adrian Dragulescu
参见----------See Also----------
write.xlsx for writing a data.frame to an xlsx file. read.xlsx for reading the content of a xlsx worksheet into a data.frame. To extract
write.xlsx写一个data.frame到xlsx文件的。 read.xlsx阅读的内容的xlsx表data.frame。要提取
实例----------Examples----------
wb <- createWorkbook()
# see all the available java methods that you can call[查看所有可用的Java方法,您可以调用]
.jmethods(wb)
# for example[例如]
wb$getNumberOfSheets() # no sheet yet![无纸!]