Re^3: Printing extracted Excel data into a HTML table


more useful options
	PerlMonks

Re^3: Printing extracted Excel data into a HTML table

by Siddartha (Curate)

on Dec 09, 2005 at 15:28 UTC ( [id://515563]=note: print w/replies, xml )

Need Help??

in reply to Re^2: Printing extracted Excel data into a HTML table
in thread Printing extracted Excel data into a HTML table

yes sorry, didn't think about that. This is all the original code with a few extra prints in. Didn't want to rewrite his code for him. But yes I did forget about empty rows. So instead of:

print "<td>" . $CellObject->Value . "</td>" if ($CellObject);

I would do: 

print ($CellObject ? ("<td>" . $CellObject->Value . "</td>") :"<td>&nb
+sp;</td>");
[download]

Updated: added   as ww suggested. Otherwise it might render like crap.