Hi, I would like to know if there is a special package that could help me Import/Export excel files to/from R, without changing the file type (*.csv ...) ? I have tried several packages and non of them worked on my computer .... If someone have a clue how to do it I would be grateful... Thanks for the help! -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717.html Sent from the R help mailing list archive at Nabble.com.
Import/Export excel files to/from R, without changing the file type
9 messages · jim holtman, osamaabusinni, Uwe Ligges +3 more
have you tried the 'XLConnect' package? what have you tried, what types of files were you using and what errors did you encounter? Sent from my iPad
On Nov 25, 2012, at 6:16, osamaabusinni <osamaabusinni at gmail.com> wrote:
Hi, I would like to know if there is a special package that could help me Import/Export excel files to/from R, without changing the file type (*.csv ...) ? I have tried several packages and non of them worked on my computer .... If someone have a clue how to do it I would be grateful... Thanks for the help! -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121125/8792fe08/attachment.pl>
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121125/9f27d3f5/attachment.pl>
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121125/059a38c4/attachment.pl>
On 25.11.2012 16:18, osamaabusinni wrote:
Yes already installed the CLConnect. I'm trying to import a file of xlsx. but with no success. from some reason the package isn't working, please see attached file.
No files passed the mailing list filters. Anyway, if XLConnect does not work for you, why not try one of the other solutions mentioned in the R Data Import / Export manual? Best, Uwe Ligges
On Sun, Nov 25, 2012 at 2:33 PM, jholtman [via R] <ml-node+s789695n4650722h38 at n4.nabble.com> wrote:
have you tried the 'XLConnect' package? what have you tried, what types of files were you using and what errors did you encounter? Sent from my iPad On Nov 25, 2012, at 6:16, osamaabusinni <[hidden email]> wrote:
Hi, I would like to know if there is a special package that could help me Import/Export excel files to/from R, without changing the file type (*.csv ...) ? I have tried several packages and non of them worked on my computer .... If someone have a clue how to do it I would be grateful... Thanks for the help! -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ [hidden email] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
______________________________________________ [hidden email] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717p4650722.html To unsubscribe from Import/Export excel files to/from R, without changing the file type, click here. NAML
Screen Shot 2012-11-25 at 2.56.01 PM.png (233K) <http://r.789695.n4.nabble.com/attachment/4650740/0/Screen%20Shot%202012-11-25%20at%202.56.01%20PM.png> -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717p4650740.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Hello, It's a bad idea to post a png file with error messages, next time, copy from RStudio and paste it in a post. Anyway, your error message says that you don't have a Windows system variable JAVA_HOME. So, rJava can't find it. The solution is to create one in Windows. Hope this helps, Rui Barradas Em 25-11-2012 15:18, osamaabusinni escreveu:
Yes already installed the CLConnect. I'm trying to import a file of xlsx. but with no success. from some reason the package isn't working, please see attached file. On Sun, Nov 25, 2012 at 2:33 PM, jholtman [via R] <ml-node+s789695n4650722h38 at n4.nabble.com> wrote:
have you tried the 'XLConnect' package? what have you tried, what types of files were you using and what errors did you encounter? Sent from my iPad On Nov 25, 2012, at 6:16, osamaabusinni <[hidden email]> wrote:
Hi, I would like to know if there is a special package that could help me Import/Export excel files to/from R, without changing the file type (*.csv ...) ? I have tried several packages and non of them worked on my computer .... If someone have a clue how to do it I would be grateful... Thanks for the help! -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ [hidden email] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
______________________________________________ [hidden email] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717p4650722.html To unsubscribe from Import/Export excel files to/from R, without changing the file type, click here. NAML
Screen Shot 2012-11-25 at 2.56.01 PM.png (233K) <http://r.789695.n4.nabble.com/attachment/4650740/0/Screen%20Shot%202012-11-25%20at%202.56.01%20PM.png> -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717p4650740.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
XLConnect requires Java 1.6+ to be installed. You can get Java from http://www.java.com/getjava/ Best regards, Martin -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717p4650766.html Sent from the R help mailing list archive at Nabble.com.
You should read your error messages more carefully, especially: could not find function! take a look at loadworkbook and loadWorkbook. Bart -- View this message in context: http://r.789695.n4.nabble.com/Import-Export-excel-files-to-from-R-without-changing-the-file-type-tp4650717p4650823.html Sent from the R help mailing list archive at Nabble.com.