Giter Club home page Giter Club logo

spreadsheetapp's Introduction

Spreadsheet Application using Javascript and CSS

Problem Statement

Create a Spreadsheet application in Javascript.

Requirements

  • User should be able to ADD row/column(s) using + button.
  • User should be able to DELETE row/column(s) using - button.
  • User should be able to perform basic algebraic operations (+,-,*,/) with cell references.
  • User should be able to select multiple rows or columns and display their sum in a row. Any changes to the cell content should update the sum.
  • User should be able to able to export the spreadsheet in CSV format.
  • Should use ES6 syntax for the project including exports and imports.
  • Should use webpackjs for building the project.

Implementation

  • The project uses ES6 syntax for implementing the Spreadsheet Application.
  • Features such as Class, variable declartions using let/const, import/export of constants, functions and .js or .css files are used.
  • WebpackJS is used building the project and running the application.
  • Basic table with predefined rows/columns are displayed on the browser with the flexibitity to add/delete rows/columns on the table.
  • Each table cell is dynamically assigned a unique ID to be able to identify the cell contents while performing arithmetic operations.
  • The expression is evaluated using REGEX Pattern Matching and obtaining the last updated celll values to display the latest results in the cell.
  • Algebraic operations are performed by first converting the infix expression to postfix expression and then evaluating the postfix expression.
  • The contents of the spreadsheet can be downloaded or exported in a CSV format.

Instructions to run the project:

  • Download the project zip from the github and Run 'npm init' to initalize npm project.
  • Once the initialization is complete, run the 'npm run start' command on the console.
  • The WebpackJS will build the project and create /dist folder in the project structure which consists the bundled script of all the JS files.
  • Open the index.html page on the browser to view the Spreadsheet Application and perform the necessary operations.

spreadsheetapp's People

Contributors

karunameena avatar

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.