|
Save in Excel |
Post Reply 
|
| Author | |
hnhd 
Newbie 
Joined: 10 July 2006 Status: Offline Points: 9 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Save in ExcelPosted: 15 July 2006 at 6:50am |
|
How can I export data of Reportcontrol to Excell?
|
|
 |
|
|
nighthawk
Senior Member 
Joined: 11 June 2004 Status: Offline Points: 167 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
ianp
Moderator Group 
Joined: 19 December 2003 Location: United Kingdom Status: Offline Points: 119 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options