As roboticus said, since we don't have the same old.xls that you do, and we don't know what attributes you are looking for in new.xls, we can't necessarily see what you mean: we might be seeing missing attributes you don't care about, and we might be not-seeing changed attributes that you do care about (either because it's not obvious, or our old.xls didn't include the attributes you cared about).

Some things I've noticed:

• to expand on ++roboticus's mentioning hardcoded align => 'left', valign => 'top': make use of $alignH and $alignV; maybe something like

      align  => (undef, qw(left center right fill justify center_across)
  +, undef)[$alignH],    # Spreadsheet::WriteExcel doesn't say what to d
  +o with Spreadsheet:ParseExcel's 0=>NoAlignment or 7=>Distributed, so 
  +I assume undef
      valign => (qw(top vcenter bottom vjustify), undef)[$alignV],  # Sp
  +readsheet::WriteExcel doesn't say what to do with Spreadsheet:ParseEx
  +cel's 4=>Distributed, so I assume undef
  [download]

• border => 1 is manually setting the border to 1px black, instead of using information from ::ParseExcel
• You are only grabbing the bold and color attributes of the font, so will be missing font size, font type, and possibly other attributes important to you
• You never grab or set row height or column width
  ⇒ I don't immediately see how to grab them from ::ParseExcel's docs; if you figure out how, then ::WriteExcel's ->set_row() and ->set_column() will set them for new.xls

---

---

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.