Search found 530 matches

by EViews Steve
Wed Apr 25, 2018 10:13 am
Forum: Any Other Business
Topic: ADODB - Excel crasch when Connection is set to Nothing
Replies: 5
Views: 465

Re: ADODB - Excel crasch when Connection is set to Nothing

You don't need to reference the "EViewsOleDbProvider 1.0 Type Library" either. You only need that if you plan on instanciating the COM object directly which you are not doing. You're just passing the connection string that mentions our object's PROGID and having the ADODB.Connection object...
by EViews Steve
Tue Apr 24, 2018 8:06 am
Forum: Data Manipulation
Topic: Copying matrix to excel
Replies: 2
Views: 339

Re: Copying matrix to excel

Use our Excel Add-In to import and link your matrices into a specific cell range. In the Excel menu, click the Add-Ins tab. In the ribbon, look for the EViews group and click the Get Data button. example3.png Select your workfile. Next to Types, select "Vector/Matrix". example4.png Select ...
by EViews Steve
Tue Apr 24, 2018 7:54 am
Forum: Any Other Business
Topic: ADODB - Excel crasch when Connection is set to Nothing
Replies: 5
Views: 465

Re: ADODB - Excel crasch when Connection is set to Nothing

First, your code sample is only using our OLEDB provider, which has not changed between EViews 9.5 and EViews 10 (I just confirmed this by looking at the EViewsOleDbProvider.dll file in both program home directories and they're the same file). Also, using this OLEDB provider does not require you to ...
by EViews Steve
Tue Apr 10, 2018 12:08 pm
Forum: Suggestions and Requests
Topic: Matrix labels follow with PageCopy
Replies: 1
Views: 304

Re: Matrix labels follow with PageCopy

Fixed. It will be released in the patch after today's (Apr 3).
by EViews Steve
Mon Apr 09, 2018 2:06 pm
Forum: Programming
Topic: Importing data from an xlsx file
Replies: 2
Views: 400

Re: Importing data from an xlsx file

Our import wizard is usually pretty good and showing you what options are available during import. The one you're looking for is "Header type" on page 2 of the import wizard: scr1.png Then, it's a matter of correlating that option with our IMPORT documentation to find out what the exact na...
by EViews Steve
Tue Mar 27, 2018 12:31 pm
Forum: Bug Reports
Topic: addin -nowarn
Replies: 11
Views: 1353

Re: addin -nowarn

epikcoding wrote:Okay thank you! I guess we can expect the patch to come in April?

Probably next week.
by EViews Steve
Tue Mar 27, 2018 12:02 pm
Forum: Bug Reports
Topic: addin -nowarn
Replies: 11
Views: 1353

Re: addin -nowarn

Ok thanks for the file. I was able to reproduce the issue and I found the bug. It'll be fixed in the next patch.

Steve
by EViews Steve
Tue Mar 27, 2018 11:22 am
Forum: Bug Reports
Topic: addin -nowarn
Replies: 11
Views: 1353

Re: addin -nowarn

Ok we'll look into it. It'd be helpful if you sent me your AIPZ file (or whatever you have) so I can test it on my system and try to replicate your problem. If you can, please email it to support@eviews.com and reference this forum post in the email.

Steve
by EViews Steve
Tue Mar 27, 2018 10:59 am
Forum: Bug Reports
Topic: addin -nowarn
Replies: 11
Views: 1353

Re: addin -nowarn

I'm having the same issue as tvonbrasch. I am running the add-in commands inside a .prg file inside an add-in package. addin(nowarn, type="global", desc="Open Table", menu="Open Table") ".\Open_Tables.prg" What version of EViews are you using? Also, what is t...
by EViews Steve
Wed Mar 21, 2018 4:35 pm
Forum: Programming
Topic: Import a large number of excel files
Replies: 8
Views: 565

Re: Import a large number of excel files

What version of EViews are you using? And the build date? Mind posting one of your spreadsheets?
by EViews Steve
Wed Mar 21, 2018 7:47 am
Forum: Programming
Topic: Import a large number of excel files
Replies: 8
Views: 565

Re: Import a large number of excel files

Hi, I'm sorry I am not answering your question but I want to ask for your help. I am a new user on this forum and I would like to post up a question but I do not know how or where to do this. Where do I click? Which icon? Thank you Once you've entered a forum group page (such as this Programming gr...
by EViews Steve
Wed Mar 21, 2018 7:43 am
Forum: Programming
Topic: Import a large number of excel files
Replies: 8
Views: 565

Re: Import a large number of excel files

I need to import a large number of excel files with sheets numbered from 1_ to 100_ Is there an efficient way to import them? The tentative approaches below give me an error for !i = 1 to 100 read(e,c2,s={!i}_) OECD_CLI_EA.xls CLI_{!i} next for !i = 1 to 100 read(e,c2,s=!i_) OECD_CLI_EA.xls CLI_!i ...
by EViews Steve
Mon Mar 19, 2018 6:37 am
Forum: Data Manipulation
Topic: Series: history information
Replies: 2
Views: 353

Re: Series: history information

Code: Select all

series.@attr("history")
by EViews Steve
Sun Mar 18, 2018 9:03 am
Forum: Data Manipulation
Topic: Conference Board, TED: Labels - importing data
Replies: 4
Views: 519

Re: Conference Board, TED: Labels - importing data

Just change "Iso" to "Name" in the colheadnames argument: import TED_2_NOV20171.xlsx range=TCB_ADJUSTED!$A$5:$BU$1989 byrow colhead=6 namepos=custom colheadnames=("Region","Name","Country","Nr","Name","Description") na=&...
by EViews Steve
Sat Mar 17, 2018 5:31 am
Forum: Data Manipulation
Topic: Conference Board, TED: Labels - importing data
Replies: 4
Views: 519

Re: Conference Board, TED: Labels - importing data

Our IMPORT command actually supports reading in your data transposed so I don't think you need to do PAGESTACK. Also, our IMPORT command supports reading in multiple header rows and marking each as either part of the name, or part of the description, or as an attribute with the same name. You can de...

Go to advanced search