in reply to Formatting text when outputting to a XLS file

Have you looked at Excel::Template or the module it wraps, which is Spreadsheet::WriteExcel? It seems that either of those modules should do what you want, and more.

I'm not sure you really understand what you're asking in terms of lists of multiple things. How exactly do you want the Excel to turn out? Also, it's important to note that unless you're using Win32::OLE, it's not possible to completely control the XLS output from Perl.

As for .txt or .doc ... you'll want to look at Text::xSV for the .txt (if you want tab-delim). .doc is out of my knowledge.

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

  • Comment on Re: Formatting text when outputting to a XLS file