R help - Sep 2008 - xls to csv conversion via WinXP's context menu?

Frequently I need to convert a .xls to a .csv (for import into R) and I 
do this by opening the file in excel and saving it as a csv. I would 
rather do this using WinXP's context menu (right click the xls, choose 
"convert to csv") but I don't know of a utility that does this.
Any
ideas? Thanks, Mark

See ?xls2csv in the gdata package.

On Fri, Sep 5, 2008 at 6:45 PM, Mark Na <mtb954 at gmail.com>
wrote:
> Frequently I need to convert a .xls to a .csv (for import into R) and I do
> this by opening the file in excel and saving it as a csv. I would rather do
> this using WinXP's context menu (right click the xls, choose
"convert to
> csv") but I don't know of a utility that does this. Any ideas?
Thanks, Mark

Dear Mark,
I think you don't need to convert your xls files into csv files to read them
using R. There are several ways to read them such as
the RODBC package and ?read.xls in gdata. Now, if you really want to do the
conversion, try ?xls2csv in gdata as well.

HTH,

Jorge



On Fri, Sep 5, 2008 at 6:45 PM, Mark Na <mtb954@gmail.com> wrote:
> Frequently I need to convert a .xls to a .csv (for import into R) and I do
> this by opening the file in excel and saving it as a csv. I would rather do
> this using WinXP's context menu (right click the xls, choose
"convert to
> csv") but I don't know of a utility that does this. Any ideas?
Thanks, Mark
>
> ______________________________________________
> R-help@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.
>
	[[alternative HTML version deleted]]