Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct
Creation of excel sheet(.xlsx) with multiple tabs
Venkatesh V last edited by aha_1980
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 last edited by
Venkatesh V last edited by
Thanks for your response.
Actually i want to develop this with Qt only. Is there any specific Qt template to achieve this?
VRonin last edited by
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
QAxObjectto 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 Banned last edited by
This post is deleted!