Add-in crashing when attempting to import data from Excel
Posted: Thu Jan 30, 2014 10:22 am
Hi,
I created an add-in within Eviews that imports data from excel. It utilises the following command
import(type=excelxml, c=max) %dir range=%shtRng @id {%id}
And then a reference table with the directory,range and ID required to import the required data, e.g. if you have x data sources there are x lines of the table that the code will run through . I'm new to programming, not sure if it's common practice to post the whole code, happy to do so if needs be.
Eviews will usually crash if I am trying to populate a new workfile with new variables and I attempt to run through several data sources, if I do the same exercise running the programme X times for each individual data source then it will not crash. If I then run the same programme in the same workfile now fully populated it will not crash no matter whether I run each line of the data import table individually or in one execution.
Hopefully you can help, thanks for your time.
Cheers,
Asher
I created an add-in within Eviews that imports data from excel. It utilises the following command
import(type=excelxml, c=max) %dir range=%shtRng @id {%id}
And then a reference table with the directory,range and ID required to import the required data, e.g. if you have x data sources there are x lines of the table that the code will run through . I'm new to programming, not sure if it's common practice to post the whole code, happy to do so if needs be.
Eviews will usually crash if I am trying to populate a new workfile with new variables and I attempt to run through several data sources, if I do the same exercise running the programme X times for each individual data source then it will not crash. If I then run the same programme in the same workfile now fully populated it will not crash no matter whether I run each line of the data import table individually or in one execution.
Hopefully you can help, thanks for your time.
Cheers,
Asher