def create_sheet(sheet, df): # create rows generator, discarding index, header rows = dataframe_to_rows(df, index=False, header=False) # iterate throw row and col of df (specify starting coordinates of table to write) for r_idx, row in enumerate(rows, self.START_ROW): for c_idx, value in enumerate(row, self.START_COL): sheet.cell(row=r_idx, column=c_idx, value=value)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter