xls , calc , xlsx to xml with unicod fonts

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
Dipesh
Posts: 23
Joined: 13 Sep 2012 00:05

xls , calc , xlsx to xml with unicod fonts

#1 Post by Dipesh » 15 Dec 2019 01:03

Hellos,

Looking for batch script to convert xls , calc or xlsx to xml with unicode fonts</t>

I have tried with this but no luck. :- viewtopic.php?t=8295

I have question paper with 39 headers columns in xls file with values around 50 rows which I need to convert in xml format to upload.

Below is the exatly format to upload, and I have all this values in xls.

<question>
<enabled>true</enabled>
<type>single</type>
<difficulty>1</difficulty>
<position></position>
<timer>0</timer>
<fullscreen>false</fullscreen>
<inline_answers>false</inline_answers>
<auto_next>false</auto_next>
<description>01. પ્રશ્ન- (01)</description>
<explanation></explanation>
<answer>
<enabled>true</enabled>
<isright>true</isright>
<position></position>
<keyboard_key></keyboard_key>
<description>(ક) શરણાઈ</description>
<explanation></explanation>
</answer>
<answer>
<enabled>true</enabled>
<isright>false</isright>
<position></position>
<keyboard_key></keyboard_key>
<description>(અ) વાંસળી</description>
<explanation></explanation>
</answer>
<answer>
<enabled>true</enabled>
<isright>false</isright>
<position></position>
<keyboard_key></keyboard_key>
<description>(બ) પખવાજ</description>
<explanation></explanation>
</answer>
<answer>
<enabled>true</enabled>
<isright>false</isright>
<position></position>
<keyboard_key></keyboard_key>
<description>(ડ) મૃદંગ</description>
<explanation></explanation>
</answer>
</question>

aGerman
Expert
Posts: 4654
Joined: 22 Jan 2010 18:01
Location: Germany

Re: xls , calc , xlsx to xml with unicod fonts

#2 Post by aGerman » 15 Dec 2019 10:38

It's not about the font, it's all about character encoding in your source file. Without knowing which charset is used I can't even give you any advice. It will get complicated anyway.

Steffen

Post Reply