CMake and Visual Studio
C++ library for creating XLSX files for MS Excel 2007 and above.
Brought to you by:
oxod,
programmeralex
Hey,
I am trying to get it working for 2 days with no luck. I used CMake with VS 15 x64, used visual studio community 2017 to build it and included all .h and .lib to my project as well as included paths to it.
I am still getting unresolved external symbols. How am I supposed to get it working? Why is it so hard to just use the library.
Impossible library to use. So fkin complicated. Good luck everyone I'm done with this
Hi,
It is so hard because it is C++ world.
I do not use Visual Studio and I don't know how well it supports CMake. I also could not get it to work with CMake (latest VS2017).
By this reason, I created a new project "Static library" and set it up.
Then I created a second project "Console Application" and set it up.
And I have all turned out.
You can find both projects in the attachment. They are configured in "Debug/x86" mode.
Please let me know your test results.
P.S. It took me about 30 minutes along with reading the Visual Studio documentation.
Just in case:
https://blogs.msdn.microsoft.com/vcblog/2016/11/16/cmake-support-in-visual-studio-the-visual-studio-2017-rc-update/
However I never used it.
I read this:
https://docs.microsoft.com/en-us/cpp/ide/cmake-tools-for-visual-cpp?view=vs-2017
But in my case, CMake menu item did not even appear.
Just when I posted it, I was able to compile and run without errors. Obviously my mistake all the way, since I'm new with using external libraries, never used CMake or .lib in my life. However,
the problem was that I had to set up the paths to .lib and .h for both, release and debug, and somewhere in all that chaos I set paths for .h in release and .lib for debug only, so neither of them were working. It was horrible but after it compiled I've been smiling for few minutes.
Thanks
I'm glad you did it. I wish you successful use of the library :-)
Can I ask one thing though. I have to write some statistical data to excel format from .txt because our analyst can import only .xlsx to R. I work with dates a lot, but I noticed that when I write date to a cell, it shows date no problem, but time is in there as well, just invisible or something, can I somehow write DATE only?
Last edit: gregor novicki 2018-10-15
Answer in next topic: https://sourceforge.net/p/simplexlsx/discussion/general/thread/2b80c74f02/