Ask Your Question

Problem to open fake XLS file

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

Dabola gravatar image

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

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

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

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

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

gabix gravatar image

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

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

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

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


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 +0100 )edit

I've got it now!

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

Question Tools

1 follower


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

Seen: 181 times

Last updated: May 12 '18