xlsxwriter + mplfinance: Plot Stock Chart in Excel Worksheet

[KMV]

Hello,

I would like to loop into various of instrument tickers in a dataframe and plot each instrument chart into an Excel worksheet.

Is there a possibility to do that on-the-fly using xlsxwriter's "insert_image" and mplfinance's "plot" functions?

The loop looks as follows:

for ticker in ticker:
	workbook.add_worksheet(ticker) # Add multiple sheets for each instrument
	filt2 = (dfInit["Ticker"] == ticker)
	mpf.plot(dfInit[filt2], title = ticker, type = "candle", style = "classic")  # This line have to be modified in order to insert charts into excel worksheet

Thank you in advance!