[R] reading quattro pro spreadsheet .qpw into R

[Marc Schwartz]

On Feb 16, 2010, at 10:35 AM, Barry Rowlingson wrote:

> On Tue, Feb 16, 2010 at 4:12 PM, stephen sefick <ssefick at gmail.com> wrote:
>> I have many quattro pro spreadsheets and no quattro pro.  Is there a
>> way to access the data using R, or any other solution that anyone can
>> think of?
> 
> OpenOffice claims it can read Quattro Pro 6.0 'wb2' files, but maybe
> they are different to .qpw files. MS Excel claims some Quattro Pro
> readability - I've just read something about wb1 files. Maybe Gnumeric
> can read them? What have you tried?
> 
> Perhaps if you put a representative file somewhere we can download and try?
> 
> Barry


Gnumeric comes with the ssconvert utility, but that does not appear to support .QPW files:

  http://projects.gnome.org/gnumeric/doc/file-format-qpro.shtml

I don't see any indication that Excel or OO.org's Calc support the .QPW format either.

It would appear that you can download a trial of Corel's WordPerfect Office suite, within which Quattro is bundled. You should be able to open the files in that application and then save them to .XLS formats:

  http://www.corel.com/servlet/Satellite/ca/en/Content/1152796555406

HTH,

Marc Schwartz