PC-HELP.CZ

Dobry den,
potreboval bych poradit. Mam tabulku v Excelu (viz priloha) a potrebuji ji dostat do nasledujiciho formatu:

Multiple choice (jen jedna otazka spravne) vypada nasledovne:

<item>
<type>mc</type>
<question id="2" shuffle="y" scorelevel="0" points="1" feedback="n" feedbackok="Correct !" actionok="0" feedbackwrong="Incorrect !" actionwrong="0" attempts="9999" audio="n" time_limited="n" hh="0" mm="0" ss="5" time_limited_show="n" expanded="1">Who won the World Cup in 1970</question>
<scenario scinclude="0"></scenario>
<answer correct="y" id="1" feedback="" points="10" action="0">Brazil</answer>
<answer id="2" feedback="" points="10" action="0">England</answer>
<answer id="3" feedback="" points="10" action="0">West Germany</answer>
<answer id="4" feedback="" points="10" action="0">Italy</answer>
</item>

Multiple response (vice odpovedi spravne) vypada nasledovne:

<item>
<type>mr</type>
<question id="6" shuffle="y" scorelevel="0" points="1" feedback="n" feedbackok="Correct !" actionok="0" feedbackwrong="Incorrect !" actionwrong="0" attempts="9999" audio="n" time_limited="n" hh="0" mm="0" ss="5" time_limited_show="n" expanded="1">Which of these teams have won the World Cup more than twice</question>
<scenario scinclude="0"></scenario>
<answer id="1" feedback="" points="10" action="0">France</answer>
<answer correct="y" id="2" feedback="" points="10" action="0">Brazil</answer>
<answer correct="y" id="3" feedback="" points="10" action="0">Italy</answer>
<answer id="4" feedback="" points="10" action="0">Spain</answer>
</item>

kde kazda otazka bude pretvorena do podoby viz vyse. Hodnota <type>mc</type> se lisi podle toho zda se jedna o mutiple choice (mc) nebo multiple response (mr). question id="2" kde cislo se meni podle cisla otazky, pripadne jak si primo urcit pocatecni cislo od ktereho udelat inkrement +1 pro databazi (abych nemusel zacinat cislem 1 ale treba od cisla 55)

Poradite nekdo jak na to?

to dhous:
Excel pro makra (procedury) pouziva VBA, takze v dotazu uvedeny zapis pozadujes "prelozit" do VBA nebo neco jineho?

Pravdepodobne ano, pres VBA.
Takto komplikovany prevod xls do vyse popsaneho formatu (asi TXT vystup) je uz pro mne "vyssi divci"

Nejak nerozumim tomuto:

prevod xls do vyse popsaneho formatu (asi TXT vystup)

Pozadujes v Excelu generovat a vyhodnocovat otazky z tabulky za pouziti VBA nebo pouze pouzit excelovskou tabulku v jine aplikci coby zdroj dat?

Ne potrebuju pouze prevest data z excelovske tabulky do vyse popsaneho formatu - nic vic, nic min. Zadne vyhodnocovani. Jen konverze.