You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
add some better api to specify number_format when dumping data to Excel #1162
withopen_excel(fpath) aswb:
sheet=wb[0]
sheet['A1'] =arr.dump()
# we must use Excel "custom format" syntaxsheet['B2'].xw_range.expand().number_format='0,00'# ORsheet.range('B2').expand().number_format='0,00'# ORsheet['B2:D3'].number_format='0,00'# for percents:sheet['B2:D3'].number_format='0,0%'
But it is annoying to have to specify the range of the data, or even the "starting point" of the data.
Activity