4

Excel Auto Filler - Web-based Excel Editing Tool

A web application for uploading, editing, and saving Excel files with a user-friendly interface, built using Next.js, Material-UI, and xlsx library.

GitHub Website

Excel Auto Filler - Web-based Excel Editing Tool

Overview

Excel Auto Filler is a web-based application that allows users to upload Excel files, view and edit data directly, and save changes back to the original file. Built using Next.js and Material-UI, the app leverages the xlsx library for reading and writing Excel files, providing a straightforward interface for users to manage Excel data effortlessly.

Key Features

  • Excel File Upload:

    • Supports uploading of Excel files in .xls and .xlsx formats for editing.

  • Data Display & Editing:

    • Displays data from the first sheet of the uploaded Excel file in a user-friendly table format.
    • Allows users to edit the data directly within the table.

  • Save & Reload Functionality:

    • Users can save changes back to the original file or discard changes to reload the original data at any time.

Usage

  1. Click the "Upload" button and select an Excel file from your device.
  2. The data from the first sheet will display in an editable table format.
  3. Edit data directly in the table as needed.
  4. Click the "Save" button to save changes to the file or "Reload" to discard changes and reload the original data.

Installation

To set up the project locally, follow these steps:

# Clone the repository
git clone https://github.com/anudeep-17/excelfiller.git

# Navigate to the project directory
cd excelfiller

# Install dependencies
npm install

# Start the development server
npm run dev

Future of the Project

This project will soon be converted into an npm package to simplify integration into other projects. Stay tuned for updates!

Tech Stack

  • Frontend: Next.js, Material-UI
  • Library: xlsx for reading and writing Excel files
  • Version Control: Git/GitHub
  • Project Management: MIT License

Contributing

Contributions are welcome! Report issues, submit pull requests, or suggest new features.

License

This project is licensed under the MIT License.

Access & Documentation

This project demonstrates proficiency in web application development, data handling with Excel files, and integrating user-friendly UI components for seamless data management.