Clipboard in ASP.NET MVC Spreadsheet

23 Jun 20205 minutes to read

The Spreadsheet provides support for the clipboard operations (cut, copy, and paste). Clipboard operations can be enabled or disabled by setting AllowClipboard property in Spreadsheet.
By default AllowClipboard property is true.

Cut

This function cuts the selected range values and make it available in clipboard.

You can do this by one of the following ways.

• Using “Ctrl + X” key.
• Using Cut button of HOME tab in ribbon to perform cut operation.
• Using Cut option in Context Menu.
• Using cut method.

Copy

This function copies the selected range values and make it available in clipboard.

You can do this by one of the following ways.

• Using “Ctrl + C” key.
• Using Copy button of HOME tab in ribbon to perform copy operation.
• Using Copy option in Context Menu.
• Using copy method.

Paste

This function pastes the clipboard content to newly selected range. If you perform cut paste, clipboard contents are cleared whereas in copy paste the clipboard contents are maintained.

You have following options in Paste.

• Paste Special - You can paste the values with formatting.
• Paste - You can paste only the values.

NOTE

The default paste option is Paste Special. This is working only within the current Spreadsheet. If you copy the content from other sources, it will paste only the values in the Spreadsheet.

You can do this by one of the following ways,

• Using “Ctrl + V” key.
• Using Paste button of HOME tab in ribbon to perform paste operation.
• Using Paste option in Context Menu.
• Using paste method.

The following code example describes the above behavior.

CSHTML

@(Html.EJ().Spreadsheet<object>("Spreadsheet")
    .AllowClipboard(true)
    .Sheets(sheet =>
    {
        sheet.RangeSettings(range =>
        {
            range.Datasource((IEnumerable<object>)ViewBag.Datasource).Add();
        }).Add();
    })
    .ClientSideEvents(events => events.LoadComplete("loadComplete"))
)

<script type="text/javascript">
    function loadComplete() {
        var excelClip = this.XLClipboard;
        this.performSelection("G1:H3");
        excelClip.cut(); // Cut the selected cells
        //excelClip.copy();//Copy the selected cells.
        this.performSelection("J4");
        excelClip.paste();
    }
</script>

C#

namespace MVCSampleBrowser.Controllers
{
    public partial class SpreadsheetController : Controller
    {
        public ActionResult Default()
        {
            List<ItemDetail> lItems = new List<ItemDetail>();
            lItems.Add(new ItemDetail() { ItemName = "Casual Shoes", Date = new DateTime(2014, 02, 14), Time = new DateTime(2014, 02, 14, 11, 34, 32), Quantity = 10, Price = 20, Amount = 200, Discount = 1, Profit = 10 });
            lItems.Add(new ItemDetail() { ItemName = "Sports Shoes", Date = new DateTime(2014, 06, 11), Time = new DateTime(2014, 06, 11, 05, 56, 32), Quantity = 20, Price = 30, Amount = 600, Discount = 5, Profit = 50 });
            lItems.Add(new ItemDetail() { ItemName = "Formal Shoes", Date = new DateTime(2014, 07, 27), Time = new DateTime(2014, 07, 27, 03, 32, 44), Quantity = 20, Price = 15, Amount = 300, Discount = 7, Profit = 27 });
            lItems.Add(new ItemDetail() { ItemName = "Sandals & Floaters", Date = new DateTime(2014, 11, 21), Time = new DateTime(2014, 11, 21, 06, 23, 54), Quantity = 15, Price = 20, Amount = 300, Discount = 11, Profit = 67 });
            lItems.Add(new ItemDetail() { ItemName = "Flip- Flops & Slippers", Date = new DateTime(2014, 06, 23), Time = new DateTime(2014, 06, 23, 12, 43, 59), Quantity = 30, Price = 10, Amount = 300, Discount = 10, Profit = 70 });
            ViewBag.Datasource = lItems;
            return View();
        }
    }
}

The following output is displayed as a result of the above code example.

NOTE

Similarly you can perform clipboard operations for shapes (Chart and Image).