Re: [R] Excel export date format

On Fri, Jul 8, 2011 at 7:31 PM, Jim Lemon wrote: > Hi folks, > I have been tormented for some time by Excel's habit of exporting dates to > CSV files as mm/dd/ format even if the dates are formatted dd/mm/ in > the display. What's worse, if there are dates that are of ambiguous > (6/6/2011

Re: [R] Excel export date format

On 07/09/2011 06:26 PM, (Ted Harding) wrote: ... I would not dare to suggest the above exchange for inclusion in the Fortunes package. Fortunes are supposed to bring us joy. But there is perhaps scope for a package Misfortunes. Then, when things are not going well, one can enter source(misfo

Re: [R] Excel export date format

On 09-Jul-11 08:08:56, Duncan Mackay wrote: > At 09:31 09/07/2011, you wrote: >>Hi folks, >>I have been tormented for some time by Excel's habit of exporting >>dates to CSV files as mm/dd/ format even if the dates are >>formatted dd/mm/ in the display. What's worse, if there are >>dates

Re: [R] Excel export date format

At 09:31 09/07/2011, you wrote: Hi folks, I have been tormented for some time by Excel's habit of exporting dates to CSV files as mm/dd/ format even if the dates are formatted dd/mm/ in the display. What's worse, if there are dates that are of ambiguous (6/6/2011) and unambiguous (16/

[R] Excel export date format

Hi folks, I have been tormented for some time by Excel's habit of exporting dates to CSV files as mm/dd/ format even if the dates are formatted dd/mm/ in the display. What's worse, if there are dates that are of ambiguous (6/6/2011) and unambiguous (16/6/2011) format in the same column

Re: [R] Excel-Export

The rcom package allows you to access the Excel object model from within R. So you can do essentially you can either do manually or by VBA from within Excel also from R. Formatting cells should not be too hard. Hans-Peter Suter wrote: > 2009/11/24 Kevin Wright : >> If had done a little searchi

Re: [R] Excel-Export

2009/11/24 Kevin Wright : > If had done a little searching before posting, you surely would have found > this link > https://stat.ethz.ch/pipermail/r-help/2008-July/169149.html > which describes how to create .xls files that are customized any way that > you desire. Manually convert to html, then

Re: [R] Excel-Export

If had done a little searching before posting, you surely would have found this link https://stat.ethz.ch/pipermail/r-help/2008-July/169149.html which describes how to create .xls files that are customized any way that you desire. Kevin Wright On Mon, Nov 23, 2009 at 7:02 AM, koj wrote: > > De

Re: [R] Excel-Export

Jens, 2009/11/23 koj : > library(xlsReadWrite) > Everything is fine, but the format of the export is not the best. For > example, I every time have to adjust the column width. Furthermore there is > no possibility to highlight some cell or make them colourful. Auto-col is supported by the underly

Re: [R] Excel-Export

On Nov 23, 2009, at 7:02 AM, koj wrote: Dear all, i use the following package/syntax to export data to excel: library(xlsReadWrite) write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) Everything is fine, but the format of the export is not the best. For exampl

Re: [R] Excel-Export

Use the RDCOMClient package from omegahat.org. On Mon, Nov 23, 2009 at 11:02 AM, koj wrote: > > Dear all, > > i use the following package/syntax to export data to excel: > > library(xlsReadWrite) > write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = > FALSE ) > > Everything i

[R] Excel-Export

Dear all, i use the following package/syntax to export data to excel: library(xlsReadWrite) write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) Everything is fine, but the format of the export is not the best. For example, I every time have to adjust the column widt

Re: [R] Excel Export in a beauty way

Another useful way to create a formatted Excel file is to write out an HTML file, but put an XLS extension on it. When Excel reads it, it will convert it. Users will treat it like an Excel file. This trick allows you to add formatted titles, table footnotes, links to other files (pdf graphs for exa

Re: [R] Excel Export in a beauty way

Hi, Here's a function to export dataframes to an excel-file with the RDCOMClient package. It makes bold headers and fits the column widths automatically. If more than one dataframe is provided to the function, the dataframes are saved to seperate spreadheets within file. export.xls <- functi

Re: [R] Excel Export in a beauty way

Also see this post at https://stat.ethz.ch/pipermail/r-help/2008-July/169149.html The same idea is discussed in a SAS proceedings paper (but it is NOT specific to SAS) www.lexjansen.com/wuss/2005/data_presentation/dp_using_*sas*_with_xml.pdf

Re: [R] Excel Export in a beauty way

On Wed, 03-Jun-2009 at 08:54AM -0500, Marc Schwartz wrote: [...] > For example, using the Perl package that I do for the WriteXLS > package, it is not possible to use the "AutoFit" capability to > easily set all column widths wide enough to visually allow for the > data contained within each. Fro

Re: [R] Excel Export in a beauty way

If you are willing to do the work RDCOMClient or rcom packages give you complete control. See example here: https://stat.ethz.ch/pipermail/r-help/2005-July/075877.html This assumes your platform is Windows and that you have R and Excel on the same machine so that R can control Excel. On Wed, Jun

Re: [R] Excel Export in a beauty way

Hi, I would just add, for myself, not for others who have developed R to Excel export packages, that the efficient export of data from R to a native Excel file is the priority. Formatting (columns, fonts, colors, etc.) in the resultant spreadsheets (for me) was not. There are also some fu

Re: [R] Excel Export in a beauty way

If you are working on Windows and Excel installed on the same machine as R, the rcom library by Thomas Baier gives you full programmability for Excel From R. You can control all the effect you want. You also could use the RExcel addin for Excel which allows to transfer date from R into Excel

[R] Excel Export in a beauty way

Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there

Re: [R] Excel export into R

Keizer_71 wrote: > > I have this in excel > > Control > 543_BU > 123_AT > 432_CU > > I want to be able to import to R so that it will read like this > > c<-c("543_BU","123_AT","432_CU") > > output: > [1] "543_BU" "123_AT" "432_CU" > > This is just a short version. I have about 20 rows and

Re: [R] Excel export into R

Hi Richie, I apologize. I thought i deleted this thread since it is resolved by using scan() function. thank you again, Kei Richard Cotton wrote: > >> I have this in excel >> >> Control >> 543_BU >> 123_AT >> 432_CU >> >> >> I want to be able to import to R so that it will read like this >

Re: [R] Excel export into R

> I have this in excel > > Control > 543_BU > 123_AT > 432_CU > > > I want to be able to import to R so that it will read like this > > c<-c("543_BU","123_AT","432_CU") See the help page for read.csv ?read.csv ...and the R Data Import/Export manual http://cran.r-project.org/doc/manuals/R-data

Re: [R] Excel export into R

There are a number of ways for importing from EXCEL. For example if you were to create a CSV file for EXCEL, you can read it like: > x <- read.table('/tempxx.txt.r', header=TRUE, as.is=TRUE) > x Control 1 543_BU 2 123_AT 3 432_CU On Wed, Mar 5, 2008 at 6:42 PM, Keizer_71 <[EMAIL PROTECTED]

[R] Excel export into R

Hello, I have this in excel Control 543_BU 123_AT 432_CU I want to be able to import to R so that it will read like this c<-c("543_BU","123_AT","432_CU") output: [1] "543_BU" "123_AT" "432_CU" This is just a short version. I have about 20 rows and i need a simpler way instead of typing