There doesn't seem to be anything wrong in the code that you have shown.

However it is hard to tell from just this code. It would be better if you could post a fully working example that demonstrates the problem. Use the bug_report program in the standard Spreadsheet::WriteExcel distro as an example.

The main reasons that an Spreadsheet::WriteExcel file will fail to load in Excel are:

• The file was corrupted in the transfer to a Windows system. Check if the excel file on the generating system is the same size as the file on the target system.
• The Spreadsheet::WriteExcel file was corrupted by UTF8 data (sometimes happens in conjunction when extracting data from a XML file with Perl 5.6).
• A merge format was used in a non-merged cell.

--
John.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.