Excel extractor ( 1 Day Online Hackathon )

Problem Description:

Managing data from Excel files can be cumbersome and time-consuming, especially when it involves populating form fields with data from specific lines. To simplify this process and enhance data management efficiency, we need to develop a system that allows users to upload Excel files and automatically populate a form with the selected data. The system should also provide the capability to update and save the data, as well as download it in Excel format

Problem Statement:

Create a functional mobile application or web app that enables users to upload Excel files in a specific format. The system should display the details from the Excel file and allow users to click on a specific line to populate a form with the corresponding data. Users should be able to edit and save the populated data, with the provision to download the updated data in Excel format.

Examples and Demos

• Live demo
• video demo and test files

Installation and Setup

• Clone the repository: git clone git@github.com:alwinantony29/beyond-us-hackathon-ST06-.git

• Install dependencies: npm install

Project Structure

• src/: Contains the source code of the project.
• src/components/: Contains reusable React components.

Usage

To start the development server: npm run dev

Runs the app in the development mode. Open http://localhost:5173 to view it in your browser. The page will reload when you make changes. You may also see any lint errors in the console.

To build the project for production: npm run build

To run tests: npm run test

Dependencies

• "@fortawesome/fontawesome-free": "^6.4.0",
• "@fortawesome/fontawesome-svg-core": "^6.4.0",
• "@fortawesome/free-brands-svg-icons": "^6.4.0",
• "@fortawesome/react-fontawesome": "^0.2.0",
• "react": "^18.2.0",
• "react-dom": "^18.2.0",
• "react-router-dom": "^6.14.1",
• "xlsx": "^0.18.5"
• "tailwind"