similar to: Excel -> *.CSV in Unix (Linux) command line?

In R, How to read Excel file and access the data item? Thank you. --------------------------------- [[alternative HTML version deleted]]

Here''s an interesting problem: In my app, we are indexing various types of documents, including microsoft powerpoint. Powerpoint documents are mostly binary, but have a bunch of text (all of the text in the document?) as well. My thinking is that the binary will never get searched for, and the proper text will be indexed and queried as expected, so the indexed binary will never

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 have data that comes in every 7 seconds or so and I'd like to display it in a spreadsheet, and possibly take user input from the spreadsheet. I have installed RGnumeric and written an appropriate R function that reads, manipulates and displays the data by writing via RGnumeric to a spreadsheet. However, the results of this are not displayed until the R function returns, so refreshing by

I have Excel files containing data that I would like to move to R. They are in the standard form of a one row header followed by rows of data, one record per row EXCEPT that there are a few rows of comments before the header. The number of rows of comments varies. For Excel files of this form without comments I have had success with: require(RODBC) z <-

Hi all, A hopefully quick query. I was reading a posting over at gnomedesktop.org on the latest release of Gnumeric 1.4: http://gnomedesktop.org/node/2090 There is a mention there: Improved accuracy: While Gnumeric 1.2 was already the best available source for accuracy in statistical calculations, Gnumeric 1.4 is even better. We are cooperating with The R Project to

Hi All, A group of about 3-4 of us are looking into the possibility of incorporating R into OpenOffice's (OO) spreadsheet component (sc) . We wish to use OO's nice ODBC ability to query a postgresql-based gene expression database thus populating an OO sc and then use Bioconductor via R to analyse user-selected parts of this spreadsheet. We've looked at and compiled and used

I am new to the ROR and just got stucked into something.... ....that is i have to scan a word document through ruby... Please suggest me how to do...... -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this

Hi all, As happens from time to time, discussions on this list appear regarding the use of popular spreadsheets for statistical analysis. One such thread (post of mine) is here: http://maths.newcastle.edu.au/~rking/R/help/03a/6326.html While not advocating such use, these discussions have referenced articles that provide independent reviews of these applications and issues of accuracy, etc.

On Sat, Jul 26, 2008 at 10:13 AM, Iain Lee <menelaus at spartica.net> wrote: > Paul, > > Thanks your contribution, I too miss gnumeric. However, I get these errors > and the installed gnumeric crashes on opening a gnumeric file: > > ============================================================================= > Package Arch Version

Hi, I had some excel files that I needed to read into R, there were alot so I didn't want to do them by hand in gnumeric. I tried all the recommendations in the data import/export manuals, including RODBC, and for some reason they all failed on these files. Then I stumbled on ssconvert, a script that wraps all gnumerics converters, see

"yum update" output: ............................... --> Running transaction check --> Processing Dependency: libgoffice-1.so.2 for package: gnumeric ---> Package goffice.i386 0:0.6.6-1.el5.rf set to be updated --> Finished Dependency Resolution 1:gnumeric-1.6.3-15.el5.2.i386 from installed has depsolving problems --> Missing Dependency: libgoffice-1.so.2 is needed by

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my

I'm trying to install Gnumeric using the kbsingh RPMs. Has anyone been able to use these with CentOS 5? Loading "installonlyn" plugin Setting up Install Process Setting up repositories kbs-Extras-i386 100% |=========================| 951 B 00:00 kbs-Misc-i386 100% |=========================| 951 B 00:00 updates 100%

I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from rpmforge anyway). Is the current CPAN version better? Or the equivalent java tools? Or

Hi all, I'm trying to do a simple curve fit and coming up with some interesting results I would like to get comment on. So as shown below, tsR is my explanatory and response is... well... my response. This same data in gnumeric gets fitted with the curve "response=10078.4 + 1358.67 * ln (explanatory - 2009.07) So I'm using nls with the start values supplied by gnumeric. in

Hi, I can't seem to get any Excel Add-Ins to work. In particular, I need the 'Solver' for an assignment ... I've tried with two office versions (2007/2003), which I've managed to install successfully (you have to enable the Solver add-in during installation), but it's the same every time. When I try to start it up I get a message saying can't access SOLVER.XLA, and

Hi, I just read the "Embedding R in Gnumeric" idea at http://www.r-project.org/SoC08/ideas.html. On my side, I intend to add as many statistics related plot types to the current gnumeric charting engine as possible. We already have boxplots and partial support for histograms. My immediate plans are to finish the histogram code and add probability plots

Dear R-users, I have the following problem In a lab experiment I have to mix three solutions to get different concentrations of various molecules in a cuvette I've used R to calculate the necessary ?liters for each of the level of the experiment and I must confess that it is more useful and easier to achieve the results than using spreadsheets. But there's a problem. Imagine that

Both packages are listed on the website, but neither installs here: gnumeric: ... Cannot find xml2-config ERROR: configuration failed for package ?XML? * Removing ?/usr/local/lib/R/site-library/XML? * Installing *source* package ?gnumeric? ... ** R ** preparing package for lazy loading Warning in library(pkg, character.only = TRUE, logical.return = TRUE, lib.loc = lib.loc) : there is no package