the scope of '$text_format' is not available to the worksheet->write line.

Why do you say that? Can you please explain how scope works and why $text_format would be out of scope for the worksheet->write line?