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
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 that are
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
On Fri, Jul 8, 2011 at 7:31 PM, Jim Lemon j...@bitwrit.com.au 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
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
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 kw.s...@gmail.com:
If had done a
Jens,
2009/11/23 koj jens.k...@gmx.li:
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
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
2009/11/24 Kevin Wright kw.s...@gmail.com:
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
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
Use the RDCOMClient package from omegahat.org.
On Mon, Nov 23, 2009 at 11:02 AM, koj jens.k...@gmx.li 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 )
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
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
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 -
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)
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
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.html
Two things
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 i need a simpler
way
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 each one.
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]
20 matches
Mail list logo