Change file extension on gridmvc.net for csv download

Question

Is there anyway to change the file extension on a csv download from mvcgrid? It downloads as .csv and i'd like .txt to stop my users from opening the contents in excel?

I can see there is a custom rendering engine, but that seems to offer file contents formats rather than the extension.

Thanks

Answer 1

Managed it via a customendering engine

using MVCGrid.Interfaces;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;

namespace MVCGrid.Web.Models
{
    public class TextExportEngine : IMVCGridRenderingEngine
    {
        public bool AllowsPaging
        {
            get { return false; }
        }

        public void PrepareResponse(HttpResponse httpResponse)
        {
            httpResponse.Clear();
            httpResponse.ContentType = "text/comma-separated-values";
            httpResponse.AddHeader("content-disposition", "attachment; filename=\"" + "export" + ".txt\"");
            httpResponse.BufferOutput = false;
        }

        public void Render(MVCGrid.Models.RenderingModel model, MVCGrid.Models.GridContext gridContext, System.IO.TextWriter outputStream)
        {
            var sw = outputStream;

            StringBuilder sbHeaderRow = new StringBuilder();
            foreach (var col in model.Columns)
            {
                if (sbHeaderRow.Length != 0)
                {
                    sbHeaderRow.Append(",");
                }
                sbHeaderRow.Append(Encode(col.Name));
            }
            sbHeaderRow.AppendLine();
            sw.Write(sbHeaderRow.ToString());

            foreach (var item in model.Rows)
            {
                StringBuilder sbRow = new StringBuilder();
                foreach (var col in model.Columns)
                {
                    var cell = item.Cells[col.Name];

                    if (sbRow.Length != 0)
                    {
                        sbRow.Append(",");
                    }

                    string val = cell.PlainText;

                    sbRow.Append(Encode(val));
                }
                sbRow.AppendLine();
                sw.Write(sbRow.ToString());
            }
        }

        private string Encode(string s)
        {
            if (String.IsNullOrWhiteSpace(s))
            {
                return "";
            }

           
            return s;
        }

        public void RenderContainer(MVCGrid.Models.ContainerRenderingModel model, System.IO.TextWriter outputStream)
        {
        }
    }
}

and then adding the following to my grid definition

                .AddRenderingEngine("tabs", typeof(TextExportEngine)