XML file to Excel, error when opening

Question

I have this file here:

<?xml?>
<table name="data">
<row et_kt="215846" et_nafn="" et_kt_maka="" et_kt_fjolsk="215846" et_kyn="X" et_hjusk_stada="1" et_faeddag="190201" et_danrdag="198612" />
<row et_kt="239287" et_nafn="" et_kt_maka="" et_kt_fjolsk="239287" et_kyn="X" et_hjusk_stada="4" et_faeddag="190401" et_danrdag="199106" />
.
.
.
</table>

Excel tell me the file is in a different format than the .xml implies. What's wrong with the format?

Community · Accepted Answer · 2017-05-23 11:43:22Z

1

Try changing <?xml?> for <?xml version="1.0"?>.

EDIT: Check this answer for some extra information about the issue.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Jul 12, 2013 at 15:35

Racso

2,4691 gold badge20 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

KSHMR Over a year ago

Your edit: Thank you, that solved the problem! I was missing version="1.0".

Artful_dodger · Accepted Answer · 2013-07-15 13:32:39Z

1

at first glance I'd say that that there is no valid xml declaration ie <?xml version="1.0" encoding="UTF-8" ?> or as it a microsoft product may be you should try <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>

edited Jul 15, 2013 at 13:32

answered Jul 12, 2013 at 15:54

Artful_dodger

7382 gold badges7 silver badges26 bronze badges

Collectives™ on Stack Overflow

XML file to Excel, error when opening

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related