R读取EXCEL求助

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

1. Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files
   
2. 
   
3. Description
   
4. 
   
5. The xlsx package gives programatic control of Excel files using R. A high level API allows the user to read a sheet of an xlsx document into a data.frame and write a data.frame to a file. Lower level functionality permits the direct manipulation of sheets, rows and cells. For example, the user has control to set colors, fonts, data formats, add borders, hide/unhide sheets, add/remove rows, add/remove sheets, etc.
   
6. 
   
7. Behind the scenes, the xlsx package uses a java library from the Apache project, [url]http://poi.apache.org/index.html.[/url] This Apache project provides a Java API to Microsoft Documents (Excel, Word, PowerPoint, Outlook, Visio, etc.) By using the rJava package that links R and Java, we can piggyback on the excellent work already done by the folks at the Apache project and provide this functionality in R. The xlsx package uses only a subset of the Apache POI project, namely the one dealing with Excel files. All the necessary jar files are kept in package xlsxjars that is imported by package xlsx.
   
8. 
   
9. A collection of tests that can be used as examples are located in folder /tests/. They are a good source of examples of how to use the package.
   
10. 
    
11. Please see [url]http://code.google.com/p/rexcel/[/url] for a Wiki and the development version. To report a bug, use the Issues page at [url]https://code.google.com/p/rexcel/issues/list.[/url] Questions should be asked on the dedicated mailing list at [url]http://groups.google.com/group/R-package-xlsx.[/url]
    
12. 
    
13. Details
    
14. 
    
15. Package:         xlsx
    
16. Type:         Package
    
17. Version:         0.5.7
    
18. Date:         2014-08-01
    
19. License:         GPL-3
    
20. Author(s)
    
21. 
    
22. Adrian A. Dragulescu
    
23. 
    
24. Maintainer: Adrian A. Dragulescu <[email]adrian.dragulescu@gmail.com[/email]>
    
25. 
    
26. References
    
27. 
    
28. Apache POI project for Microsoft Excel format: [url]http://poi.apache.org/spreadsheet/index.html.[/url]
    
29. 
    
30. The Java Doc detailing the classes: [url]http://poi.apache.org/apidocs/index.html.[/url] This can be useful if you are looking for something that is not exposed in R as it may be available on the Java side. Inspecting the source code for some the the R functions in this package can show you how to do it (even if you are Java shy.)
    
31. 
    
32. See Also
    
33. 
    
34. Workbook for ways to work with Workbook objects.
    
35. 
    
36. Examples
    
37. 
    
38. ## Not run:
    
39. 
    
40. require(xlsx)
    
41. 
    
42. # example of reading xlsx sheets
    
43. file <- system.file("tests", "test_import.xlsx", package = "xlsx")
    
44. res <- read.xlsx(file, 2)  # read the second sheet
    
45. 
    
46. # example of writing xlsx sheets
    
47. file <- paste(tempfile(), "xlsx", sep=".")
    
48. write.xlsx(USArrests, file=file)
    
49. 
    
50. 
    
51. ## End(Not run)

复制代码

求教，R读取excel怎么只有这一点介绍？
有没有其它选项？
比方说我想读取部分数据的选项？
请坛友和老师赐教
谢谢

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

方案：
1.openxlsx包
2.readxl包
3.把excel转换为csv或者文本格式格式再读
4.RODBC包
5.xlsx包
6.XLConnect

ryoeng 发表于 2017-9-18 16:08
R利用openxlsx操作xlsx文件- R语言论坛- 经管之家(原人大经济论坛)
楼主可以任意读取表格上的任何一个格子 ...

多谢多谢

屋檐滴语 发表于 2017-9-18 19:00
方案：
1.openxlsx包
2.readxl包

非常感谢，刚学R，非常感谢您