This is a Library Management System built using Python, which helps to manage books in a library. It allows users to perform operations like adding, updating, viewing, deleting books, and saving/loading book data from Excel or SQLite database.

• Add a new book to the library
• View all books in the library

• Search for a book by ID or Title
• Update book information
• Delete a book from the library
• Save and load books to/from an Excel file (library.xlsx)

• Save and load books to/from an SQLite database (library.db)

This project uses the following Python libraries:

1. pandas:

   • Used for working with data structures and reading/writing data to Excel files. The pandas.DataFrame is used to handle and manipulate the book data before saving or loading it from Excel.
   • Installation: pip install pandas

2. tabulate:

   • Used to format the output of the list of books into a readable table format when viewing books in the console.
   • Installation: pip install tabulate

3. openpyxl:

   • Used to work with Excel files, allowing the system to save book data to an Excel file and read data from it.
   • Installation: pip install openpyxl

4. sqlite3:

   • A built-in Python library that provides an interface to SQLite databases, used to save and retrieve book data from the SQLite database (library.db).
   • Installation: Already included with Python (no need for extra installation).