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?