[R-SIG-Finance] EXCEL & R

[Paul Gilbert]

If you are going the other way (R -> Excel)  WriteXLS on CRAN seems to 
be a pretty good, platform independent option. It is direct, in the 
sense that you do not need to fiddle with intermediate files, ODBC, 
etc.  You do need some relatively up-to-date perl modules.

Paul

Ana Nelson wrote:
> An alternative, platform-independent approach to this issue is to use a
> library such as XLRD to parse an Excel binary file directly and then write
> this data to a delimited text file for subsequent import into R. This has
> the advantage of not requiring (a) Excel or (b) Windows. You'd need to know
> a bit of Python, or check out whether your scripting language of choice has
> a similar library, many do.
>
>
>
> On Thu, Sep 10, 2009 at 1:21 PM, Gabor Grothendieck <ggrothendieck at gmail.com
>   
>> wrote:
>>     
>
>   
>> See:
>> http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows
>>
>> On Wed, Sep 9, 2009 at 8:17 AM, Josh C. Chien <joshcchien at yahoo.com>
>> wrote:
>>     
>>> Hi R-all,
>>> In finance, EXCEL dominates over any products. It's a good interface with
>>>       
>> finance application.
>>     
>>> I like R but, sometimes, I can't use it for daily work.
>>> Just curious, does any guy know how to integrate EXCEL and R for working
>>>       
>> financial modeling ?
>>     
>>> Thanks a lot.
>>>
>>> Josh
>>>        [[alternative HTML version deleted]]
>>>
>>> _______________________________________________
>>> R-SIG-Finance at stat.math.ethz.ch mailing list
>>> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
>>> -- Subscriber-posting only.
>>> -- If you want to post, subscribe first.
>>>
>>>       
>> _______________________________________________
>> R-SIG-Finance at stat.math.ethz.ch mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
>> -- Subscriber-posting only.
>> -- If you want to post, subscribe first.
>>
>>     
>
> 	[[alternative HTML version deleted]]
>
> _______________________________________________
> R-SIG-Finance at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only.
> -- If you want to post, subscribe first.
>   
====================================================================================

La version française suit le texte anglais.

------------------------------------------------------------------------------------

This email may contain privileged and/or confidential in...{{dropped:26}}