all list items are converted into excel through programicall

Question

hi , Please help me , my quation is: all the list items are converted into Excel in sharepoint 2010 by using vs2010(visualstudio2010). Thank's, koti.

Shweta Lodha · Answer

Hi Koti, As per my understanding you want to expost Sharepoint list to Excel spreadsheet. Here are the steps: In your SharePoint site, on the top link bar, click Documents and Lists . On the Documents and Lists page, click the list that you want to export to Excel. On the page that displays the list, under Actions , click Export to spreadsheet . In the File Download dialog box, click Open . In the Opening Query dialog box in Excel, click Open . If no workbook is open, Excel creates a new blank workbook and inserts the list on a new worksheet. If a workbook is open, in the Import Data dialog box, select one of the following options: To insert the list in the active worksheet, click Existing worksheet . In the worksheet, click the cell where you want to place the upper-left corner of the list, and then click OK . To insert the data in a new worksheet, click New worksheet and click OK . To insert the data in a new workbook, click New workbook and click OK . To create a PivotTable report based on the list, click Create a PivotTable report , and follow the steps in the PivotTable and PivotChart Wizard. Original link: http://office.microsoft.com/en-in/excel-help/export-a-sharepoint-list-to-a-spreadsheet-HA001119639.aspx

Lakshmanan Sethu · Answer

Hi Koti, Are you looking for OOTB feature?

all list items are converted into excel through programicall

Answers (2)