从SharePoint 2010网站上导出list的方法
我们可从SharePoint网站上导出iqy文件然后把iqy文件导入Excel。还有我们可以用VBA来做这个事情，代码如下：
using System;using System.Collections.Generic;using System.Linq;using System.Text;using Microsoft.Office.Tools.Ribbon;using Excel = Microsoft.Office.Interop.Excel;using System.Windows.Forms;namespace ExcelAddIn1{ public partial class Ribbon1 { private void Ribbon1_Load(object sender, RibbonUIEventArgs e) { } private void button1_Click(object sender, RibbonControlEventArgs e) { Excel.Application xlApp = Globals.ThisAddIn.Application; Excel.Workbook xlWorkbook = xlApp.ActiveWorkbook; Excel.Worksheet xlWorksheet = xlWorkbook.ActiveSheet; string SharePointHomeAddress = "http://*****/sites/****/****"; string ListAddress = SharePointHomeAddress + "/_vti_bin"; string ListID = "{********-****-****-****-************}"; string ViewID = ""; //ViewID = "{********-****-****-****-************}"; try { xlWorksheet.ListObjects.Add(SourceType: Excel.XlListObjectSourceType.xlSrcExternal, Source: new object[] { ListAddress, ListID, ViewID }, LinkSource: true, Destination: xlWorksheet.Range["A1"]); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }}