Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: excel - json
Post: RE: excel - json
Thank you Mr Buran.
I finished the program !!!
I know that it is not at all well structured, with linear variables and little connected with the tables. what I lacked was:
for value in sheet.iter_rows... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Mar-02-2021, 10:11 PM |
|
|
Thread: excel - json
Post: RE: excel - json
(Mar-01-2021, 08:21 PM)buran Wrote: Sorry, but I really don't understand what you are doing and not having your file or the code you actually run does not help. And frankly I am tired of guessing...... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Mar-01-2021, 09:39 PM |
|
|
Thread: excel - json
Post: RE: excel - json
I've already arranged .j just prints the lines where they exist. Iteration case |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Mar-01-2021, 08:23 PM |
|
|
Thread: excel - json
Post: RE: excel - json
when it was set to = 82, it printed a single line on the screen. Now that it comes from a random this number of lines appears:
saiu o número:82
82
Cell(row='7', column='J', value=82)
Cell(row='7', col... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Mar-01-2021, 08:04 PM |
|
|
Thread: excel - json
Post: RE: excel - json
(Feb-28-2021, 03:47 PM)buran Wrote: OMG, why do you dump to JSON, when you can just open the source workbook, iterate over cells and write respective values to target workbook?
i change wb for workb... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-28-2021, 11:12 PM |
|
|
Thread: excel - json
Post: RE: excel - json
import json
from collections import namedtuple
from openpyxl import load_workbook
from openpyxl import Workbook
from openpyxl.utils import column_index_from_string
#filename="aexa.xlsx"
workbook = loa... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-28-2021, 03:41 PM |
|
|
Thread: excel - json
Post: RE: excel - json
(Feb-28-2021, 03:29 PM)jmabrito Wrote: (Feb-28-2021, 10:54 AM)buran Wrote: line 13 of your code is
sheet["CE"] = "vl" import json
from collections import namedtuple
from openpyxl import Workb... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-28-2021, 03:30 PM |
|
|
Thread: excel - json
Post: RE: excel - json
(Feb-28-2021, 10:54 AM)buran Wrote: line 13 of your code is
sheet["CE"] = "vl" import json
from collections import namedtuple
from openpyxl import Workbook
from openpyxl.utils import column_ind... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-28-2021, 03:29 PM |
|
|
Thread: excel - json
Post: RE: excel - json
I finished the program. as I said, I wrote, if cl == "F"
cl = "K" and the result was perfect. I had already made these changes, but carelessly it never worked. OK thanks. |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-28-2021, 11:15 AM |
|
|
Thread: excel - json
Post: RE: excel - json
(Feb-28-2021, 10:47 AM)jmabrito Wrote: (Feb-28-2021, 06:05 AM)buran Wrote: I just fix your own code, line # 13 of your snippet.
A to F are 6 columns, G to K are 5 columns
I didn't see the entry o... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-28-2021, 11:07 AM |
|
|
Thread: excel - json
Post: RE: excel - json
(Feb-28-2021, 06:05 AM)buran Wrote: (Feb-27-2021, 10:51 PM)jmabrito Wrote: I think you are writing exactly the same thing that is in the excel source.
I just fix your own code, line # 13 of your s... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-28-2021, 10:47 AM |
|
|
Thread: excel - json
Post: RE: excel - json
Needing better, the values are in column A to F, when they are found, they are now entered in line G to K, respectively.
in first quote i said cl+5 it means that the columns jump 5 positions. Thank... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-27-2021, 11:02 PM |
|
|
Thread: excel - json
Post: RE: excel - json
I think you are writing exactly the same thing that is in the excel source.
What I want is: found the row, column and value, go write in the same line, but in column K with the same value.
in this cas... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-27-2021, 10:51 PM |
|
|
Thread: excel - json
Post: RE: excel - json
Quote:Matter completely resolved. However, in the line: for cell in search_for_value (date, 50): (was 29 in the previous example), I can't put a variable (num). Now the lines start at 2. I want to rec... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-27-2021, 06:31 PM |
|
|
Thread: excel - json
Post: excel - json
{"3025": {"pos1": null, "pos2": 11, "pos3": null, "pos4": 34, "pos5": 41},
"3026": {"pos1": 6, "pos2": null, "pos3": 27, "pos4": 36, "pos5": null},
"3027": {"pos1": 10, "pos2": null, "pos3": 29, "po... |
|
jmabrito |
General Coding Help |
23 |
6,568 |
Feb-26-2021, 06:32 PM |
|
|
Thread: goto
Post: RE: goto
Program termination does not invalidate the previously formulated request. Based on the program I exposed, how to overcome the problem of a "GOTO" not allowed, but desired, because I want to go to lin... |
|
jmabrito |
General Coding Help |
34 |
10,309 |
Feb-18-2021, 09:55 PM |
|
|
Thread: goto
Post: RE: goto
[quote="BashBedlam" pid='137630' dateline='1613610151']
Pleas try this code and let me know if it accomplishes what you want from it.
Os apelos experimentam este código e me avisem se ele conseguir o ... |
|
jmabrito |
General Coding Help |
34 |
10,309 |
Feb-18-2021, 09:43 PM |
|
|
Thread: goto
Post: RE: goto
Mr. Buran
Please complete and or modify the program to solve the problem. If necessary, it can be changed in its entirety. thanks |
|
jmabrito |
General Coding Help |
34 |
10,309 |
Feb-17-2021, 10:03 PM |
|
|
Thread: goto
Post: RE: goto
import random
import pyttsx3
import sys
for r in range(15):
print (r)
a = input("Digite o nr.:")
if a == '999':
sys.exit()
else:
print ('ok')
fname = "bjjj.txt"
... |
|
jmabrito |
General Coding Help |
34 |
10,309 |
Feb-15-2021, 10:14 PM |
|
|
Thread: goto
Post: RE: goto
import random
import pyttsx3
import sys
for r in range(15):
print (r)
a = input("Digite o nr.:")
if a == '999':
sys.exit()
else:
print ('ok')
fname = "bjjj.txt"
... |
|
jmabrito |
General Coding Help |
34 |
10,309 |
Feb-12-2021, 03:34 PM |