All Questions
268 questions
-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
1
answer
685
views
<stdin>:1: FutureWarning in Python (convert JSON to EXCEL)
I am convert json to excel with python, but had error like this. How i fix it??
Error :
:1: FutureWarning: As the xlwt package is no longer maintained, the xlwt engine will be removed in a future ...
0
votes
1
answer
54
views
Simple Word Search in Excel rows with Python
My code doesn't seem to work properly. I'm trying to look for word_for_find and word_for_find2 in excel rows from B and add to a list corresponding value of the cells from A which contain ...
- 13
1
vote
0
answers
61
views
How do I store multiple XLWT worksheets in a single excel file as separate sheets/tabs and preserve the formatting?
def _getOutCell(outSheet, colIndex, rowIndex):
row = outSheet._Worksheet__rows.get(rowIndex)
if not row: return None
cell = row._Row__cells.get(colIndex)
return cell
def setOutCell(...
- 11
1
vote
0
answers
140
views
openpyxl not updating in the loop
In my loop I am trying to get a different value for the ws.cell(2,5) on each iteration, but the value that I get is always the same. Normally I should get 1188 different values through the iterations.
...
- 13
0
votes
0
answers
271
views
.xls file exceed max number of rows
I need to create a file that has to be in .xls format, to accomplish that I am using xlwt and xlrd python modules. As the program generate really large files, the following exception is raised.
...
- 336
0
votes
1
answer
1k
views
Python: Read Cell from Excel with Coordinates
What I try to do here is to read some values out of an excel sheet. I would like to do it with coordinates (X,Y) and not the classical "A1","A2" etc approach.
In the same code I am ...
- 337
0
votes
1
answer
1k
views
Django Excel Export (using xlwt)
I'm trying to export data tied to an id from a view, to an excel file, this is the code:
from django.shortcuts import render
from clientesapp.models import Cliente, Orden
from django.http import ...
1
vote
3
answers
9k
views
Printing Python Output to Excel Sheet(s)
For my master thesis I've created a script.
Now I want that output to be printed to an excel sheet - I read that xlwt can do that, but examples I've found only give instructions to manually print one ...
user16312756
0
votes
1
answer
2k
views
How to generate an excel file and save it directly to a path in Django
I am new to Django and I was wondering if the following is possible:
Now, in my django app(not admin page) I create xls files using the xlwt library.
Pushing a button the user choose where he wants to ...
- 13
0
votes
1
answer
244
views
how to get sum row into xls by xlwt
I have a tuple like
t = ((a,b,1,2),(a,b,3,4),(a,c,1,3),(c,d,3,6))
I used xlwt's wb to write a .xls file. But now I neeed add a sum row below like:
C1 | C2 | C3 | C4
a | b | 1 | 2
a | b | 3 | 4
a |...
- 29
0
votes
1
answer
84
views
using height, left, top, width to format a excel table in python
I met a weird JSON response and need to save it to a excel, I tried pandas but it doesn't work in the expected way(or maybe I'm using it incorrectly, I am new to python), now I'm trying to use xlwt to ...
- 247
0
votes
1
answer
206
views
Writing from python to an Excel spreadsheet
I am new to Python and I am trying to write my data from python to an excel spreadsheet. This is my python output. https://i.sstatic.net/pi9ic.jpg I want the timestamp data from the python output to ...
0
votes
0
answers
608
views
How do I create new excel sheets within a for loop? [duplicate]
so I have a code which calculates some values from a data frame and writes it into an excel sheet.
Now, I am looking for a way to run a for loop and for each iteration create a new
excel sheet and ...
-1
votes
1
answer
17
views
i've gone throug various questions but my case is different in excel sheet auomation
I need a program to take input from an xlsv file and modify them according to the requirements and them that modified output should be printed in another excel sheet
Up to now, I've done by giving ...
- 1