Report Control - Save in Excel

Print Page | Close Window

Save in Excel

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=4599
Printed Date: 30 April 2025 at 6:35am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Save in Excel

Posted By: hnhd
Subject: Save in Excel
Date Posted: 15 July 2006 at 6:50am

How can I export data of Reportcontrol to Excell?

Replies:

Posted By: nighthawk
Date Posted: 20 July 2006 at 5:04am

I've never seen any built-in way to do that but it isn't too hard to loop through the rows and columns and output the data to a tab delimeted text file. This file can then be directly opened in Excel and it will automatically be formated correctly.

Posted By: ianp
Date Posted: 25 July 2006 at 3:34pm

If you require the excel export to retain the "look and feel" of the report control, you will need to loop through the control writing the rows and items to the rows and columns of an excel spreadsheet object, setting the formats as you go using the paintmanger and the row metrics.