How to generate multiple file paths and save them into a excel with python

Question

I want to generate hundreds of file paths in python and save them into an excel file. Each path should save in a separate row and paths vary just by one value. I am not sure how to iterate it through a for loop.

Here is my try:

import xlsxwriter

workbook = xlsxwriter.Workbook('hello.xlsx')
worksheet = workbook.add_worksheet()

for i in range (4):
    worksheet.write('A%d', '/home/exx/Documents/Input/%d/2.mp4', %(i)))  
    workbook.close()

Output is excel file should be like below:

/home/exx/Documents/Input/0/2.mp4
/home/exx/Documents/Input/1/2.mp4
/home/exx/Documents/Input/2/2.mp4
/home/exx/Documents/Input/3/2.mp4

Not sure about the excel part, but try '/home/exx/Documents/Input/%d/2.mp4' % (i) or f'/home/exx/Documents/Input/{i}/2.mp4' for the path string part. EDIT: To make it more clear, remove the comma before % (i). — Koy
– Koy, Commented Oct 5, 2021 at 17:34

mgajewskik · Accepted Answer · 2021-10-05 17:42:34Z

4

There are a few mistakes here:

workbook should be closed outside of the for loop
if you want to start generation from 0 but write the first line in row number one in the excel file you should do i+1 in the row count
there shouldn't be a space after a range keyword

The fixed snipped should look like this:

import xlsxwriter

workbook = xlsxwriter.Workbook('hello.xlsx')
worksheet = workbook.add_worksheet()

for i in range(4):
    worksheet.write(f'A{i+1}', f'/home/exx/Documents/Input/{i}/2.mp4')

workbook.close()

answered Oct 5, 2021 at 17:42

mgajewskik

562 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Princewill Ezeidei · Accepted Answer · 2021-10-05 19:13:37Z

1

This also works.

import xlsxwriter

workbook = xlsxwriter.Workbook('filepaths.xlsx')
worksheet = workbook.add_worksheet()

#column parameter is set to zero (0), because you want all the entries to be on the first column
for i in range(4):
    worksheet.write(i, 0,  f'/home/exx/Documents/Input/{i}/2.mp4')

workbook.close()

answered Oct 5, 2021 at 19:13

Princewill Ezeidei

18710 bronze badges

Collectives™ on Stack Overflow

How to generate multiple file paths and save them into a excel with python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related