insert element of 2 dimensional list to excel with openpyxlHow do I check if a list is empty?Finding the index of an item given a list containing it in PythonWhat is the difference between Python's list methods append and extend?How do I sort a dictionary by value?Getting the last element of a list in PythonHow to make a flat list out of list of listsHow do I get the number of elements in a list in Python?How do I list all files of a directory?Most elegant way to check if the string is empty in Python?How to iterate over rows in a DataFrame in Pandas?
Where was the County of Thurn und Taxis located?
Nails holding drywall
Find a stone which is not the lightest one
What *exactly* is electrical current, voltage, and resistance?
How do I deal with a coworker that keeps asking to make small superficial changes to a report, and it is seriously triggering my anxiety?
Negative Resistance
Does the damage from the Absorb Elements spell apply to your next attack, or to your first attack on your next turn?
Is there metaphorical meaning of "aus der Haft entlassen"?
What does "function" actually mean in music?
What is purpose of DB Browser(dbbrowser.aspx) under admin tool?
Is there really no use for MD5 anymore?
Mistake in years of experience in resume?
Combinatorics problem, right solution?
A Note on N!
Was Dennis Ritchie being too modest in this quote about C and Pascal?
What does a straight horizontal line above a few notes, after a changed tempo mean?
Do I need to watch Ant-Man and the Wasp and Captain Marvel before watching Avengers: Endgame?
Find the identical rows in a matrix
How bug prioritization works in agile projects vs non agile
What makes accurate emulation of old systems a difficult task?
Could moose/elk survive in the Amazon forest?
Is it acceptable to use working hours to read general interest books?
Why must Chinese maps be obfuscated?
Why do distances seem to matter in the Foundation world?
insert element of 2 dimensional list to excel with openpyxl
How do I check if a list is empty?Finding the index of an item given a list containing it in PythonWhat is the difference between Python's list methods append and extend?How do I sort a dictionary by value?Getting the last element of a list in PythonHow to make a flat list out of list of listsHow do I get the number of elements in a list in Python?How do I list all files of a directory?Most elegant way to check if the string is empty in Python?How to iterate over rows in a DataFrame in Pandas?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I Have A List Like This ::
My_list = [[1, 3, 5, 7, 9], [2, 4, 6, 8, 10], [4, 8, 12, 16, 20], [5, 10, 15, 20, 25], [3, 6, 9, 12, 15] ]
I want To Insert Every List OF List Element In My_list In To One Column of Excel Spreadsheet With Openpyxl In Python ::
My Code Is This ::
for i in range(len(My_list)):
for j in range(0, 5):
text = sheet.cell(row= j, column= i)
text.value = My_list[i]
But This Not Working. Anyone Can Help Me ???
python
asked Mar 9 at 7:39
hossein asgharihossein asghari
75
|
show 1 more comment
I Have A List Like This ::
My_list = [[1, 3, 5, 7, 9], [2, 4, 6, 8, 10], [4, 8, 12, 16, 20], [5, 10, 15, 20, 25], [3, 6, 9, 12, 15] ]
I want To Insert Every List OF List Element In My_list In To One Column of Excel Spreadsheet With Openpyxl In Python ::
My Code Is This ::
for i in range(len(My_list)):
for j in range(0, 5):
text = sheet.cell(row= j, column= i)
text.value = My_list[i]
But This Not Working. Anyone Can Help Me ???
python
asked Mar 9 at 7:39
hossein asgharihossein asghari
75
Hi please consider reading: How to ask
– FChm
Mar 9 at 7:43
@FChm what you mean????
– hossein asghari
Mar 9 at 8:06
Your question was originally poorly formatted, it helps if it is more readable (as it is now!)
– FChm
Mar 9 at 8:08
Why exactly does this not work? Do you have an error code?
– FChm
Mar 9 at 8:08
@FChm no i have not error i can write a list element to excel but because My_list is a 2 dimensional list i can not write this element to excel
– hossein asghari
Mar 9 at 8:12
|
show 1 more comment
I Have A List Like This ::
My_list = [[1, 3, 5, 7, 9], [2, 4, 6, 8, 10], [4, 8, 12, 16, 20], [5, 10, 15, 20, 25], [3, 6, 9, 12, 15] ]
I want To Insert Every List OF List Element In My_list In To One Column of Excel Spreadsheet With Openpyxl In Python ::
My Code Is This ::
for i in range(len(My_list)):
for j in range(0, 5):
text = sheet.cell(row= j, column= i)
text.value = My_list[i]
But This Not Working. Anyone Can Help Me ???
python
asked Mar 9 at 7:39
hossein asgharihossein asghari
75
I Have A List Like This ::
My_list = [[1, 3, 5, 7, 9], [2, 4, 6, 8, 10], [4, 8, 12, 16, 20], [5, 10, 15, 20, 25], [3, 6, 9, 12, 15] ]
I want To Insert Every List OF List Element In My_list In To One Column of Excel Spreadsheet With Openpyxl In Python ::
My Code Is This ::
for i in range(len(My_list)):
for j in range(0, 5):
text = sheet.cell(row= j, column= i)
text.value = My_list[i]
But This Not Working. Anyone Can Help Me ???
python
python
asked Mar 9 at 7:39
hossein asgharihossein asghari
75
asked Mar 9 at 7:39
hossein asgharihossein asghari
75
edited Mar 9 at 7:45
hossein asghari
asked Mar 9 at 7:39
hossein asgharihossein asghari
75
asked Mar 9 at 7:39
hossein asgharihossein asghari
75
asked Mar 9 at 7:39
hossein asgharihossein asghari
75
75
Hi please consider reading: How to ask
– FChm
Mar 9 at 7:43
@FChm what you mean????
– hossein asghari
Mar 9 at 8:06
Your question was originally poorly formatted, it helps if it is more readable (as it is now!)
– FChm
Mar 9 at 8:08
Why exactly does this not work? Do you have an error code?
– FChm
Mar 9 at 8:08
@FChm no i have not error i can write a list element to excel but because My_list is a 2 dimensional list i can not write this element to excel
– hossein asghari
Mar 9 at 8:12
|
show 1 more comment
Hi please consider reading: How to ask
– FChm
Mar 9 at 7:43
@FChm what you mean????
– hossein asghari
Mar 9 at 8:06
Your question was originally poorly formatted, it helps if it is more readable (as it is now!)
– FChm
Mar 9 at 8:08
Why exactly does this not work? Do you have an error code?
– FChm
Mar 9 at 8:08
@FChm no i have not error i can write a list element to excel but because My_list is a 2 dimensional list i can not write this element to excel
– hossein asghari
Mar 9 at 8:12
Hi please consider reading: How to ask
– FChm
Mar 9 at 7:43
Hi please consider reading: How to ask
– FChm
Mar 9 at 7:43
@FChm what you mean????
– hossein asghari
Mar 9 at 8:06
@FChm what you mean????
– hossein asghari
Mar 9 at 8:06
Your question was originally poorly formatted, it helps if it is more readable (as it is now!)
– FChm
Mar 9 at 8:08
Your question was originally poorly formatted, it helps if it is more readable (as it is now!)
– FChm
Mar 9 at 8:08
Why exactly does this not work? Do you have an error code?
– FChm
Mar 9 at 8:08
Why exactly does this not work? Do you have an error code?
– FChm
Mar 9 at 8:08
@FChm no i have not error i can write a list element to excel but because My_list is a 2 dimensional list i can not write this element to excel
– hossein asghari
Mar 9 at 8:12
@FChm no i have not error i can write a list element to excel but because My_list is a 2 dimensional list i can not write this element to excel
– hossein asghari
Mar 9 at 8:12
|
show 1 more comment
1 Answer
1
active
oldest
votes
It doesn't work because your are working with a 2D list...
When you reference the list:
print(My_list[0])
would return:
[1, 3, 5, 7, 9]
But you want your assignment to the text.value attribute to be :
text.value = My_list[i][j]
which would assign the jth element of the ith list of My_list to text.value.
I'm not sure about your problem as a whole (as you have provided no context). However, in my opinion there are better ways of storing and writing such data. For example, you could use a pandas DataFrame and use it's .to_csv method.
You could also look at taking advantage of the np.savetxt function. However, there is probably a valid reason for you using openpyxl which I understand!
answered Mar 9 at 8:12
FChmFChm
877519
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55075125%2finsert-element-of-2-dimensional-list-to-excel-with-openpyxl%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It doesn't work because your are working with a 2D list...
When you reference the list:
print(My_list[0])
would return:
[1, 3, 5, 7, 9]
But you want your assignment to the text.value attribute to be :
text.value = My_list[i][j]
which would assign the jth element of the ith list of My_list to text.value.
I'm not sure about your problem as a whole (as you have provided no context). However, in my opinion there are better ways of storing and writing such data. For example, you could use a pandas DataFrame and use it's .to_csv method.
You could also look at taking advantage of the np.savetxt function. However, there is probably a valid reason for you using openpyxl which I understand!
answered Mar 9 at 8:12
FChmFChm
877519
add a comment |
It doesn't work because your are working with a 2D list...
When you reference the list:
print(My_list[0])
would return:
[1, 3, 5, 7, 9]
But you want your assignment to the text.value attribute to be :
text.value = My_list[i][j]
which would assign the jth element of the ith list of My_list to text.value.
I'm not sure about your problem as a whole (as you have provided no context). However, in my opinion there are better ways of storing and writing such data. For example, you could use a pandas DataFrame and use it's .to_csv method.
You could also look at taking advantage of the np.savetxt function. However, there is probably a valid reason for you using openpyxl which I understand!
answered Mar 9 at 8:12
FChmFChm
877519
add a comment |
It doesn't work because your are working with a 2D list...
When you reference the list:
print(My_list[0])
would return:
[1, 3, 5, 7, 9]
But you want your assignment to the text.value attribute to be :
text.value = My_list[i][j]
which would assign the jth element of the ith list of My_list to text.value.
I'm not sure about your problem as a whole (as you have provided no context). However, in my opinion there are better ways of storing and writing such data. For example, you could use a pandas DataFrame and use it's .to_csv method.
You could also look at taking advantage of the np.savetxt function. However, there is probably a valid reason for you using openpyxl which I understand!
answered Mar 9 at 8:12
FChmFChm
877519
It doesn't work because your are working with a 2D list...
When you reference the list:
print(My_list[0])
would return:
[1, 3, 5, 7, 9]
But you want your assignment to the text.value attribute to be :
text.value = My_list[i][j]
which would assign the jth element of the ith list of My_list to text.value.
I'm not sure about your problem as a whole (as you have provided no context). However, in my opinion there are better ways of storing and writing such data. For example, you could use a pandas DataFrame and use it's .to_csv method.
You could also look at taking advantage of the np.savetxt function. However, there is probably a valid reason for you using openpyxl which I understand!
answered Mar 9 at 8:12
FChmFChm
877519
edited Mar 9 at 8:18
answered Mar 9 at 8:12
FChmFChm
877519
answered Mar 9 at 8:12
FChmFChm
877519
answered Mar 9 at 8:12
FChmFChm
877519
877519
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55075125%2finsert-element-of-2-dimensional-list-to-excel-with-openpyxl%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hi please consider reading: How to ask
– FChm
Mar 9 at 7:43
@FChm what you mean????
– hossein asghari
Mar 9 at 8:06
Your question was originally poorly formatted, it helps if it is more readable (as it is now!)
– FChm
Mar 9 at 8:08
Why exactly does this not work? Do you have an error code?
– FChm
Mar 9 at 8:08
@FChm no i have not error i can write a list element to excel but because My_list is a 2 dimensional list i can not write this element to excel
– hossein asghari
Mar 9 at 8:12