Ngenisa uye kutumira mameseji mafaera kuExcel

Ichi chinyorwa chinotsanangura nzira yekuunza kana kutumira mameseji mafaira. Mafaira emavara anogona kupatsanurwa nemakoma (.csv) kana ma tab (.txt).

Tumira

Kuti utore mameseji mafaira, tevera mirairo yedu:

  1. Pa Advanced tabo Fillet (Faira) tinya Open (Vhura).
  2. Kubva pakudonhedza pasi list sarudza Rugwaro Mafaira (Mafaira ezvinyorwa).
  3. Kuunza faira kunze...
    • CSV, sarudza gwaro rine kuwedzera . Csv Uye chengetedza Open (Vhura). Ndizvo zvose.
    • TXT, sarudza gwaro rine kuwedzera .txt uye tinya Open (Vhura). Excel ichatanga Text Import Wizard (Wizard yezvinyorwa (import)).
  4. sarudza Delimited (nezviparadzanisa) uye tinya Next (Kuwedzera).Ngenisa uye kutumira mameseji mafaera kuExcel
  5. Bvisa mabhokisi ekutarisa kunze kweakatarisana Tab (Tab) uye tinya Next (Kuwedzera).Ngenisa uye kutumira mameseji mafaera kuExcel
  6. dzvanya pedza (Tagadzirira).Ngenisa uye kutumira mameseji mafaera kuExcel

Mhinduro:

Ngenisa uye kutumira mameseji mafaera kuExcel

ekisipoti

Kuti utumire kunze kweExcel workbook kune chinyorwa faira, ita zvinotevera:

  1. Vhura gwaro reExcel.
  2. Pa Advanced tabo Fillet (Faira) tinya Save As (Sevha se).
  3. Kubva pakudonhedza pasi list sarudza Mavara (Tab yakaganhurwa) (Mafaira ezvinyorwa (tab delimited)) kana CSV (Comma delimited) (CSV (yakaparadzaniswa nemakoma)).Ngenisa uye kutumira mameseji mafaera kuExcel
  4. dzvanya Save (Chengeta).

Mhedzisiro: CSV faira (comma delimited) uye TXT faira (tab delimited).

Ngenisa uye kutumira mameseji mafaera kuExcel Ngenisa uye kutumira mameseji mafaera kuExcel

Leave a Reply