Ask HN: report system, Excel or HTML?

Posted by jacktang on Saturday December 19, 2009 @04:02AM
from the ask-hn dept.

Hi Developers & Designers

I am a Rubist and now working on one report system, and decided to using excel(and template) to build the report, I chose the excel template because of two:

1. let the end user design the report by excel 2. let end user print the report in excel

but the problem is that it is hard to deal with the report with huge data, and now I want to choose raw HTML, the long report can be easy handled by adding pagination. And do you know any clean HTML report available on www?

Thanks!

( 8 comments | 5 points | on HN )

Re:Ask HN: report system, Excel or HTML? by jwallz on Saturday December 19, 2009 @09:19AM (#1004777)

You need to do both. dump the report to a page in html with pagination and have an export to excel button. For file export do it as tab delimited with a .xls extension.

[ Parent | on HN ]

Re:Ask HN: report system, Excel or HTML? by nailer on Saturday December 19, 2009 @11:03AM (#1004844)

What specifically is the problem? Are you likely to have more than 65K rows?

If not, Python's xlwt and xlrd modules handle support for native Excel in a very simple, OO, pythonic way, without any scary Windows or COM shit. I regularly generate and parse pretty big Excel files most days so I'd be happy to answer any questions.

[ Parent | on HN ]

Re:Ask HN: report system, Excel or HTML? by clscott on Saturday December 19, 2009 @12:42PM (#1004917)

If you render the report as an HTML document and serve it with a mime-type of application/vnd.ms-excel the users system will prompt them open it in excel.

Excel will parse it with all of the nice formatting and everything!

[ Parent | on HN ]

Re:Ask HN: report system, Excel or HTML? by jacktang on Saturday December 19, 2009 @01:04PM (#1004943)

thanks, clscott. I will try it

[ Parent | on HN ]

Re:Ask HN: report system, Excel or HTML? by yannis on Saturday December 19, 2009 @04:11AM (#1004621)

For reports (people like to print them), I normally use

(a) pdf (b) HTML

In that order!

If anyone needs excel I give them comma delimited for import!

[ Parent | on HN ]

Re:Ask HN: report system, Excel or HTML? by michael_dorfman on Saturday December 19, 2009 @06:37AM (#1004697)

A nice hack: if you give them comma delimited, but name the file ".xls", Excel will silently import it. and they'll never know the difference.

[ Parent | on HN ]

Re:Ask HN: report system, Excel or HTML? by nfnaaron on Saturday December 19, 2009 @09:57AM (#1004801)

Years ago I submitted a resume to an HR dept. It was plain text, with a .txt extension.

They said "we only accept Word files for resumes."

So I changed the .txt extension to .doc and resubmitted it.

I got the job.

[ Parent | on HN ]

Re:Ask HN: report system, Excel or HTML? by wendroid on Saturday December 19, 2009 @05:13AM (#1004650)

Like choosing which bullet to get shot by.

[ Parent | on HN ]