Tuesday, October 27, 2009

Better Report Format for Spreadsheets

There's been a problem for a while with our "spreadsheet" reports.  Not a problem, I guess, but more of a frustration.  We've been generating our reports in a "CSV" format (comma seperated value) because it's easy and Excel can read it (so can other spreadsheet programs).  However, the lack of formatting seems to throw some users off, especially those that are less comfortable with how Excel works.  In order to better cater to that group we're now experimenting with a new library that allows us to write directly to real excel (*.xls) files.  To try out this feature for your reports, and see if the format works better for you, see the screen shot below:



"CSV Spreadsheet" gives you the same spreadsheet report you're used to, but "Excel Spreadsheet" does the work of trying to format the columns to be the right length and things like that.  Try it out, and let us know what you think in the comments!

~Ethan

No comments:

Post a Comment