Hi mukund,

Could you provide some more information on this? You say you have your own form, do you have your own controller and bits in the back office that allow you to see the results?

If you have your own controller that the back office is using, you could easily extend your controller to have an action that returns your excel export.

Nik

Yes Nik, I have controller which handle operation on form and save the data. Now i get list view of my all record , on that i want to provide functionality of export.

My post might help you

http://www.codeshare.co.uk/blog/how-to-export-data-to-excel-as-a-csv-file-in-c/

I am using EyeCatchCSVGenerator package for this,

Got an error Server cannot set content type after HTTP headers have been sent. ? did i miss some thing ?

Hi Paul , Now i am trying your approach to export . But every time i get blank file .

Please look at my code and tel what is wrong ?

public ActionResult CreateCsv()
    {
        try
        {
            var contactNodes = Umbraco.ContentAtRoot().DescendantsOrSelf("contactPage").FirstOrDefault();


            List<ExportModel> products = new List<ExportModel>();

            foreach (var Item in contactNodes.Children)
            {
                ExportModel ContactListItem = new ExportModel();
                ContactListItem.Id = Item.Id;
                ContactListItem.Name = Item.GetPropertyValue<string>("contactName");
                ContactListItem.Email = Item.GetPropertyValue<string>("email");
                ContactListItem.Telephone = Item.GetPropertyValue<string>("telphone");
                ContactListItem.Comment = Item.GetPropertyValue<string>("comments");
                ContactListItem.ContactDate = Item.GetPropertyValue<string>("contactDate");
                ContactListItem.IpAddress = Item.GetPropertyValue<string>("iPAddress");
                products.Add(ContactListItem);
            }

            List<ExportModel> EMs = products;


            var grid = new GridView();
            grid.DataSource = EMs;
            grid.DataBind();

            Response.ClearContent();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", "attachment; filename=Contact.xls");
            Response.ContentType = "application/ms-excel";

            Response.Charset = "";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);

            grid.RenderControl(htw);

            Response.Output.Write(sw.ToString());
            Response.Flush();
            Response.End();             
            ViewBag.thankyouexportedstr = "Record are explorted successfully";

        }
        catch (Exception e)
        {
            ViewBag.thankyouexportedstr = "Excetion occured during export" + e.StackTrace  ;
            throw;
        }           
        return PartialView("ThankYouExported");
    }      

is working on a reply...