Ask Your Question
0

Problem to open fake XLS file

asked 2018-05-11 14:11:03 +0200

Dabola gravatar image

updated 2018-05-12 11:47:32 +0200

Hello!
I have problem to open an Excel file called "Exchange per country_2018_Daily" almost at the bottom of the list here. (Direct link to the xls-file)

By an old version of Office 2000 (and Windows 7) I it looks like this: image description

No way to export it as xml, csv,... By Libreoffice I am not able to make the right choice here: image description

Anyone that can give me a good advice?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2018-05-11 14:45:59 +0200

Regina gravatar image

The needed filter is Web Page Query (Calc) (*.html;*.htm;*.xhtml). You will find it in the file type drop-down-list of the file open dialog. You need not change the file name extension, if you first select the file and then select the filter.

edit flag offensive delete link more
0

answered 2018-05-11 14:18:16 +0200

gabix gravatar image

updated 2018-05-11 14:25:43 +0200

The file in question is not a true XLS file but a HTML file, and you can't do anything about it. Interestingly, the file opened pretty fine in AndrOpen Office on my smartphone (the dates in the first column, however, were imported as mere text, but it was rectified by ticking Detect special numbers on a second attempt of import). Well, try it.

edit flag offensive delete link more
0

answered 2018-05-11 17:15:08 +0200

Dabola gravatar image

Thank you very much!
Web Page Query - or "Nettsidespørjing" in Norwegian - solved the problem. I will bring over this information to the Nordpool Co., a market place for trading of electricity in Scandinavia/Northern Europe. (The file list up daily net import/export of MWh for 7 countries).

Regina, this was useful for me in another way; Many times I face problems when I try to download tables from webpages. Try/fail...try/fail... Now you have teached me to save the entire webpage and then do the job later - also when I'm oflline.

edit flag offensive delete link more

Comments

Do not answer your own question when it is not a real answer. Use comments. If you find an answer useful, upvote it using the < and > buttons on the left to the answer and tick the mark below to indicate that it solves the problem.

gabix gravatar imagegabix ( 2018-05-11 19:52:25 +0200 )edit

I've got it now!

Dabola gravatar imageDabola ( 2018-05-12 11:44:18 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-11 14:11:03 +0200

Seen: 73 times

Last updated: May 12 '18