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

[garrymacin]

This post is deleted!