How export list in excel file

Question

I want to create a button that exports specific list into the excel file. But when I do it I always get the same error:

Error List does not exist. The page you selected contains a list that does not exist. It may have been deleted by another use

How can it be possible? List exists, because I get id from object model so I should get a NullReferenceException otherwise. Here is my code:

<input type="button" onclick="window.location.href='<%= ExcelUrl %>';" value ="Export data"/>

code:

    protected override void OnPreRender(EventArgs e)
    {
        string listName = Lang.Localize("xxx", "List_Measures");
        using (var site = new SPSite(SPContext.Current.Site.ID))
        using (var web = site.OpenWeb(SPContext.Current.Web.ID))
        {
            var list = web.Lists[listName];
            const string relativeUrlMask = @"_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={0}&View={1}&CacheControl=1";                
            ExcelUrl = new Uri(new Uri(site.Url), string.Format(relativeUrlMask, list.ID.ToString("B"), list.DefaultView.ID.ToString("B"))).AbsoluteUri;
        }
        base.OnPreRender(e);
    }

finally I get an url:

http://mysite/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=%7B27f5c5b6-e01d-4951-8be5-b31a72eda0e2%7D&View=%7Be518453d-c622-4f31-a0e7-09179f67dce3%7D&CacheControl=1

and it throws this exception. How make it work?

---

usage of web.Url instead of site.Url doesn't work

---

Now i get correct url, but have another problem: it says that I have not enough permissions event if I'm logged under System account. How can it be actually possible?..

Answer 1

if you are working with Sharepoint2013 than 2013 provide out of the box service to export sharepoint list to Exel or Access. I have refer This one , you can also try it .

https://www.microsoftpressstore.com/articles/article.aspx?p=2224034&seqNum=2

Answer 2

Instead of exporting from SharePoint, you can try importing from Excel through add-ins like http://www.cdata.com/drivers/sharepoint/excel/ (commercial). The Excel Add-in allows you to connect to Sharepoint lists, and filter data through transact SQL.