Python Forum
How publish CSV to HTML
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How publish CSV to HTML
#1
Hi,
I use below code to come out a csv file with hyperlinks in each cell. I want to publish this as it is into HTML. Can someone please suggest if there is any fi=unction to do so.

import xlsxwriter

# %%
import pandas as pd
input=r'D:\PythonCodes\dashinput.csv'

df=pd.read_csv(input)
dt=df.iloc[0:0,2]

    
m, n = df.values.shape
for i in range(m):
    for j in range(n):
        dt=df.values[i,j]

        print(dt)
    


#%%
# Create a new workbook and add a worksheet
workbook = xlsxwriter.Workbook('hyperlink.xlsx')
worksheet = workbook.add_worksheet('Hyperlinks')

# Format the first column
worksheet.set_column('A:A', 30)

# Add a sample alternative link format.
red_format = workbook.add_format({
    'font_color': 'red',
    'bold':       1,
    'underline':  1,
    'font_size':  12,
})

# Write some hyperlinks
worksheet.write_url('A1', 'http://www.python.org/')  # Implicit format.
worksheet.write_url('A3', 'http://www.python.org/', string='Python Home')
worksheet.write_url('A5', 'http://www.python.org/', tip='Click here')
worksheet.write_url('A7', 'http://www.python.org/', red_format)
worksheet.write_url('A9', 'mailto:[email protected]', string='Mail me')

dsip_item='7/12'
# Write a URL that isn't a hyperlink
worksheet.write_string('A11', 'http://www.python.org/')
worksheet.write_url('A12', r'D:/DataCheck.xlsx',string=dt)

workbook.close()
Reply


Messages In This Thread
How publish CSV to HTML - by SriMekala - Aug-01-2019, 03:15 PM
RE: How publish CSV to HTML - by scidam - Aug-01-2019, 11:04 PM
RE: How publish CSV to HTML - by SriMekala - Aug-02-2019, 12:02 PM
RE: How publish CSV to HTML - by scidam - Aug-02-2019, 10:56 PM
RE: How publish CSV to HTML - by SriMekala - Aug-03-2019, 05:44 AM
RE: How publish CSV to HTML - by scidam - Aug-04-2019, 04:56 AM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020