similar to: Why Excel is our friend

Even using the VBA back of Excel to create interfaces with R would make a lot of sense. Suppose I could have access to VBA macros that import and export data into R , it would be great. The R GUI series like Rattle come even closer to Excel...so a VBA _R_ExCel package might be useful to ordinary folks . Besides Excel costs money, so adding R functions to Open Office would help both of them ( if

Readers of this list might be interested in the following article in the New York Times and might find amusing the notion that "Some people familiar with R describe it as a supercharged version of Microsoft's Excel spreadsheet software...". http://www.nytimes.com/2009/01/07/technology/business-computing/07progra m.html?_r=1&ref=technology Art

Hi everyone, I'm trying to plot some data across time. I have a list of articles, ranks, date/times, authors, etc. Someone suggested using zoo and someone suggested using ts. I'm pretty new at this and have been trying a simple if() plot() statement, but it doesn't seem to work. I keep getting an error that Title does not exist. Basically its saying that the headers do not exist as

Greetings all, This isn't a request for help, but I thought the following article from the New York Times would be of interest to you all. Enjoy! Adam *Data Analysts Captivated by R's Power* By ASHLEE VANCE Published ONLINE: January 6, 2009 URL: http://www.nytimes.com/2009/01/07/technology/business-computing/07program.html A version of this article appeared in print edition on

Suppose a user submits a url: http://www.nyt.com/education/2345545. How can this be shortened to a cleaner url, like nyt.com? -- Posted via http://www.ruby-forum.com/.

I worked on some ad data before and I found NYT article very biaised and not far from a fraud... Anyone knows if they got money from a - company - to play 'R'? Check out the title: R U Ready for R? Seems to me this title was stolen from XLSolutions www.xlsolutions-corp.com and they never mentioned XLSolutions in the article! They mentioned commercial R....never mentioned

Hi, I?m attempting to export data (split into multiple files from one large dataset) from R to excel using the excel.link package. The code for export is as follows: for(i in practicesNN){ #Create relevant data for input #Separate out all parts of data ? PracticeName is removed from example data for privacy reasons detailedH<-dataExport2[dataExport1$PracticeName == i &

Dear Group, I hope someone out there can help me with this. I am building a Rails 2.0 application for a customer. The customer has a number of Excel spreadsheets which he would like his customers to open and complete online then submit the completed spreadsheet to him via email. A typical scenario would be: (1) The ''empty'' spreadsheets are provided as a list on the web site.

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

Hi I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows XP Pro. I am having problems writing a new table to an (Excel) database using sqlSave. I connect to an empty Excel spreadsheet using odbcConnectExcel (which, I believe, uses the Microsoft Excel Driver DSN). Then I try and save a new table to the database(spreadsheet) using SqlSave, but obtain an error message. Below is

I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. Usage ----- perl xls2csv.pl <excel file> [<output file>] [<worksheet number>] Translate the Microsoft Excel spreadsheet file contained in <excel file> into comma separated value format (CSV) and store in

I accidently replied to the individual instead of the message board when I sent this the first time. Chris Wright Network Specialist Information Technology Outreach Services (ITOS) University of Georgia (706) 542-1976 cwright@itos.uga.edu -----Original Message----- From: Chris Wright Sent: Thursday, May 08, 2003 10:05 AM To: 'John H Terpstra' Subject: RE: [Samba] force group parameter

Hi All, Created xls file using spreadsheet Excel is not read on linux. I am creating an xls file are as follows workbook = Spreadsheet::Excel.new("Filepath") worksheet = workbook.add_worksheet("Sheet1") | | | workbook.close but when i am trying to download this it not get download. -- Posted via http://www.ruby-forum.com/.

Hello, My name is Misha Patel and I’m reaching out on behalf of the HackIllinois Outreach team. HackIllinois is a 36-hour collegiate Open Source hackathon that takes place annually at the University of Illinois Urbana-Champaign. This year, it will be from February 28th-March 1st, 2020. Our mission is to introduce college students to Open Source, while giving back to the community. We strive to

On Mon, Dec 06, 2004 at 12:33:19PM -0600, Paul Bryson wrote: > > The second would be for projects that want to maintain their old design. > This involves the simple addition of a "banner" across the top that > contains some type of Xiph branding. This would be a lot like what is at > the top of http://www.speex.org/ I don't want to see us become a monolithic

Hi, We have a problem like I've never seen in 8 years of running Samba in production. Two users can overwrite each other's open Excel spreadsheets. It occurs very infrequently, basically randomly, never happens on a recently restarted smbd instance, and is extremely difficult to troubleshoot due to samba switching process ownership from the user to "root" shortly after

Hello, On 16 Okt., 20:02, "AN@S" <anas.marr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > Hello, > > I''m running into a project where a client has large Excel files > (60.000+ records per file) and he needs an application to import them > into a database to use this data for useful operations (reporting, > calculations .. etc). > > I know

Hi everyone, X.Org will join the Outreach Program for Women (OPW) in Round 9 (December 2014 - March 2015). The OPW is "open to anyone who was assigned female at birth and anyone who identifies as a woman, genderqueer, genderfluid, or genderfree regardless of gender presentation or assigned sex at birth." For more details on the program see https://wiki.gnome.org/OutreachProgramForWomen

CONTENTS: Meeting days/times & Howto - Mark your calendar's dates; Videos; Hot topics; Opportunities; Announcement Flyers; New webpages ===== Come join in with the Global Free SW HW & Culture community at the BerkeleyTIP/GlobalTIP meeting, via VOIP. Two meetings this month: Sat Nov 7, 12Noon - 3PM Pacific Time (=UTC-8) Sun Nov 22, 12Noon - 3PM Pacific Time (=UTC-8) Mark your

We have some Excel spreadsheets stored on our Samba 2.2.8 fileserver. The permissions are set such that some users can write to these and some cannot, but they can all read them (the world-readable bit is set). When a user with read/write access tries to open the spreadsheet, there is no problem. The user is happy and productive and outside the sun is shining. Excellent! Have a biscuit! When a