Excel-Engine-in-C

Table of Contents

• Project
  • Table of Contents
  • About The Project
  • Results
  • File Structure
  • Project Workflow
  • Getting started
  • Features
  • Contributors
  • Acknowledgements and Resources
  • License

About

Naive implementation of an excel engine in C.

Results

Input

A                | B      | C   | D 
9                | 2      | =C3 | 6
11               | 3      | 13  | =D1/B1
=((A1/B2)*A2)+B3 | =C1*D2 | 15  | 7

Output

For more results, refer examples.

File Structure

👨‍💻Excel-Engine-in-C
 ┣ 📂assets                            // Contains all the reference gifs, images
 ┣ 📄main.c                            // Driver Code
 ┣ 📂examples                          // Contains all examples
   ┣ 📂test1                            
   ┃ ┣ 📄input.csv                     // Input CSV file  
   ┃ ┣ 📄README.md                     // Results and Conclusions
   ┣ 📂test2 
   ┣ 📂test3 
   ┣ 📂test4 
 ┣ 📄README.md                          

Project Workflow

Getting Started

Prerequisites

To download and use this code, the minimum requirements are:

• Ubuntu 20.04 or later
• gcc or any other compiler

Installation

Clone the project by typing the following command in your Terminal/CommandPrompt

git clone https://github.com/PritK99/Excel-Engine-in-C.git

Navigate to the Excel-Engine-in-C folder

cd Excel-Engine-in-C

Usage

Once the requirements are satisfied, you can easily use the project on yout machine After following the above steps , use the following commands to:

To build the code

gcc main.c

To run the code Usage: ./a.out <path to input csv file

./a.out examples/test1/input.csv

Features

• Works with Addition, Subtraction, Multiplication and Division Operators (refer examples/test2)
• To evaluate complex expressions consisting of several operands and operators (refer examples/test4)
• Able to solve nested expressions and dependencies (refer examples/test2)
• Able to detect and report circular dependencies in expressions (refer examples/test3)

Contributors

• Prit Kanadiya

Acknowledgements and References

• Click here for documentation of various string related functions in C.
• https://github.com/tsoding/minicel

License

MIT License