Web Development

CSV (comma separated values) is just a data file format that provides for the separation of field values in records. It doesn't provide for any formatting of the data. Excel can open a CSV file, but from within the CSV, you can't specify colors, column widths, etc. I can think of two possible routes:

1. write a macro in Excel that automatically formats the sheet based on the data in the CSV file

2. Find a class that will write true Excel documents. A search on Google will probably getyou far in this area.

Good luck.

Jay
www.jayeckles.com

You can create formated spreadsheet and then populate it using the excel ODBC driver in combination with sun jdbc-odbc bridge. You can get more information on this by going to the javaworld article on this at http://www.javaworld.com/javaworld/javaqa/2001-08/02-qa-0824-excel2.html

You may also want to lock at http://www.actuate.com/Products/Software/eSpreadsheetSolutions.asp?bhcp=1

This question was auto closed due to inactivity