You will probably need Excel automation for this. You might be able to use a commercial datagrid --> excel component. But I don't think there are any out there which will do what you want.
The formatting might be easily done with this free component: http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx But you will probably have to use automation to get the drop down effect. ----- Original Message ----- From: "Yukon" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, September 05, 2005 5:00 PM Subject: [AspNetAnyQuestionIsOk] Merge Grid data with Excel template > Hi there: > My question is that I want to take the data from the > datagrid/dataset and merge it into an already made > excel template(in MS Excel). Another problem is that > there is supposed to be a column in the worksheet > having a dropdown list with fixed values. > > Please guide me on this. > > Thanx > > Yukon > > > > > > > ______________________________________________________ > Click here to donate to the Hurricane Katrina relief effort. > http://store.yahoo.com/redcross-donate3/ > > > > > > > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
