devxlogo

Export HTML Data into Excel Files

Export HTML Data into Excel Files

Why Trust Us

Nowadays, many reports are generated as HTML documents for access on the Web. This tip shows you how to export that HTML data as it is (including all the CSS styles, tables borders, etc.) into an .xls file which can be saved and used as you need it.

Include the following code in the .jsp page that generates the report/HTML page:

	String mimeType = "application/vnd.ms-excel";	response.setContentType(mimeType);

The output is transferred to an .xls document.

Please Note: Microsoft Excel must be installed on the client’s computer for this to work.

See also  Professionalism Starts in Your Inbox: Keys to Presenting Your Best Self in Email
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More