DosTips.com

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>

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