.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Create custom template for Exporting a list to Excel?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

I have noticed when you are in the Datasheet View of a List, and if you choose "Query List with Excel" from the task pane, that when the list opens in Excel is it in a formatted worksheet (alternating colors/rows of light blue and dark blue). Yuck!

Anyway, I want to be able to Export the data to an Excel worksheet in a format of my choosing. Our team will want a minimalist approach that is setup for proper printing with defined page breaks, etc. So, I would like to know how I can develop that kind of export template. Thanks!

View Complete Post

More Related Resource Links

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?

Quick Note: Create Custom List Definitions in SharePoint 2010

In this exercise, you create a custom list definition in Microsoft SharePoint 2010 and then create an event receiver that is triggered when the list is used.

Exporting MOSS 2007 List to Excel 2007

When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

Exporting SharePoint list to excel.

Hi All,   We have a SharePoint list in which one column is "Person or Group" and it can take multiple values. When we export it to spread sheet this column contains some junk data.We are using MOSS 2007 and Office 2007. Previously asked question on the same issue http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/00cc338d-8201-4b8d-b2ea-5979ee58a464 Does any one know of a Microsoft published article for this issue as we need to provide it to our higher ups for this issue.   Thanks.

create new custom list form in sharepoint designer and edit in browser

hi, i have created a new list using sharepoint designer 2007. now i inserted a custom list form to modify some field and add new ones. when i finished i will tight my new custom list to the custom form. what i want to know is. i see the status field in my new form. and i only want the status field to appear in the edit form for the one that has the permission to edit the status. then i tought of open the list in my browser and go to the list settings. but what i notice is i dont see my fields i have modified in sharepiont designer in the columns section i only see the ones from the existing list. my question is how can i hide the status field in the new item form that it only show in the edit form. and how do i get my new form in the column section so the end user can add more fields if they want without using sharepointdesigner thnx

how to create site collection by using custom template through programmatically?

hi all, how we can create site collection by using custom template through programmatically? please give me some suggestions. where we need to save this custom template... thanks in advance..

how to create site collection by using custom template through programmatically?

hi all, how we can create site collection by using custom template through programmatically? please give me some suggestions. where we need to save this custom template... thanks in advance..

Excel data to MOSS custom list

Hi, My requirement is that I have some excel sheets on server and i want to import those data into MOSS2007 site custom list. what is the best approach to achieve this?

Enabling Enterprise Key Words for a custom list template

Hi, I have developed a list template in the usual manner, using features that create site columns, content types and then a list template that leverage's the content type.  I have a problem with Enterprise Keywords.  As this is simply a Yes/No type activation, I take it this column is slightly different from normal site columns.  When I first extracted my list template from a site with keywords activated, all I can see is that the keywords column has been added to the columns in the template.  There doesn't seem to be any setting that indicates that Managed Keywords is activated.  Regardless, I can create list instances from my template fine and the managed keywords column appears as expected.  The strange behaviour is that when I upload a new document and enter keywords for it, although these keywords are entered into the termstore, when I next view the document properties, the entries have dissapeared.  Is there something I need to do through code for this.  My problem is, as I want this setting to be enabled for a list template, How else do I activate the setting considering I cannot run code from a list template?  I hope someone can help, Cheers,   Amit

Create a list definition without a Custom Content Type

is it possible to create a list definition without creating a custom content type?  I want to create a list definition and select "Custom List" and then I just want to add fields to the custom list and not create a content type that will show up in the SharePoint GUI.  Seems like to get the new fields to show up in the new and edit forms I have to add the fields to a custom content type.

Create a custom search for searcing contents of a sharepoint list

Hi, I am new to sharepoint, i am working on a assignment to create a custom search for a specific sharepoint list . I would like to implement a search by multiple filter criteria's. I am using sharepoint 2007 and with no administrator privileges to the sharepoint server. Can someone guide me with this request. Thanks,  

Workflow - automatically create discussion item using title field of of custom list item as its subj

Anyone any ideas as to how I can configure SharePoint to create a discussion item using the title of a list item. e.g. user creates list item on a custom list - SP automatically creates a Discussion thread for this list item in the discussions list. I'm guessing this can't be down OOTB . would I be looking at SPD or a coded solution ? regards, Counie

Custom list export to excel only selected items


I want to export selected items from the list to Spreadsheet, currently its exporting all items in view.

My client does not want to use datasheet>>filter>>export option.

Is there any out of box solution to only the selected items to excel? otherwise what would be best way to achieve using coding?


Create dynamic dropdown list when we export data to excel using SSRS.


Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?



Custom Page Template (List.aspx) - one to many relationship


Hi, I have two tables which is Customer and Customer Details table, with one to many details.

Is there possible to show Child table's column in (done in one GridView) Customers/Lisp.aspx?

Create Custom Site Template & Deploy as Farm Solution


So I've seen a few posts and blogs about this, but nothing with the specific error I'm getting.  All I'm trying to do is create a custom site template from an existing site (now WSP), and make that custom template available in CA so I can create host-named site collections from that template in PowerShell.  Apparenly this was a lot easier in 2007, as you could just save your template as STP, and run some stsadm addsolution to get it in the farm.  With 2010, I've read there are 2 options:

  1. Install-SPWebTemplate
  2. Deploy via Visual Studio 2010

I've tried running Install-SPWebTemplate (which only takes CAB files), and NOTHING I do works.  I've created a cab from the WSP with makecab, I've renamed the WSP to CAB, and all I get is "cannot find or parse web template file".  So on to VS2010.

Using this article as a guide (http://msdn.microsoft.com/en-us/library/ff408263.aspx), I created a new 2010 Import existing solution project, left all items selected, and the import was successful.  I made a change or two to the ONET.xml to fix some things, and then I just try to deploy it to the farm.  Whether I set the URL to the root intranet site, or the CA URL, I get deployment conflict errors:

"The URL or

What's the "right" way to create a site template and inherit a custom master page?


Correct me if I'm wrong, but in 2007 whatever masterpage you had selected was saved in the site template and was re-created when a new site was created from said template.

It occurs to me that it's different in 2010.

Custom master pages from a site template aren't inherited and they don't keep the specified value when you ask it to before creating the template itself.

So, what's the "correct" way?  What's the difference in making a site template using a blank site or publishing site?

Here I thought I'd be able to make a site template and move on to my next project.

Thanks in advance!


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend