Me pēhea te ki te whakatuwhera mō te whakatika i te kōnae XML i roto i te Excel: he torutoru huarahi ohie

E mea pinepine, te tahi mau kaiwhakamahi i ki te mahi ki te kōnae XML e tohu nga raraunga i runga i te pūtake o te tāuru i te tautuhinga whakaahuatanga tūtohu pūmanawa ranei. Kia puaki ia ratou mo whakatika i roto i te mua pāwhiri-rua e kore e mahi. Ko e tika ana ki te meka i hoki e kore e te rōpū ki te toronga i te tono whakamahia e te i te taunoa tenei. Otiia, ki te hiahia koe ki te tiki i tētahi kōnae tangata-pānui rite te tepu e taea te whakatika, ka taea e koe te whakatuwhera i tētahi kōnae XML i Excel. e kore e hiahia ana koe tetahi pūtahuri e taea tahuri hōputu waenganui i a ratou ano. Te arai anake: he wātea tenei āhuatanga anake i roto i te Tari putanga 2003 me putanga teitei.

Me pēhea te ki te Whakatūwhera XML ki Excel: te ara tuatahi

A feruri i te kawemai o putanga Excel-e hāngai ana o te raraunga i roto i te 2016. Ko te ara tuatahi, me te māmā, ko te ki te tīmatanga tīmata te hōtaka Excel. I te tīmatanga o te mihi me te tono logo whakaatu te matapihi takiuru motuhake i roto i nei te tahua i runga i te maui i reira ko te aho "Whakatūwhera te tahi atu mau buka."

I muri i taua, te whakamahi i te rarangi arotake, engari i roto i te matapihi hou i roto i te hōputu XML whiriwhiri te rite te whakatuwheratia. I muri i taua, ko te tikanga o mua kitea tatou te kōnae e hiahiatia ana, ka pāwhiri i te pātene tuwhera. I roto i tenei take, e kore whakaae te-kōnae XML Excel rite te tuhinga kuputuhi kei roto i te whakaahuatanga, me tūtohu, rite pai rite te tepu tino noa. O te akoranga, e taea te whakatika te raraunga i runga i tou ake, engari atu i runga i taua i muri.

Me pēhea te ki te whakatuwhera hōputu XML i roto i te Excel: he ara ki te tuarua

Whakaritea e kore e rere ke i te kotahi tikanga i tonoa tuatahi. kōnae XML i Excel, ka taea e koe te whakatuwhera i te tahua Kōnae whakamahi i te huinga tere Ctrl + O. ranei

Ano, te tuatahi tīpako i te momo o te hōputu ki kia whakatuwheratia, na te kōnae e hiahiatia ana, ka pēhi i te pātene hāngai.

Whakatuwhera XML: ara ki te toru o

He maha ngā tikanga o te iritiraa i te kōnae XML i Excel. Ko te kupu, i roto i te putanga o te hōtaka i roto i te 2016, ka taea e koe te whakamahi i te tihi tahua pae, te wahi tīpakohia te wāhanga "Raraunga" ko, a ka pēhi i te Tiki Waho Raraunga.

I roto i te tahua taka-iho, noa tīpako i te wāhanga "Mai i ētahi atu puna" i roto i te tahua hou, te whakamahi i te aho "Mai i te Kawemai XML". aru ana tēnei e te tikanga paerewa o rapu mo te kōnae e hiahiatia ana, me te ka tuwhera.

Whakatika, e whakaora me te kaweake

A, no te te whakamahi i tetahi o enei tikanga, riro te kaiwhakamahi te hanganga tepu. mahi Whakatika e i roto i te ara ano i rite ki ta te ki ngā kōnae XLS paerewa. I te tahi taime, no te te haratau o te whakatika me te whakaora i te raraunga kia whakamahia mo te tahua ngā.

I roto i tenei take, ka taea e koe anake kawemai i te tirotiro katoa o te-kōnae XML, engari anake te mea te mea tino tika, te whakauru i te mōhiohio i roto i te pou e tika ana, me nga rarangi, tuhu ki reira XML-ahanoa rite te puna raraunga. Ko hoki tenei te mea e tika i roto i te hōtaka ki te takiuru roto ki tō pūkete mā te whakamahi i tō rēhitatanga i Microsoft.

Whakaorangia te kōnae ētita taea e tika i roto i te hōputu taketake mā te tīpako i te momo i te rārangi. Mai i te tahua Kōnae, kua ki te kua ora te ahanoa i roto i te "hōputu» Excel taketake, ka taea e koe te tīpako i te āhuatanga kaweake, pāwhiritia i runga i te momo kōnae, me te huri whakaturia rite te hōputu whakamutunga ko te XML.

Ki te ko te kaiwhakamahi mangere rawa ki te whai wāhi i roto i taua hanganga, whakamahia e te reira i te putanga e whai ake o Office putanga 2003, mo te whakatuwheratanga o tenei hōputu roto i te puka o te tepu ranei Me ki te whakamahi i te pūtahuri motuhake. patua ana taua hōtaka inaianei rawa te rota. I roto i te take tino, ki te kore e pai i te reira, e kore raruraru koe e taea e kōrero ki te motuhake ratonga ipurangi ki runga i ka puta ke hōputu roto o tekau o hēkona te tokorua. I te mutunga o taua mahi ka tiki anake te hua oti i roto i te hōputu XLS ki tō puku mārō, me te ka whakatuwhera i te reira i roto i Excel. Heoi, i roto i te nuinga o te wā, e hiahiatia ana taua mahi te, pera i roto i te taua Office 2003 mo te whakatuwheratanga hāngai whakaratohia kua (kawemai) hōputu XML te tīmatanga. A te mea te reira, torutoru iwi i tenei ra whakamahi pakeke hua Microsoft Office.