Fa'aulufale mai mea o se faila CSV i Excel

O le CSV o se faʻaopoopoga faila lauiloa e masani ona faʻaaogaina e fesuiai faʻamatalaga i le va o polokalame komepiuta eseese. Ole tele o taimi, e leai se mana'oga e tatala ma fa'asa'o ia pepa. Ae ui i lea, i nisi tulaga, e mafai e tagata faʻaoga ona feagai ma sea galuega. Excel e mafai ai ona e faia lenei mea, ae le pei o faila masani i le faatulagaga xls и XLSX, na o le tatalaina o se pepa e ala i le kiliki-lua o le isumu e le o taimi uma e maua ai se taunuuga maualuga, lea e ono mafua ai le le saʻo o faʻamatalaga. Se'i va'ai pe fa'apefea ona e tatalaina faila CSV i Excel.

Tatala faila CSV

Muamua, se'i tatou va'ai po'o a pepa o lo'o iai i lenei fa'atulagaga.

CSV o se faapuupuuga lea e tu mo “Tulaga Tu'ufa'atasia Koma” (in means “taua e tuueseeseina i koma”).

E pei ona taʻu mai e le igoa, o nei pepa o loʻo faʻaogaina faʻamaʻi:

• koma – i le gagana Peretania;
• semicolon – in versions of the program.

When opening a document in Excel, the main task (problem) is to choose the encoding method used when saving the file. If the wrong encoding is chosen, the user will most likely see a lot of unreadable characters, and the usefulness of the information will be minimized. In addition, the delimiter used is of key importance. For example, if a document was saved in the English version and then you try to open it in the version, the quality of the displayed information will most likely suffer. The reason, as we noted earlier, is that different versions use different delimiters. Let’s see how to avoid these problems and how to open CSV files correctly.

Metotia 1: Kiliki fa'alua po'o ala i le lisi o fa'amatalaga

Aʻo leʻi faʻagasolo atu i auala sili atu ona faigata, seʻi o tatou vaʻavaʻai i le sili ona faigofie. E faʻatatau i naʻo mataupu na fatuina / faʻasaoina le faila ma tatala i le faʻaoga tutusa o le polokalame, o lona uiga e le tatau ona i ai ni faʻafitauli i le faʻaogaina ma le faʻamalo. E lua filifiliga e mafai, o le a matou faʻamatalaina i lalo.

Excel ua setiina e avea ma polokalame le aoga e tatala ai faila CSV

Afai o lea, e mafai ona e tatalaina le pepa e pei o isi faila - na o le faalua-kiliki i luga.

O le isi polokalame ua tofia e tatala faila CSV pe le tofiaina uma

O le algorithm o gaioiga i ia tulaga e faʻapea (faʻaaogaina Windows 10 e fai ma faʻataʻitaʻiga):

1. Matou te kiliki-saʻo i luga o le faila ma i le lisi autu e tatala, matou te taofi i luga o le poloaiga “Ia tatala ma”.
2. I le lisi o ausilali, e mafai e le polokalama vave ona ofoina atu le polokalama Excel. I lenei tulaga, kiliki i luga, o se taunuuga o le a tatalaina le faila (pei o le faalua-kiliki i luga). Afai o le polokalama matou te manaʻomia e le o iai i le lisi, kiliki i luga o le mea “Filifili se isi app”.
3. O le a aliali mai se faʻamalama e mafai ai ona matou filifilia se polokalama (e faʻalautele le lisi o avanoa avanoa, e tatau ona e oomi le ki “Faaopoopo Apps”) lea e te manaʻo e tatala ai le pepa. Su'e mea tatou te mana'omia ma kiliki OK. Ina ia avea Excel ma faʻaoga faʻaoga mo lenei ituaiga faila, siaki muamua le pusa talafeagai.
4. I nisi tulaga, pe a le maua Excel i lenei faamalama, kiliki i le ki “Su'e se isi app i luga ole komepiuta lea” i le faaiuga o le lisi.
5. O le a faʻaalia se faʻamalama i luga o le lau lea matou te o ai i le nofoaga o le polokalame i luga o le PC, faʻailoga le faila faʻapipiʻi ma le faʻaopoopoga EXE ma oomi le faamau “Tatala”.

E tusa lava po o fea o metotia o loʻo faʻamatalaina i luga na filifilia, o le taunuuga o le tatalaina lea o se faila CSV. E pei ona ta'ua i luga, o le a fa'aalia sa'o le anotusi pe a fetaui le fa'ailoga ma le vavae.

I isi tulaga, e ono aliali mai se mea e pei o lenei:

O le mea lea, o le auala faʻamatalaina e le talafeagai i taimi uma, ma matou agai i luma i le isi.

Metotia 2: Fa'aoga le Wizard Text

Tatou fa'aoga le meafaigaluega ua tu'ufa'atasia i le polokalame- Matai Tusitusi:

1. O le tatalaina o le polokalame ma fatuina se laupepa fou, ina ia mafai ona maua uma galuega ma meafaigaluega o le siosiomaga faigaluega, sui i le tab. "Faʻamatalaga"lea tatou te kiliki i le faamau “Mauaina o faamatalaga mai fafo”. Faatasi ai ma filifiliga e oso i luga, filifili “Mai tusitusiga”.
2. O le a matala se faʻamalama e manaʻomia ona matou faʻafeiloaʻi i le nofoaga o le faila matou te manaʻo e faʻaulufale mai. A uma ona makaina, oomi le faamau “Aulafo”.
3. le Matai Tusitusi. Siaki pe ua filifilia le filifiliga “faatasi ai ma separatore” mo parameter “Faasologa o faamaumauga”. Ole filifiliga ole fa'asologa e fa'alagolago ile encoding na fa'aoga ile taimi e teu ai. Faatasi ai ma faʻasologa sili ona lauiloa o “Cyrillic (DOS)” и “Unicode (UTF-8)”. E mafai ona e malamalama o le filifiliga saʻo ua faia e ala i le taulaʻi atu i le muaʻi vaʻaia o mea i le pito i lalo o le faamalama. E fetaui i la tatou tulaga “Unicode (UTF-8)”. Ole vaega o totoe e masani ona le manaʻomia le faʻatulagaina, o lea kiliki le ki “Dalee”.
4. The next step is to define the character that serves as the delimiter. Since our document was created / saved in the version of the program, we select “semikolo”. O iinei, e pei o le tulaga o le filifilia o se encoding, matou te maua le avanoa e faʻataʻitaʻi ai filifiliga eseese, iloilo le taunuʻuga i le vaega muamua (e mafai, faatasi ai ma isi mea, faʻamaonia lau oe lava amio e ala i le filifilia o le filifiliga. "Isi"). A maeʻa ona faʻatulagaina tulaga manaʻomia, toe oomi le ki. “Dalee”.
5. I le faamalama mulimuli, o le tele o taimi, e te le manaʻomia le faia o ni suiga i tulaga masani. Ae afai e te manaʻo e sui le faatulagaga o se koluma, kiliki muamua i le pito i lalo o le faamalama (field "Faataʻitaʻiga"), ona filifili lea o le filifiliga talafeagai. Oomi pe a sauni “Sauni”.
6. O le a aliali mai se faʻamalama lea matou te filifilia ai le auala e faʻauluina ai faʻamatalaga (i luga o se pepa o loʻo i ai poʻo luga o se pepa fou) ma kiliki OK.
   • i le tulaga muamua, e tatau ona e faʻamaonia le tuatusi o le sela (pe tuʻu le tau faʻaletonu) o le a avea ma elemene agavale pito i luga o mea e faaulufale mai. E mafai ona e faia lenei mea ma le lima e ala i le ulufale atu i faamaopoopo e faʻaaoga ai le piano, pe na o le kiliki i luga o le sela manaʻomia i luga o le laupepa (e tatau ona i ai le cursor i le fanua talafeagai mo le faʻaogaina o faʻamatalaga).
   • pe a e filifilia le filifiliga faʻaulufale mai i luga o se laupepa fou, e te le manaʻomia le faʻamaonia o faʻasalalauga.
7. Ua saunia mea uma, na mafai ona matou faʻaulufaleina faʻamaumauga o le faila CSV. E le pei o le auala muamua, e mafai ona tatou matauina o le lautele o le koluma ua faʻaaloalogia, ma amanaʻia mea o loʻo i totonu o sela.

Metotia 3: e ala i le "File" lisi

Ma o le auala mulimuli e mafai ona e faʻaogaina o mea nei:

1. A uma ona amata le polokalama, filifili le mea “Tatala”.Afai ua uma ona tatalaina le polokalame ma o loʻo faia galuega i luga o se laupepa patino, alu i le lisi "Faila".Kiliki ile fa'atonuga “Tatala” i le lisi o poloaiga.
2. Faʻamau le faʻamau “Toe iloiloga”e alu i le faamalama faipese.
3. Filifili se faatulagaga "O faila uma", alu i le nofoaga o loʻo teuina ai a tatou pepa, faʻailoga ma kiliki le ki “Tatala”.
4. O le mea masani ia i matou o le a faʻaalia i luga o le lau. Fa'asinomaga Fa'aulufale Mai. Ona tatou mulimuli lea i laasaga o loʻo otooto atu i totonu Metotia 2.

iʻuga

O le mea lea, e ui lava i le faʻalavelave faʻapitoa, o le Excel polokalama e faʻatagaina atoatoa oe e tatala ma galue ma faila i le CSV format. O le mea autu o le filifili i le auala o le faʻatinoga. Afai, pe a tatalaina se pepa masani (kiliki faalua pe ala i le lisi lisi), o mea o loʻo i totonu o loʻo i ai ni mataitusi e le mafai ona malamalama i ai, e mafai ona e faʻaogaina le Text Wizard, lea e mafai ai ona e filifilia le faʻailoga talafeagai ma le vaeluaga o uiga, lea e aʻafia ai le saʻo o le faʻaalia faʻamatalaga.