It's hard to understand what's happening without seeing the code.

Anyway, I don't see why you discarded Laravel-Excel (text is missing), but I think it supports every feature you mentioned, also, as others said, it's a wrapper of phpSpreadsheet, which is the most complete library for this kind of files available.

Check the "Concerns" part in the documentation, every case is covered with examples.