How to download data in excel file from dataset in webpart
-
Hi all, I am posting this thing second time as i m not able to solve this yet. I have a dataset and a link(a href). when somebody click on that, the data from the dataset should be downloaded in to the excel file.i m working in sharepoint portal and creating web part using C#.I surf forums, which has the solution for this.But it include creating a class and a method. The thing is that, we dont have any onclick event for HyperLink in ASP.NET. if any solution with javascript, that's good too.If, any body can help me in this problem it would be appreciated. Thank you very much. NIKI
-
Hi all, I am posting this thing second time as i m not able to solve this yet. I have a dataset and a link(a href). when somebody click on that, the data from the dataset should be downloaded in to the excel file.i m working in sharepoint portal and creating web part using C#.I surf forums, which has the solution for this.But it include creating a class and a method. The thing is that, we dont have any onclick event for HyperLink in ASP.NET. if any solution with javascript, that's good too.If, any body can help me in this problem it would be appreciated. Thank you very much. NIKI
hi, You can create DTS package for this. DTS package will accept the DS as parameter and fill the sheet. In excel sheet you have to make template with the name range. So, while filling the excel sheet, DTS package refer that name range. Naishadh Mandaliya
-
hi, You can create DTS package for this. DTS package will accept the DS as parameter and fill the sheet. In excel sheet you have to make template with the name range. So, while filling the excel sheet, DTS package refer that name range. Naishadh Mandaliya
Hi Naishadh, Thanks for the quick response. But, to be very honest, I am new in the sharepoint environment.I know, how to export data to excel in asp.net,but not in sharepoint.If you can give me some details or some type of code, that will be great for me. Thanks, NIKI