Excel 2007/2010 and RATS 8.1

For questions and discussion related to reading in and working with data.

Excel 2007/2010 and RATS 8.1

Postby jonasdovern » Wed Nov 09, 2011 4:37 am

Does anybody else have trouble reading from xlsx-files with RATS 8.1?

When loading an xlsx-file and specifying "format=xlsx" I get the following error message
Code: Select all
Not XLSX workbook

Do I have to take something special into account when saving the Excel file?
jonasdovern
 
Posts: 82
Joined: Sat Apr 11, 2009 10:30 am

Re: Excel 2007/2010 and RATS 8.1

Postby jonasdovern » Wed Nov 09, 2011 5:37 am

I figured out that it is a problem of the Excel file rather than with RATS. But since I have a plain xlsx-file with only two sheets (see attachement) I am puzzled about what the problem is.
Attachments
US-Daten_RATS.xlsx
(810.06 KiB) Downloaded 215 times
jonasdovern
 
Posts: 82
Joined: Sat Apr 11, 2009 10:30 am


Return to Data: Reading, Writing, Transforming

Who is online

Users browsing this forum: No registered users and 1 guest