Worksheet.write_url doesn't work?

Problems and bugs
1

Hey everyone,

I need your help for my code, I wan’t to make a summary in a sheet in Excel with xlswriter to link my differents sheets. To do this I need the fonction worksheet.write_url but I’ve an error when I execute it.

Thanks

2

Hello @Antoine ,

I was able to write a link to the file with no issues using the following code:

#%%
import xlsxwriter
#%%
workbook   = xlsxwriter.Workbook('filename.xlsx')

worksheet1 = workbook.add_worksheet()

worksheet1.write('A1', 123)
worksheet1.write_url('A2', 'https://www.python.org/')

workbook.close()

What error do you have?

3

image
I’ve this error I don’t no why. Maybe because I use xlsxwriter and openpyxl?

4

Could you provide your code to reproduce the issue?

5

I find the problem, I use openpyxl to open an Excel but worksheet.write_url doesn’t exist. I have to use worksheet.cell tu do what I want with openpyxl

1 Like