Search found 482 matches

by EViews Steve
Tue Apr 10, 2018 12:08 pm
Forum: Suggestions and Requests
Topic: Matrix labels follow with PageCopy
Replies: 1
Views: 81

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: 116

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: 929

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: 929

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: 929

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: 929

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: 252

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: 252

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: 252

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: 131

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: 234

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: 234

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...
by EViews Steve
Sat Mar 17, 2018 4:59 am
Forum: Data Manipulation
Topic: Importing table from Excel
Replies: 1
Views: 113

Re: Importing table from Excel

Try our IMPORTTBL command. It'll basically allow you to import an Excel, HTML, or Text file into an EViews Table object. You will lose any source formatting such as column width/font/colors/links/etc. EViews will simply keep the text. With your workfile open, go to our File menu/Import/Table from fi...
by EViews Steve
Wed Mar 14, 2018 11:09 am
Forum: Programming
Topic: Save tables in specific excel worksheets
Replies: 7
Views: 331

Re: Save tables in specific excel worksheets

Yes, you can't programmatically create a single excel file with multiple sheets, each one from a different EViews table. But you can manually create one and then link each worksheet to the source CSV file to allow for easy updating. When EViews writes a CSV file, that's simply a comma delimited text...
by EViews Steve
Wed Mar 14, 2018 9:34 am
Forum: Programming
Topic: Save tables in specific excel worksheets
Replies: 7
Views: 331

Re: Save tables in specific excel worksheets

I would suggest a different method. You can use EViews' support for OLE to do a Copy / Paste Special to save the entire contents of your table to an Excel spreadsheet. This only works if your workfile has been saved and your table has a name (not UNTITLED). Copy all the table cells you want, switch ...

Go to advanced search