[R] reading quattro pro spreadsheet .qpw into R
marc_schwartz at me.com
Tue Feb 16 17:56:23 CET 2010
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?
Gnumeric comes with the ssconvert utility, but that does not appear to support .QPW files:
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:
More information about the R-help