wfopen: cannot get the "types=" option to work with xlsx

[etienne]

Hi,

I cannot get the correct syntax to use the 'types=' option of the wfopen command when opening an xlsx file, in order to force the type of a series (character, numeric, date, automatic). It always returns a syntax error (invalid format string), though I've tried many syntax variations (quoting or not, with/without parentheses for a single series, position of the option etc.). Is this option really implemented for xlsx files? If so, could you please show me an example command that would work?

An example of commands that returns such an error:

Code: Select all

wfopen "c:\Data\test.xlsx" range=a1:a4 nonames types=a wfopen "c:\Data\test.xlsx" range=a1:a4 nonames types="a" wfopen "c:\Data\test.xlsx" range=a1:a4 nonames types=(a) wfopen "c:\Data\test.xlsx" range=a1:a4 nonames types=("a")

I'm using EViews 8 (June 13, 2013 build).

Best regards,

Étienne

[dagfinnrime]

Hi,
I have been struggling with the same. Try capital letters for the type-codes.
Like

Code: Select all

wfopen "c:\Data\test.xlsx" range=a1:a4 nonames types=(A)