`export(EXPORT)` does not work for windows?

YES, it is!

If have implemented it to today: Use GenerateExportHeader by ClausKlein · Pull Request #1 · ClausKlein/spglib (github.com)