Creation of excel sheet(.xlsx) with multiple tabs

Venkatesh V

Hi all,

I want to create a excel sheet(.xlsx) with multiple tabs at application run time, can anybody help me with this.

Thanks in advance.

JonB

@Venkatesh-V
Since this seems to have nothing to do with Qt, if you do not get an answer here you should rather address your question to somewhere about Excel, e.g. stackoverflow.com.

Venkatesh V

@JonB

Thanks for your response.
Actually i want to develop this with Qt only. Is there any specific Qt template to achieve this?

VRonin

If you don't want to depend on MS Excel then the best option is: https://github.com/VSRonin/QtXlsxWriter it is unmaintained but works if your requirements are not too complex.

If you can use MS Excel you can use QAxObject to interact with it, see https://forum.qt.io/topic/89536/qaxobject-and-excel @hskoglund is the expert in this field

If you can use .Net (i.e. you are on windows). You can use C++/CLI and access the same functionalities C# has to interact with MS Office documents: https://www.codebyamir.com/blog/create-excel-files-in-c-sharp the translation to C++/CLI should not be too hard