Page 1 of 1
extracting a table to Excel
Posted: Sun Jul 20, 2014 11:47 am
by eddylle
Hi,
What is the simplest way to export a table (logit model) into an excel file? I've tried to copy/paste it but the dots do not make any sense in the copied version.
Thanks
Re: extracting a table to Excel
Posted: Sun Jul 20, 2014 11:57 am
by EViews Gareth
Could you provide more details?
Re: extracting a table to Excel
Posted: Sun Jul 20, 2014 4:37 pm
by eddylle
I've got a logistic regression table, and I just want exactly the same table but on a .xlsx format, so export it from eviews format to excel format.
Thanks
Re: extracting a table to Excel
Posted: Sun Jul 20, 2014 9:37 pm
by EViews Gareth
Copy and paste.
Re: extracting a table to Excel
Posted: Mon Jul 21, 2014 12:58 am
by eddylle
That's the point, I've tried it but we I do, I've got dots instead of comma in eviews, so a 35.500 (thirthy-five and a half) in eviews becomes a 35500,00 (thirthy-five thousands) in excel. As I have 15 explanatory variables, I'd like to avoid to change manually the dots for commas....
Re: extracting a table to Excel
Posted: Mon Jul 21, 2014 7:51 am
by EViews Gareth
That's a problem with the way Excel is interpreting the numbers. Try right clicking on the table and then saving it to disk as a CSV file, then opening that file up in Excel.
Re: extracting a table to Excel
Posted: Mon Jul 21, 2014 7:58 am
by eddylle
Seems to work, Thanks!