Solved Creation of excel sheet(.xlsx) with multiple tabs
-
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.
-
@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. -
Thanks for your response.
Actually i want to develop this with Qt only. Is there any specific Qt template to achieve this? -
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 fieldIf 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