在 Pandas 中使用 XlsxWriter
https://xlsxwriter.readthedocs.io/working_with_pandas.html
#df
https://www.geeksforgeeks.org/loop-or-iterate-over-all-or-certain-columns-of-a-dataframe-in-python-pandas/
# Exporting a Data Frame to custom formatted Excel
https://medium.com/analytics-vidhya/exporting-a-data-frame-to-custom-formatted-excel-a82a35116e92
# pd format
https://stackoverflow.com/questions/55229090/why-pandas-dataframe-style-lost-when-saved-with-to-excel
#Using XlsxWriter with Pandas
https://xlsxwriter.readthedocs.io/working_with_pandas.html
#pd
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.ExcelWriter.html
#append
https://stackoverflow.com/questions/20219254/how-to-write-to-an-existing-excel-file-without-overwriting-data-using-pandas
#loadwb
https://blog.csdn.net/gaifuxi9518/article/details/80570746
#xlxs ex
https://www.programcreek.com/python/example/103823/xlsxwriter.Workbook
#exists
https://www.guru99.com/python-check-if-file-exists.html
#ex table
https://xlsxwriter.readthedocs.io/example_tables.html
https://xlsxwriter.readthedocs.io/working_with_tables.html#tables
# modu ex
https://www.geeksforgeeks.org/working-with-xlsxwriter-module-python/
# start jq
https://zhuanlan.zhihu.com/p/33105153
# jq
https://blog.csdn.net/weixin_38168620/article/details/79576970
# ad format
https://xlsxwriter.readthedocs.io/tutorial02.html
#wrap
https://xlsxwriter.readthedocs.io/format.html?highlight=text_wrap#set_text_wrap
# num format
# format p
https://xlsxwriter.readthedocs.io/format.html?highlight=text_wrap#format-methods-and-format-properties
# for loop
https://xlsxwriter.readthedocs.io/tutorial02.html
#format
https://pbpython.com/improve-pandas-excel-output.html
# col des
https://xlsxwriter.readthedocs.io/example_pandas_column_formats.html
# cell format override
https://stackoverflow.com/questions/22352907/apply-format-to-a-cell-after-being-written-in-xlsxwriter
# tu cell
https://xlsxwriter.readthedocs.io/working_with_conditional_formats.html
# samp
https://xlsxwriter.readthedocs.io/example_pandas_simple.html
# append
https://www.programcreek.com/python/example/101337/pandas.ExcelWriter
# for
https://stackoverflow.com/questions/44593705/how-to-copy-over-an-excel-sheet-to-another-workbook-in-python/44596301
# more ex
https://www.geeksforgeeks.org/python-create-and-write-on-excel-file-using-xlsxwriter-module/?ref=rp
#ex
https://medium.com/swlh/how-to-move-data-from-one-excel-file-to-another-using-python-a513491234f4
# sty clean
https://www.gairuo.com/p/pandas-style-function
# style polts
https://towardsdatascience.com/styling-pandas-plots-and-charts-9b4721e9e597
# df sty
https://mode.com/example-gallery/python_dataframe_styling/
# pandas.ExcelWriter
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.ExcelWriter.html
#zh
https://zhuanlan.zhihu.com/p/142972462
# pandas.read_excel
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html
# mu data
https://pandas.pydata.org/pandas-docs/stable/getting_started/intro_tutorials/10_text_data.html
https://wavedatalab.github.io/datawithpython/munge.html
# pd st
https://pandas.pydata.org/pandas-docs/stable/getting_started/intro_tutorials/04_plotting.html#min-tut-04-plotting
# add for
https://medium.com/codeptivesolutions/https-medium-com-nensi26-formatting-in-excel-sheet-using-xlsxwriter-part-1-2c2c547b2bea
# pd for mat
https://pandas.pydata.org/pandas-docs/version/1.0.0/reference/api/pandas.io.formats.style.Styler.to_excel.html
# xlxs pro cell format
https://xlsxwriter.readthedocs.io/format.html
# del titla
https://stackoverflow.com/questions/55246202/remove-default-formatting-in-header-when-converting-pandas-dataframe-to-excel-sh
# center wrap
https://stackoverflow.com/questions/59208392/why-does-vertical-align-middle-work-for-openpyxl-but-not-for-xlsxwriter-engi
# hear format
https://stackoverflow.com/questions/42562977/xlsxwriter-text-wrap-not-working
#ws format
https://xlsxwriter.readthedocs.io/worksheet.html
# append fun
https://stackoverflow.com/questions/38074678/append-existing-excel-sheet-with-new-dataframe-using-python-pandas
https://stackoverflow.com/questions/20219254/how-to-write-to-an-existing-excel-file-without-overwriting-data-using-pandas/47740262#47740262
#under line
https://xlsxwriter.readthedocs.io/format.html
# plot st
https://codingshiksha.com/python/python-3-script-to-copy-data-from-one-excel-sheet-file-to-another-excel-sheet-file-full-project-for-beginners/
# cop oveer
https://stackoverflow.com/questions/44593705/how-to-copy-over-an-excel-sheet-to-another-workbook-in-python/44596301
# fun
https://yagisanatode.com/2017/11/18/copy-and-paste-ranges-in-excel-with-openpyxl-and-python-3/
# dif
https://www.programmersought.com/article/9677842921/
# main
https://www.programmersought.com/article/10364486408/
# cell sty
https://www.programmersought.com/article/9481166059/
# mar
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Document-Operation/How-to-set-Excel-page-margins-before-printing-a-worksheet-in-C.html
#pg setup
https://rdrr.io/cran/openxlsx/man/pageSetup.html
#hearder
https://xlsxwriter.readthedocs.io/page_setup.html#
# best
# https://medium.com/analytics-vidhya/exporting-a-data-frame-to-custom-formatted-excel-a82a35116e92
#sky
https://vimsky.com/zh-tw/examples/detail/python-method-pandas.ExcelWriter.html
如你所见
