Copy and pasting Excel Sheet data to Grid for MVC | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (173).NET Core  (29).NET MAUI  (203)Angular  (107)ASP.NET  (51)ASP.NET Core  (82)ASP.NET MVC  (89)Azure  (40)Black Friday Deal  (1)Blazor  (211)BoldSign  (13)DocIO  (24)Essential JS 2  (106)Essential Studio  (200)File Formats  (65)Flutter  (132)JavaScript  (219)Microsoft  (118)PDF  (81)Python  (1)React  (98)Streamlit  (1)Succinctly series  (131)Syncfusion  (897)TypeScript  (33)Uno Platform  (3)UWP  (4)Vue  (45)Webinar  (50)Windows Forms  (61)WinUI  (68)WPF  (157)Xamarin  (161)XlsIO  (35)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (8)Business intelligence  (55)Button  (4)C#  (146)Chart  (127)Cloud  (15)Company  (443)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (63)Development  (618)Doc  (8)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (5)Essential Tools  (14)Excel  (39)Extensions  (22)File Manager  (6)Gantt  (18)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (501)Mobile MVC  (9)OLAP server  (1)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (42)Performance  (12)PHP  (2)PivotGrid  (4)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (12)Road Map  (12)Scheduler  (52)Security  (3)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (31)Solution Services  (4)Spreadsheet  (11)SQL  (10)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (112)UI  (381)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (17)Web  (582)What's new  (323)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

Copy and pasting Excel Sheet data to Syncfusion Grid for MVC

As a member of the Grid ASP.NET MVC team, I discovered a cross-browser way to access data pasted in an HTML <div> element. I was wondering why this couldn’t be used in our Syncfusion Grid control to paste data from Excel. It ends up it can. I’ve provided the following steps on how to enable this in the grid.

Essential Grid preparation
For the purpose of this demo, I’ll use a simple grid configuration. The grid definition in the View page is as follows.

 

    Html.Syncfusion().Grid("Grid1")
    .ActionMode(ActionMode.Server)
    .Caption("Employee")
    .AllowSelection(false)
    .ShowCaption(true).EnableSorting()
    .Datasource(Model)

The Controller side codes are as follows:

   public ActionResult Index()
  {

   // Passing Data to View
  return View(EmployeeRepository.GetEmployees());
  }
 [HttpPost]
  public ActionResult Index(PagingParams args, string pastedData)
  {
// Get data from repository
 var data = EmployeeRepository.GetEmployees();
  if (pastedData != null)
 {

 // parsing pasted data to Actual type
  var parsed = (List)new JavaScriptSerializer().Deserialize(pastedData, typeof(List));
  // Updating those the Database
  EmployeeRepository.AddRange(parsed);
   }
  // Returning GridAction
  return data.GridActions();
 }

Converting a pasted date to JSON
The HTML markup and jQuery scripts play a vital role in getting clipboard Excel information and converting it to JSON. Also for this purpose, I wrote the jquery.pastable.js file in the jQuery plug-in style. You can use that JavaScript file in this sample. The final reduced script and HTML markup are as follows.

[cshtml]

 

[jQuery]

 $(document).ready(function () {
  // Binding the paste-able jQuery plug-in.
   $("#pastable").pastable({
   OnPasteComplete: function (data) {
   // Ensuring the pasted information is Excel data or HTML table data.
   if (data instanceof Object) {
   // Acquiring grid object
   var grid = $find("Grid1");
    var fn = function (sender, args) {
  // Serializing pasted data and add it grid request header for server-side access
   args.data["pastedData"] = Sys.Serialization.JavaScriptSerializer.serialize(data);
   sender.remove_OnActionBegin(fn);
   }

   // OnActionBegin event binding

 grid.add_OnActionBegin(fn);

  // Sending grid refresh request to update the pasted data
  grid.sendRefreshRequest();
  }
  }

  });

 });

The jquery.pastable.js file is attached with sample.

Output
The output will look like this:

[Grid]

Grid

[Excel Data]

clip_image002

[Before Pasting]

clip_image002

[After Pasting]

clip_image003

Sample link

As you can see, Essential Grid for ASP.NET MVC has client- and server-side libraries that are flexible enough to be used for any programming need.

 

– Bharath M

Tags:

Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed