wfopen: cannot get the "types=" option to work with xlsx
Posted: Tue Oct 22, 2013 12:22 pm
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:
I'm using EViews 8 (June 13, 2013 build).
Best regards,
Étienne
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")Best regards,
Étienne