Formatting an EXCEL Worksheet Generated From The 400

Found on the Midrange-L Mailing List - http://www.midrange.com

Recently, an associate, Ricky Thompson, gave me this tip. 
He said, MS Excel will open a text file, formatted as an HTML 
table, without any intervention if the file has a .xls extension. 
Try it. Paste the HTML below into notepad and save it with the 
.xls extension then open it in Excel.

You'll just need to create a the file with HTML table tags instead 
of a CSV file. I'll leave that as an exercise for the reader. :)


Product Id
Description
On
Hand

WIDGET-A
A
Widget
0
WIDGET-B
B
Widget
255


HTH

Reggie Acosta

[report a broken link by clicking here]