creating a workfile for panel data

[facosta]

Hello. Thanks again for all the support.
I am working with panel data, and the spreadsheet with the data I am using is continuously updated. So my question is how can I give a panel structure to the workfile so I can import from the excel without previously giving the workfile a start and an end date.
For example, I know I can use this command:
wfcreate(wf=PANEL_DATA, page=Variables) m 1980m1 2010m12
But what I would like to do is to give a panel structure without an end date since what I need to do is to read from the excel data I am importing the date structure.
Thank you!

[facosta]

I´m thinking maybe it can´t be done since no one answer.
Another question, is there a way you can import all the data contained in an excel spreadsheet no matter if you have a column filled with blanks (ie no data)?
I am using the import or wfopen commands but they read only from the first column to the last column with data, however the following columns contain data but they are not loaded in the workfile page. For example, the excel file I have data from "A" to "M" columns, but the "E" column is empty, the following data are from "F" to "M" columns so my program loads only the data from "A" to "D", the following are not read.
Thanks.

[EViews Gareth]

You can't create a workfile with no end date (it's a bit like asking to create a piece of string with no end).

The import command does let you resize the workfile to the size of the incoming data, though.

Both import and wfopen let you specify the range of Excel cells to bring into EViews

[facosta]

Thanks Gareth. The thing is I was trying to import all the data but my excel spreadsheet contains blank columns, and the import command import just read the data until the last column filled with data, can I fix this somehow?
The command I am usins is the following:
import "C:\Program\Data.xlsm" range="Levels" @freq q 1993
Thanks!

[EViews Gareth]

Just specify the range of data you want to import.

[facosta]

I am sorry, I just can´t solve this. I try to give the range but it doesn´t work as I need.
I tried using @all but i think I am doing something wrong.
I am really sorry all the questions.

[EViews Gareth]

Currently you are using

Code: Select all

range="Levels"

to specify the Excel range that you want to bring in. You can change this to be whatever Excel range you want. Just use standard Excel range syntax to specify different parts of the spreadsheet. i.e., if you want to bring in columns A, B and D, rows 1 to 20, then the range would be "A1:B20, D1:D20" or something like that.

If you're unsure how to use Ranges in Excel, I'm sure a brief Google search can help out.