I was able to insert charts into multiple sheets. However, the chart was first saved on the local drive and then inserted in spreadsheet.
for ticker in ticker: workbook.add_worksheet(ticker) activeSheet = workbook.get_worksheet_by_name(ticker) filt2 = (dfInit["Ticker"] == ticker) mpf.plot(dfInit[filt2], title = ticker, type = "candle", style = "classic", savefig = ticker + ".png") activeSheet.insert_image(1, 1, ticker + ".png")Can we do the same without saving the png to the local drive?