Skip to main content

How to create a dynamic JSON file from reading data through an excel in python

 Below is the program on how to create a dynamic JSON file from reading data through an excel file as input for json in python. 

First, install openpyxl from the following command to read the data from an excel file in python

pip install openpyxl


import os

import openpyxl

import json

# create a JSON file to write dynamic JSON data.

f = open("C:\\Users\\My_Dyanamic_JSON_Test".json", "a")


# Open excel file for input

path = "C:\\Users\\Excel_input_File.xlsx"


# create workbook object for excel file

wb_obj = openpyxl.load_workbook(path)


# create a workbook sheet object for the excel file

sheet_obj = wb_obj["Sheet1"]


# get the data from the workbook sheet object from an excel file

Row1_cell1 = sheet_obj["A" + str(1)]

Row1_cell2 = sheet_obj["B" + str(1)]

Row1_cell3 = sheet_obj["C" + str(1)]

Row1_cell4 = sheet_obj["D" + str(1)]

Row1_cell5 = sheet_obj["E" + str(1)]

Row1_cell6 = sheet_obj["F" + str(1)]


# define a payload

payload = {

  'Key1': Row1_cell1.value,

                    'Key1': Row1_cell2.value,

                    'Key1': Row1_cell3.value,

                    'Key1': Row1_cell4.value,

                    'Key1': Row1_cell5.value,

                    'Key1': Row1_cell6.value,

                    'Key1': 10,

                    'Key1': 20

                }


# dump the payload

json_object = json.dumps(payload, indent=4)


# write the payload to JSON file

f.write(json_object)

Labels:
Location: Pune, Maharashtra, India

Comments

Post a Comment

Popular posts from this blog

Add, remove, search an item in listview in C#

Below is the C# code which will help you to add, remove and search operations on listview control in C#. Below is the design view of the project: Below is the source code of the project: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace Treeview_control_demo {     public partial class Form2 : Form     {         public Form2()         {             InitializeComponent();             listView1.View = View.Details;                   }         private void button1_Click(object sender, EventArgs e)         {             if (textBox1.Text.Trim().Length == 0)...
Post a Comment
Read more

Add worklog in Jira using Python

 Below is the Python code to add the worklog in Jira. You need to install a request library for this. Here is the code: import requests from requests.auth import HTTPBasicAuth import json url = "https://your jira address here/rest/api/2/issue/ticket_number/worklog" auth = HTTPBasicAuth("username", "jira access token") headers = {     "Accept": "application/json",     "Content-Type": "application/json" } payload = json.dumps({     "comment": {         "content": [             {                 "content": [                     {                         "text": "This is for QA Testing",                         "type": "text"                     } ...
Post a Comment
Read more

Some GUI examples in Python using customtkinter

 Some GUI examples in Python using customtkinter import customtkinter import os from PIL import Image class ScrollableCheckBoxFrame(customtkinter.CTkScrollableFrame):     def __init__(self, master, item_list, command=None, **kwargs):         super().__init__(master, **kwargs)         self.command = command         self.checkbox_list = []         for i, item in enumerate(item_list):             self.add_item(item)     def add_item(self, item):         checkbox = customtkinter.CTkCheckBox(self, text=item)         if self.command is not None:             checkbox.configure(command=self.command)         checkbox.grid(row=len(self.checkbox_list), column=0, pady=(0, 10))         self.checkbox_list.append(checkbox)     def remove_item(self, it...
Post a Comment
Read more