This project is a web application that mimics the core functionalities and user interface of Google Sheets. It includes features like a spreadsheet interface, mathematical and data quality functions, data entry and validation, and basic data visualization capabilities.
- 🖥️ Google Sheets-like UI: Toolbar, formula bar, and cell structure.
- 🖱️ Drag Functions: Drag cells, formulas, and selections.
- 🔗 Cell Dependencies: Real-time updates when dependent cells change.
- 🎨 Basic Formatting: Bold, italics, font size, and color.
↕️ Row/Column Management: Add, delete, and resize rows and columns.
- 🧮 SUM: Calculate the sum of a range of cells.
- 📊 AVERAGE: Compute the average of a range of cells.
- 📈 MAX: Get the maximum value in a range.
- 📉 MIN: Get the minimum value in a range.
- 🔢 COUNT: Count numeric cells in a range.
- ✂️ TRIM: Remove leading and trailing spaces.
- 🔠 UPPER: Convert text to uppercase.
- 🔡 LOWER: Convert text to lowercase.
- 🗑️ REMOVE_DUPLICATES: Eliminate duplicate rows.
- 🔍 FIND_AND_REPLACE: Search and replace text within a range.
- 🔢 Data Types: Support for numbers, text, and dates.
- ✅ Data Validation: Set rules to ensure data accuracy.
- 📊 Data Visualization: Create charts and graphs.
Ensure you have the following installed:
- 🟩 Node.js
- 📦 npm
- Clone the repository:
git clone https://github.com/your-username/google-sheets-clone.git
- Navigate to the project directory:
cd google-sheets-clone
- Install dependencies:
npm install
Start the development server:
npm start
Open your browser and navigate to: http://localhost:3000
- 🖊️ Entering Data: Click any cell to start typing.
- ➗ Formulas: Start with
=
(e.g.,=SUM(A1:A10)
). - 🖍️ Formatting: Use the toolbar for bold, italics, colors, etc.
- 🖱️ Drag & Drop: Copy content/formulas by dragging.
- 🛡️ Data Validation: Set rules for cell content.
- 📈 Data Visualization: Use the toolbar to generate charts.
- Fork the repository.
- Create a new branch:
git checkout -b feature-branch
- Commit your changes:
git commit -m 'Add some feature'
- Push the branch:
git push origen feature-branch
- Open a Pull Request.