Giter VIP home page Giter VIP logo

latihan-form-excel's Introduction

Latihan Form Excel

Note

Format file excel yang digunakan bisa diunduh di /public/static/example.xlsx. Jika format table yang diupload berbeda, maka akan error.

Library untuk membaca file excel menggunakan read-excel-file.

import readXlsxFile from "read-excel-file";

Secara default, file excel akan dibaca sebagai array of array. Agar formatnya menjadi JSON, maka perlu mendefinisikan schema table yang digunakan (baca).

/modules/Form/schema.tsx

export const schema = {
  Nama: {
    prop: "name",
    type: String,
    required: true,
  },
  "Tanggal Lahir": {
    prop: "birthDate",
    type: String,
    required: true,
  },
  "Tahun Lahir": {
    prop: "birthYear",
    type: Number,
    required: true,
  },
  Hobi: {
    prop: "hobby",
    type: String,
    required: true,
  },
  Alamat: {
    prop: "address",
    type: String,
    required: true,
  },
  Kelas: {
    prop: "class",
    type: String,
    required: true,
  },
  Sekolah: {
    prop: "school",
    type: String,
    required: true,
  },
};

Kemudian masukkan schema digunakan.

readXlsxFile(event.target.files[0], { schema }).then(({ rows, errors }) => {
  if (errors.length !== 0) {
    console.log(errors);
    return;
  }

  console.log(rows);
});

latihan-form-excel's People

Contributors

zakiego avatar dependabot[bot] avatar github-actions[bot] avatar

Watchers

 avatar  avatar

latihan-form-excel's Issues

To-Do

  • Check schema
  • Console json
  • Prevent user close window before saved

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.