All Questions
171 questions
-1
votes
1
answer
40
views
How to get response.content "content" to write it as bytes stream into a file
I'm trying to download xlsx file, response.content looks like this:
response = requests.post('url', headers, json)
byte_stream = BytesIO(response.content)
with open('template.xlsx', 'wb') as f:
f....
0
votes
0
answers
72
views
Reading the merged excel data and convert into the json format using python
I am attempting to convert data from Excel to JSON using the Python Pandas library.
I have data in Excel that looks like the table below,
Test
...
0
votes
1
answer
82
views
Update data in json kept in excel sheet with python
I have an Excel sheet that has json stored in on of it's cells. Sheet has multiple rows, but every json is in one column.
I need a way to replace some of the elements of that json, and save it back as ...
0
votes
0
answers
66
views
Python in Excel: How to access the records of a JSON file imported using Excel Query
I have a deeply nested JSON file that I have imported using Power Query into Excel and Microsoft 365 using
Data>Get Data>From File>From JSON
It loads into a [Record].
I would like to access ...
- 656
1
vote
1
answer
69
views
How to map table references in a JSON file to corresponding values in an Excel file using Python?
I have an Excel file containing a list of requirements in 1 column and a JSON file that stores table values. The requirements in the Excel file include references to tables in the JSON file, formatted ...
- 13
-4
votes
1
answer
80
views
how can i write my json's data into an Excel file
I want to convert Json data to Excel, but I cannot transfer the internal data as I want.
Json like below
data = {"INVOICES":
[
{"CODE":"20240113_16EB01_286&...
- 1
0
votes
1
answer
158
views
Python script to convert JSON to XLSX in Azure Function
I tried parsing the JSON in query parameter (URL) in my Azure Function that converts JSON into XLSX and stores it in the storage container, but there is an error with the code which I am not able to ...
0
votes
1
answer
83
views
Match excel attributes to specific json items in python
Here is a simplified version of the current json file i have:
[
{
"Name": "bob",
"Age": "10"
},
{
"Name": "joe",
&...
- 1
-1
votes
1
answer
80
views
Converting an excel file to a specific Json in python using openpyxl library with datetime
I have the Excel data with the format shown in the image preview. How can I convert it into a JSON using Python?
Expected Output:
file_name = [
{
A: Measurement(
calculated_date=datetime(2022, 10, 1, ...
0
votes
1
answer
66
views
error message json conversion to excel in python
I am trying to convert a json file into an excel file in Python.
With this code i try to convert a json file to an Excel file:
json_file: data = json.load(json_file) ```
I get an error message ...
0
votes
3
answers
161
views
How do you convert this Excel table/sheet into an array of JSON objects using Python3?
So I have a situation where I need to convert an Excel sheet into an array of Json objects using Python3.
The Excel sheet looks like the following:
CARTS
ITEMS
Cart A
Lemons
Apples
Strawberries
Cart B
...
- 17
-1
votes
1
answer
1k
views
Pull data from a json and create an excel file with the data
I'm trying to write a python script to:
Grab a JSON file.
Pull specific header from the json file. (couldn't figure this out)
Create the headers in the excel file as columns.
Parse through the json ...
0
votes
2
answers
2k
views
convert excel to json file in python
I am new here , need some help with writing to json file:
I have a dataframe with below values, which is created by reading a excel file
need to write this to json file with object as column dtls
...
- 19
0
votes
1
answer
117
views
Transform data into excel from deeply nested json
i am new to python, fetching data from web url into json format and trying to convert nested json into data frame ,after that dump into excel. But i am not getting the expected output.
JSON:
"...
- 33
1
vote
1
answer
206
views
How do I convert this xlsx to JSON in Python
I have a following excel file with two sheets:
and
I want to convert this excel into a json format using python that looks like this:
{
"app_id_c":"string",
"...
