Kaweake i te Excel ki te XML me te rereke

Ka taea e koe te huri i te konae Excel ki te konae raraunga XML, he rereke ranei. Ma tenei ka taea te whakawhiti korero i waenga i nga tono rereke. Hei timata, whakatuwherahia te ripa kaiwhakawhanake (Kaiwhakawhanake).

Anei nga raraunga e hiahia ana matou ki te huri hei konae XML:

Tuatahi, me hanga he aronuinga i runga i nga raraunga XML taketake. Ka tautuhi te aronuinga i te hanganga o te konae XML.

  1. Kaore i te pai a Excel mo tenei kaupapa, na reira tuwhera, hei tauira, Notepad ka whakapiri i nga rarangi e whai ake nei:

       

          Smith

          16753

          UK

          Qtr 3

       

       

          Johnson

          14808

          USA

          Qtr 4

       

Tuhipoka: Ka whakaingoatia nga tohu i runga i nga ingoa pou, engari ka taea e koe te hoatu ingoa e pai ana koe. Hei tauira, hei utu mo - .

  1. Penapenahia te konae hei schema.xml.
  2. Whakatuwheratia he pukamahi Excel.
  3. Pāwhiritia te pūtake (puna) ripa kaiwhakawhanake (Kaiwhakawhanake). Ka tuwhera te paetaumahi XML.
  4. Hei taapiri mapi XML, pawhiria te paatene Mahere XML (Mapi XML).Ka puta he pouaka korero Mahere XML (Mahere XML).
  5. press Tāpiri (Apiti).
  6. Tīpakohia schema.xml me te pawhiri rua OK.
  7. Inaianei toia me te whakataka kia 4 nga mea mai i te rakau i te paetaumahi XML ki runga i te rau (rarangi 1).
  8. pēhi Kaweake (Kaweake) i te waahanga XML ripa kaiwhakawhanake (Kaiwhakawhanake).
  9. Tiakina te kōnae ka paato E tomo.

Hua:

Ka whakaora tenei i te wa roa!

Tuhipoka: Hei kawemai i te konae XML, whakatuwherahia he pukamahi tuwhera. I runga i te ripa kaiwhakawhanake (Kaiwhakawhanake) pawhiria Kawemai (Kawemai) ka tohua te konae XML.

Waiho i te Reply