blocks|key|595345|text|我肯定会尝试gdata包中的read.xls函数，它比xlsx包成熟得多。它可能需要Perl+...|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|595346|entityMap^0|6|5|E|8|R|4|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

I would definitely try the <code>read.xls</code> function in the <code>gdata</code> package, which is considerably more mature than the <code>xlsx</code> package. It may require Perl ...

blocks|key|595438|text|如果你遇到同样的问题，R给你一个错误--找不到函数".jnew“--只要安装库rJava即可。或者，如果您已经有了它，只需运行行库(RJava)。这应该是问题所在。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|595439|此外，每个人都应该清楚，csv和txt文件更容易使用，但生活并不容易，有时您必须打开一个xlsx。|595440|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If you are running into the same problem and R is giving you an error -- could not find function ".jnew" -- Just install the library rJava. Or if you have it already just run the line library(rJava). That should be the problem.

Also, it should be clear to everybody that csv and txt files are easier to work with, but life is not easy and sometimes you just have to open an xlsx.

blocks|key|811030|text|您可能还想尝试一下XLConnect包。我用它比xlsx更幸运(另外它也可以读取.xls文件)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|811031|library(XLConnect)
theData+<-+readWorksheet(loadWorkbook("C:/AB_DNA_Tag_Numbers.xlsx"),sheet=1)|code-block|syntax|javascript|811032|此外，如果您遇到找不到文件的问题，请尝试使用file.choose()选择它。|811033|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You may also want to try the XLConnect package. I've had better luck with it than xlsx (plus it can read .xls files too).

<pre><code>library(XLConnect)
theData &lt;- readWorksheet(loadWorkbook("C:/AB_DNA_Tag_Numbers.xlsx"),sheet=1)
</code></pre>

also, if you are having trouble with your file not being found, try selecting it with file.choose().

blocks|key|811198|text|你的操作系统是什么？您运行的是什么版本的R:32位还是64位？您安装了什么版本的Java？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|811199|当我第一次开始使用read.xlsx()函数时，我遇到了类似的错误，并发现我的问题(可能与您的问题相关，也可能与您的问题无关；至少，此响应应该被视为“也要尝试一下”)与.xlsx包与64位Java不兼容有关。我相当确定.xlsx包需要32位Java。|offset|length|style|CODE|811200|使用32位R并确保安装了32位Java。这可能会解决您的问题。|811201|entityMap^0|0|9|B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

What's your operating system? What version of R are you running: 32-bit or 64-bit? What version of Java do you have installed?

I had a similar error when I first started using the <code>read.xlsx()</code> function and discovered that my issue (which may or may not be related to yours; at a minimum, this response should be viewed as "try this, too") was related to the incompatability of .xlsx pacakge with 64-bit Java. I'm fairly certain that the .xlsx package requires 32-bit Java.

Use 32-bit R and make sure that 32-bit Java is installed. This may address your issue.

blocks|key|595778|text|这个新的包看起来很不错，它不需要rJava，并且使用'Rcpp‘来提高速度。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|595779|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This new package looks nice <a href="http://cran.r-project.org/web/packages/openxlsx/openxlsx.pdf" rel="noreferrer">http://cran.r-project.org/web/packages/openxlsx/openxlsx.pdf</a>
It doesn't require rJava and is using 'Rcpp' for speed.

blocks|key|595854|text|对我来说，openxlx包以最简单的方式工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|595855|install.packages("openxlsx")
library(openxlsx)
rawData<-read.xlsx("your.xlsx");|code-block|syntax|javascript|595856|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For me the openxlx package worked in the easiest way. 

<pre><code>install.packages("openxlsx")
library(openxlsx)
rawData&lt;-read.xlsx("your.xlsx");
</code></pre>

Please can someone help me on the best way to import an excel 2007 (.xlsx) file into R. I have tried several methods and none seems to work. I have upgraded to 2.13.1, windows XP, xlsx 0.3.0, I don't know why the error keeps coming up. I tried:

<pre><code>AB&lt;-read.xlsx("C:/AB_DNA_Tag_Numbers.xlsx","DNA_Tag_Numbers")
</code></pre>

OR

<pre><code>AB&lt;-read.xlsx("C:/AB_DNA_Tag_Numbers.xlsx",1)
</code></pre>

but I get the error:

<pre><code> Error in .jnew("java/io/FileInputStream", file) : 
 java.io.FileNotFoundException: C:\AB_DNA_Tag_Numbers.xlsx (The system cannot find the file specified)
</code></pre>

Thank you.

Importing Excel files into R, xlsx or xls

Java

Perl

请有人可以帮助我的最好的方式来导入一个excel 2007 (.xlsx)文件到R。我已经尝试了几种方法，似乎没有一个工作。我已经升级到2.13.1，windows XP，xlsx 0.3.0，我不知道为什么错误总是出现。我试过了：AB<-read.xlsx("C:/AB_DNA_Tag_Numbers.xlsx","...

问将Excel文件导入R、xlsx或xls
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将Excel文件导入R、xlsx或xlsEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将Excel文件导入R、xlsx或xls
EN