In normal work, I usually use Pandas as my excel read/write utility.

Here is an example for how to write multiple dataframes to worksheets. We need to use pd.ExcelWriter method.