Copyright (c) 2023-Present EncoreSky Technologies Pvt. Ltd. All rights reserved.

Excel Writer

excel_writer is a package containing the methods for creating excel file from python dictionary or pandas dataframe.

Prerequisites

You'll also need the following:

• Python, excel_writer is compatible with version >=3.8.11.

Installation

To install the package (in either a system-wide or a virtual environment), navigate to the excel_writer root folder in a Terminal, and type:

pip install excel-writer

excel_writer will be installed as a package in your Python distribution, along with it's dependencies if necessary.

N.B. - installing in a virtual environment is recommended.

Usage

Input Format

Supported input format for dictionary is as follows:

{
    <column_name>: [<row_value>, <row_value>, . . . .],
    <column_name>: [<row_value>, <row_value>, . . . .],
    .
    .
    .
    .
}

Write a file using dictionary

from excel_writer import ExcelWriter

input_data = {
    "Name": ["Aarav", "Jayesh", "Vineet", "Rahul", "Mayank", "Deepak"],
    "Age": [24, 28, 27, 25, 28, 35],
    "Emp Id": ["A-001", "A-002", "A-003", "A-004", "A-005", "A-006"],
    "City": ["Indore", "Bhopal", "Gwalior", "Pune", "Kolkata", "Udaipur"],
    "Has Bike": ["Y", "Y", "Y", "Y", "Y", "Y"]
}

excel_writer = ExcelWriter(file_name="test.xlsx", 
                            sheet_name="sheet_1")

excel_writer.write_data(data_dict = input_data)

Write a file using pandas dataframe

import pandas as pd
from excel_writer import ExcelWriter

input_data = {
    "Name": ["Aarav", "Jayesh", "Vineet", "Rahul", "Mayank", "Deepak"],
    "Age": [24, 28, 27, 25, 28, 35],
    "Emp Id": ["A-001", "A-002", "A-003", "A-004", "A-005", "A-006"],
    "City": ["Indore", "Bhopal", "Gwalior", "Pune", "Kolkata", "Udaipur"],
    "Has Bike": ["Y", "Y", "Y", "Y", "Y", "Y"]
}

data_df = pd.DataFrame(input_data)
excel_writer = ExcelWriter(file_name="test.xlsx", 
                            sheet_name="sheet_1")

excel_writer.write_data(data_df = data_df)