MVC implements the function of generating Excel and downloading

This article has shared with you the specific code for MVC to generate Excel and download it for your reference. The specific content is as follows

Due to the requirements on the project, it is necessary to export the Excel file with the specified conditions. After a lot of trouble, it finally came true.

Now post the code and share it

(Share part of the auxiliary class code in our project directly)

Our project uses MVC4.0 mode.

Each ActionResult will inevitably return a View or Json, etc. (The parameters in View or Json are of type object)

Therefore, we need a public class to uniformly define the "success or failure" state of the operation or return the operation message, as well as the unity when receiving return parameters using jquery $.get() and $.post().

The following is the StatusMessageData class. (Of course, if you just want to export Excel, this class does not need to be defined.)

/// &lt;summary&gt;
 /// Auxiliary transmission of StatusMessage data /// &lt;/summary&gt;
 [Serializable]
 public sealed class StatusMessageData
 {
  private StatusMessageType messageType;
  /// &lt;summary&gt;
  /// Prompt message category  /// &lt;/summary&gt;
  public StatusMessageType MessageType
  {
   get { return messageType; }
   set { messageType = value; }
  }

  private string messageContent = ;
  /// &lt;summary&gt;
  /// Information content  /// &lt;/summary&gt;
  public string MessageContent
  {
   get { return messageContent; }
   set { messageContent = value; }
  }

  private object data;

  /// &lt;summary&gt;
  /// data  /// &lt;/summary&gt;
  public object Data
  {
   get { return data; }
   set { data = value; }
  }
  /// &lt;summary&gt;
  /// Constructor  /// &lt;/summary&gt;
  /// <param name="messageType">Message Type</param>  /// <param name="messageContent">Message Content</param>  public StatusMessageData(StatusMessageType messageType, string messageContent, object data)
  {
    = messageType;
    = messageContent;
    = data;
  }
  public StatusMessageData(StatusMessageType messageType, string messageContent)
  {
    = messageType;
    = messageContent;
  }
  public StatusMessageData()
  {
  }
 }

 /// &lt;summary&gt;
 /// Prompt message category /// &lt;/summary&gt;
 public enum StatusMessageType
 {
  /// &lt;summary&gt;
  /// success  /// &lt;/summary&gt;
  Success = 1,

  /// &lt;summary&gt;
  /// mistake  /// &lt;/summary&gt;
  Error = -1,

  /// &lt;summary&gt;
  /// Prompt message  /// &lt;/summary&gt;
  Hint = 0,
  /// &lt;summary&gt;
  /// Remind to log in  /// &lt;/summary&gt;
  Login = 5,
  /// &lt;summary&gt;
  /// Prompt redirection  /// &lt;/summary&gt;
  Redirect = 6,
 }

Defining ExportExcel ActionResult in Controller

[HttpPost]
  public ActionResult ExportExcel(SearchModel model)
  {
   
   
   StatusMessageData result = new StatusMessageData();
   if ( == null ||  &lt;= 0)
   {
     = ;
     = "No data to be downloaded";
    return Json(result);
   }
   string fileglobal = "";
   //Organize Excel tables   StringBuilder sb = new StringBuilder(400);
   ("&lt;table cellspacing='0' rules='all' border='1'&gt;");
   ("&lt;thead&gt;");
   ("&lt;tr&gt;");
   ("<th>Column One</th>");
   ("<th>Column 2</th>");
   ("<th>Column Three</th>");
   ("<th>Column IV</th>");
   ("&lt;/tr&gt;");
   ("&lt;/thead&gt;");
   ("&lt;tbody&gt;");
   try
   {
      foreach (var item in )
      {
       ("&lt;tr&gt;");
       ("&lt;td&gt;");
       (item.column1);
       ("&lt;/td&gt;");
       ("&lt;td&gt;");
       (item.column2);
       ("&lt;/td&gt;");
       ("&lt;td&gt;");
       (item.column3);
       ("&lt;/td&gt;");
       ("&lt;td&gt;");
       (item.column4);
       ("&lt;/td&gt;");
       ("&lt;/tr&gt;");
       
      }
    }
   
    ("&lt;/tbody&gt;");
    ("&lt;/table&gt;");
    //Write to file in UTF8 format    byte[] contentBytes = Encoding.(());

    string rootDirServerPath = "Save the generated file in the specified directory name";
    // Since there is basically no concurrency in downloading Excel files on our project, naming files only in the year, month, day, hour, minute and second can avoid the problem of generating the same file name files.    string fileSaveName = "Downloaded file name_" + ("yyyyMMddHHmmss") + ".xls";

    string rootDirServerPhysicPath = ("~" + rootDirServerPath);
    if (!(rootDirServerPhysicPath))
    {
     (rootDirServerPhysicPath);
    }
    string[] strFiles = (rootDirServerPhysicPath);
    if ( &gt; 0)
    {
     foreach (string strFile in strFiles)
     {
      (strFile);
     }
    }
    //The following is to save the file to the specified directory    string userFailedSummaryFileSavePath = rootDirServerPhysicPath + "/" + fileSaveName;
    if ((userFailedSummaryFileSavePath))
    {
     (userFailedSummaryFileSavePath);
    }
    (userFailedSummaryFileSavePath, contentBytes);
    //Assemble the full path to the file to be downloaded.    fileglobal = rootDirServerPath + "/" + fileSaveName;
   }
   catch (Exception ex)
   {
     = ;
     = ();
    return Json(result);
   }
    = ;
    = "Downloading, please wait...";
    = fileglobal;
   return Json(result);
  }

After completing the operation of generating Excel, make asynchronous calls on the page.

$("#export-excel").click(function (e) {
    ();
    $.post("Controller/", $("#Form1").serialize(), function (data) {
      (, 1.5, , function () {
        if ( == 1) {
          ();
        } else {
          //Error operation        }
      });
    });
  });

The above is all the operations in our project about Excel generation to download.

There are fewer considerations and simpler writing.

If you have any good ideas, you can leave a message. I will definitely learn and practice it before sharing it.

Thank you so much.

The above is all the content of this article. I hope it will be helpful to everyone's study and I hope everyone will support me more.