USU  ››  Zvirongwa zvebhizimusi otomatiki  ››  Chirongwa chekiriniki  ››  Mirayiridzo yechirongwa chekurapa  ›› 

Ngenisa data kubva kuExcel

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Vhura hwindo rekupinza data

Kupinza data kubva kuExcel hakuna kuoma zvachose kana uchishandisa chirongwa chedu. Tichatarisa muenzaniso wekurodha runyorwa rwevatengi kubva kuExcel faira remuenzaniso mutsva XLSX muchirongwa.

Kuvhura module "varwere" .

Muchikamu chepamusoro chehwindo, tinya-kurudyi kuti ufonere menyu yemukati uye sarudza murairo "Import" .

Iwindo re modal rekupinza data richaonekwa.

Ndapota verenga kuti nei usingazokwanisi kuverenga mirairo yakafanana uye kushanda pahwindo rinoonekwa.

Kusarudza iyo yaunoda faira fomati

Kupinza faira nyowani XLSX faira, gonesa iyo ' MS Excel 2007 ' sarudzo.

Ngenisa faira template

Ziva kuti faira ratichange tichiunza kunze rine mastandard fields. Aya minda anowanikwa mune kadhi revatengi. Kana iwe uchida kupinza minda isipo, unogona kuraira kugadzirwa kwavo kubva kuvagadziri veiyo ' USU ' chirongwa.

Semuenzaniso, iyi ndiyo nzira iyo Excel file template yekupinza varwere inogona kutaridzika.

Asi minda iyi muchirongwa. Isu tinozadza minda iyi kana tichinyoresa mutengi mutsva. Zviri mavari kuti isu tichaedza kuunza data kubva kune Excel faira.

Munda "Zita" inofanira kuzadzwa mukati. Uye mamwe makoramu muExcel faira anogona kuramba asina chinhu.

Kusarudzwa kwefaira

Kana iyo yekupinza faira fomati yatsanangurwa, sarudza iyo faira pachayo kuti itakurwe muhurongwa. Zita refaira rakasarudzwa richaiswa mumunda wekuisa.

Iye zvino ita shuwa kuti iyo faira yakasarudzwa haina kuvhurwa muExcel yako chirongwa. Zvikasadaro, iyo inopinza ichakundikana, sezvo faira ichagarwa neimwe chirongwa.

Dzvanya bhatani re' Next '.

Hukama pakati pechirongwa minda uye Excel faira makoramu

Mushure meiyo yakatsanangurwa Excel faira ichavhura muchikamu chekurudyi chebhokisi rebhokisi. Uye kuruboshwe, minda ye ' USU ' chirongwa ichanyorwa. Isu ikozvino tinoda kuratidza kuti ndeipi ndima ye ' USU ' ruzivo rwechirongwa kubva kune yega yega yefaira reExcel ichaunzwa kunze kwenyika.

1. Tanga wadzvanya pakanzi ' CARD_NO ' kuruboshwe. Apa ndipo panochengetwa nhamba yekadhi remurwere.

2. Tevere, tinya kurudyi rwechikamu chemusoro wenyaya ' A '. Imo mukoramu iyi yefaira rakatorwa kunze kwenyika umo nhamba dzemakadhi dzakanyorwa.

3. Ipapo kubatana kunoumbwa. ' [Sheet1]A ' ichaonekwa kuruboshwe rwezita remunda ' CARD_NO '. Izvi zvinoreva kuti ruzivo ruchakwidzwa kumunda uyu kubva ku' A ' column ye excel file.

Ukama hwemarudzi ese

Nemusimboti mumwechete, tinosanganisa mamwe ese minda ye ' USU ' chirongwa nemakoramu eExcel faira. Mhedzisiro yacho inofanira kuva chinhu chakadai.

Zvino ngationei kuti ndima yega yega yakashandiswa kupinza inorevei.

• CARD_NO - nhamba yekadhi.

• ZITA - zita remurwere. Surname, zita uye patronymic.

• MOBILE - nharembozha.

• MOFONI - mamwe mafoni, senge nhamba yefoni yekumba.

Minda yese ine mazita anonzwisisika. Zvakakwana kuziva mazwi echiRungu akareruka kuti anzwisise chinangwa chendima yega yega. Asi, kana uchiri, chimwe chinhu chisina kujeka, unogona kubata zvakachengeteka technical support .

Ndeipi mitsetse inofanira kuregwa?

Ziva mufafitera rimwe chete raunoda kusvetuka mutsara mumwe panguva yekuunza.

Chokwadi, mumutsetse wekutanga weExcel faira, isu hatina data, asi misoro yemunda.

Dzvanya bhatani re' Next '.

Mamwe nhanho mubhokisi rekutumira

' Nhanho 2 ' ichaonekwa, umo mafomati emhando dzakasiyana dze data anogadziriswa. Kazhinji hapana chikonzero chekuchinja chero chinhu pano.

Dzvanya bhatani re' Next '.

' Nhanho 3 ' ichaonekwa. Mariri, isu tinofanirwa kuseta ese ' mabhokisi ekutarisa ', sezvakaratidzwa mumufananidzo.

Chengetedza import preset

Kana isu tichigadzira kupinza kwatinoronga kuita nguva nenguva, saka zviri nani kuchengetedza zvese zvigadziriso mune yakakosha faira faira kuitira kuti urege kudziisa nguva dzese.

Zvinokurudzirwawo kuchengetedza marongero ekutumira kana usina chokwadi chekuti uchabudirira kekutanga.

Dzvanya bhatani ' Chengetedza template '.

Isu tinouya nezita refaira rezvirongwa zvekupinza. Zviri nani kuichengeta munzvimbo imwechete iyo data data iripo, kuitira kuti zvese zvive munzvimbo imwechete.

Tanga maitiro ekuunza kunze

Paunenge wataura ese masetin'i ekunze, isu tinogona kutanga iyo yekupinza iyo pachayo nekudzvanya pane ' Mhanya ' bhatani.

Pinza mhinduro ine zvikanganiso

Mushure mekuuraya, unogona kuona mhedzisiro. Iyo purogiramu ichaverenga kuti mitsetse mingani yakawedzerwa purogiramu uye kuti vangani vakakonzera kukanganisa.

Kune zvakare log log. Kana zvikanganiso zvikaitika panguva yekuuraya, zvese zvichatsanangurwa murogi nechiratidzo chemutsara weExcel faira.

Kugadzirisa kukanganisa

Tsananguro yezvikanganiso murogi ndeyehunyanzvi, saka ivo vanozoda kuratidzwa kune ' USU ' programmers kuti vabatsire kugadzirisa. Ruzivo rwekufambidzana rwakanyorwa pawebhusaiti usu.kz.

Dzvanya bhatani re ' Kanzura ' kuvhara iyo dialog yekutumira.

Tinopindura mubvunzo muchibvumirano.

Kana asiri ese marekodhi akawira mukukanganisa, uye mamwe akawedzerwa, saka usati waedza kupinza zvakare, iwe unozofanirwa kusarudza uye kudzima marekodhi akawedzerwa kuitira kusabvisa zvakapetwa mune ramangwana.

Rodha preset paunenge uchiedza kuunza zvakare

Kana tikaedza kupinza zvakare data, tinodaidza iyo dialog yekutumira zvakare. Asi panguva ino mairi tinodzvanya bhatani ' Road template '.

Sarudza faira rakambochengetwa rine marongero ekunze.

Mushure meizvozvo, mubhokisi rebhokisi, zvese zvichazadzwa nenzira imwechete sezvazvaive kare. Hapana chimwe chinoda kugadzirwa! Iro zita refaira, faira fomati, zvinongedzo pakati peminda nemakoramu etafura yeExcel, uye zvimwe zvese zvinozadzwa mukati.

Nebhatani re' Inotevera ', unogona kuenda nematanho anotevera e dialog kuti uve nechokwadi chezviri pamusoro. Uye wobva wadzvanya bhatani rekuti ' Mhanya '.

Tumira kunze pasina zvikanganiso

Kana zvikanganiso zvese zvakagadziriswa, ipapo iyo data yekupinda execution log ichaita seizvi.

Uye zvinyorwa zvinobva kunze kwenyika zvichaonekwa mutafura.

Ona pazasi mamwe misoro inobatsira:

• Kupinza data muchirongwa
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana