-1

I have a list of data which I want to write into a specific column (B2 column) in Excel

Input example:

mydata =[12,13,14,15]

Desired Output in Excel:

A2| B2| 
  | 12|    
  | 13|
  | 14|
  | 15|

I have tried using openpyxl to access the specific sheet (which works fine) and specific cell(B2) but it throws an error to write to the excel file as it is a list. It works fine if I assign a single value as shown in the code extract below:

mydata= my_wb['sheet2']['B2'] = 4

Can anyone point me in the right direction?

Improve this question
2
  • 2
    should every number go into b2? Or b2, b3, b4 and so on? Commented Oct 28, 2021 at 15:55
  • yes that's correct b2,b3 etc @ph140 Commented Oct 28, 2021 at 15:57

1 Answer 1

Reset to default
1

Iterate over the list and paste each value into the desired row in column B:

for i, n in enumerate(mydata):
    my_wb["sheet2"].cell(i+2, 2).value = n
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments