search for: ssconvert

...l, I have the following problem when reading files (a lot of them) in the spreadsheetML format into R. The spreadsheetML format is an xml format to allow easy import of multisheet data in Excel. As far as I can see, a direct import into R (using the XML package) is not feasible. I use the software ssconvert (included in Gnumeric) and call it from R. It converts the spreadsheetML into xls format. When I now import the newly created xls-file using RODBC package, the last row in each sheet is missing. However, when I open the xls-file the last row is present (hence, ssconvert doesn't delete it). When...

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 http://www.gnome.org/projects/gnumeric/doc/sect-files-ssconvert.html. I would suggest adding ssconvert to the import/export manual as an option for excel files. It seems to be very robust. Nicholas

Hi Peter, The ssconvert tool (part of gnumeric) is very good at converting spreadsheets to csv-files. There is a wrapper in the "gnumeric" package on cran. Cheers, Thomas > Date: Fri, 4 Oct 2013 09:08:50 +0100 > From: Barry Rowlingson <b.rowlingson at lancaster.ac.uk> > To: Peter Maclean <pma...

...an then get Fortran to output a file that is readable by R. I recommend using the CSV type (comma separated values) files -- they are tedious rather than difficult, and give very little problem for exchange between lots of programs (including spreadsheets -- I use Gnumeric as it has a very nice ssconvert function for use in command line scripts that can be automated. This would let you automate some of your work.) And I would make my intermediate files "verbose" i.e., with lots of labels etc. This will be more work to set up, but I think you will find you can debug things much quicke...

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 <-

CRAN (and crantastic) updates this week New packages ------------ Updated packages ---------------- New reviews ----------- This email provided as a service for the R community by http://crantastic.org. Like it? Hate it? Please let us know: cranatic at gmail.com.

...c looping over list name, value pairs in R (Duncan Murdoch) 41. fit printed output onto a single page (Abiel X Reinhart) 42. Lazy evaluation in function call (Thorn) 43. Re: Kernel density estimate plot for 3-dimensional data (Duncan Murdoch) 44. strange behavior of RODBC and/or ssconvert (stefan.duke at gmail.com) 45. Re: Idiomatic looping over list name, value pairs in R (Luis N) 46. Re: 3D version of triax.plot (package plotrix) (Gabriele Esposito) 47. Re: Kernel density estimate plot for 3-dimensional data (Pascal Martin) 48. Re: Kernel density estimate plot for 3-...