devxlogo

Outputting Results To An Excel Document

Outputting Results To An Excel Document

One drawback to presenting data to a browser is that once you have it you can’t manipulate it. With more and more business functions being carried out through the web nowadays, the ability to export result sets into Excel so the business users can have their way with the data is essential. You can do this by setting the MIME type of the browser output, but this doesn’t always go as planned. Or you could create an instance of the Excel object on your server, but this could drain valuable resources on your server if you are serving a large audience, and produce a pretty large *.xls file as a result. Instead you can use the FileSystemObject to output data into a text file that is comma separated (CSV file), a method that demands less of your server, creating a significantly smaller file.

 <%

See also  5 Tips for Choosing the Right Medical Software for Your Practice
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