If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Exporting a DataGrid to Excel

Martel · 2005-07-11 14:22:45

Hey, I'm after writing a database app in C# (not my language of choice) and now I've been asked to export the datagrids to Excel, so they can be printed and such. There's some ASP code for exporting datagrids floating around on the net, but not much on ADO. Any one wanna offer any ideas/help/code etc?

11-07-2005 02:22PM

#1

Martel

Registered Users, Registered Users 2 Posts: 28 ✭

Join Date: March 2005

Posts: 22

Hey, I'm after writing a database app in C# (not my language of choice) and now I've been asked to export the datagrids to Excel, so they can be printed and such. There's some ASP code for exporting datagrids floating around on the net, but not much on ADO. Any one wanna offer any ideas/help/code etc?

0

Comments

#2 11-07-2005 02:37PM

Evil Phil

Registered Users, Registered Users 2 Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

What version of excel are you using? If it supports xml then the problem is easily solved. If not there are other ways of getting the data in there

0
#3 11-07-2005 03:37PM

mewso

Moderators, Science, Health & Environment Moderators Posts: 9,059 Mod ✭✭✭✭

Join Date: February 1998

Posts: 8445

The writer doesn't say in this article but I'm fairly sure it's office xp/2003 only. Might help though.

0
#4 11-07-2005 03:55PM

Evil Phil

Registered Users, Registered Users 2 Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

I have code at home that opens an odbc connection to an excel file and allows you to drop a dataset into a named range. I'll look it up tonight.

0
#5 12-07-2005 03:00PM

Kai

Registered Users, Registered Users 2 Posts: 604 ✭✭✭

Join Date: August 2002

Posts: 491

Try this
http://www.c-sharpcorner.com/Code/2003/Sept/ExportASPNetDataGridToExcel.asp

I havent tried it myself but it may give you an idea.

0