Export excel and Pdf with Kendo UI MVC c#

Export to Excel and Pdf

  • Export excel and pdf is now a days a basic needs of clients for saving reports or tables data.
  • Kendo UI has build features for exporting table data to excel and pdf with Excel() and Pdf() functions.
  • Functions are used as below.
 @(Html.Kendo().Grid(Model)
    .Name("timeGrid")
    .NoRecords()
    .Columns(columns =>
    {
        columns.Bound(p => p.Field1).Title("Field1");
        columns.Bound(p => p.Field2).Title("Field2");
        columns.Bound(p => p.Field3).Title("Field3");
    }).Groupable()
       .Sortable()
    .Excel(excel => excel
       .FileName("FileName.xlsx").AllPages(true)
       .Filterable(true)
       .ProxyURL(Url.Action("Excel_Export_Save", "Controller"))
    )
             .Pdf(pdf => pdf
                .AllPages()
                .FileName("FileName.pdf").ForceProxy(true)
                .ProxyURL(Url.Action("Pdf_Export_Save", "Controller"))
            )
    .ToolBar(tools => tools.Excel())
    .ToolBar(tools => tools.Pdf())
    .Filterable()
    .Pageable().DataSource(dataSource => dataSource
        .Ajax()
        .PageSize(10)
        .ServerOperation(false)
    )
                )
  • Place above code in your View page, in above code the use of Excel() and Pdf() function in Kendo MVC.
  • For Generating buttons for Excel and Pdf export Toolbar() function is used shown in code.
  • In above their sub-functions which are used like FileName(), ProxyURL(),etc. are used to customize Excel and Pdf.
  • FileName() : This function is used to give file name.
  • ProxyURL() : Sometimes client wants reports or file in different format or customize view in file at that time ProxyURL() function is used to create customize file. ProxyURL() generally takes two arguments like action name and controller name.
    Proxy URL
    ProxyURL Action in Controller
  • Filterable() : This function takes one argument i.e. true or false. If you passed true and then it will allows filtration in generated excel which you used in table.
  • AllPages() : AllPages() function indicates your generated Pdf or Excel file will contains pages of grid or not.It will takes argument as true or false.
Above how you can use Excel(),Pdf() and Toolbar() function for exporting grid data to Excel and Pdf file.

Click Here To Demo For Export to Excel with Kendo Grid 

Click Here To Demo For Export to PDF with Kendo Grid 

Hope this will help you. Keep coding... :)

Comments

Post a Comment

Popular posts from this blog

Display image from byte array in ASP.NET MVC

Image
There are many ways to display image from byte array in MVC as well as normal ASP.Net projects.In this post I'll explain couple of them. 1) Using BASE64 string of the image through ViewBag  The first way i s by sending a Base64 string as dataURL through ViewBag. As shown in b elow action method under consideration generates such a Base64 string of the image (often called Data URL) and then pass it to the view via a ViewBag property in MVC . public ActionResult Image() { string path = Server.MapPath("~/images/computer.png"); byte[] imageByteData = System.IO.File.ReadAllBytes(path); string imageBase64Data=Convert.ToBase64String(imageByteData); string imageDataURL= string.Format("data:image/png;base64,{0}", imageBase64Data); ViewBag.ImageData = imageDataURL; return View(); } The above code is a action method of Controller. In this action method it uses physical path of image and read all bytes of that image using ReadAllByte
Read more

Convert a color image to black and white image in C#

In this simple article you will learn that how we can convert colored image into black and white image in C#.net. This technique uses a ColorMatrix to perform the conversion. A ColorMatrix is a 5x5 matrix that can make just about any modifications to the color of an image. A ColorMatrix is pretty complicated and deserves a whole tutorial to itself. We're going to use GDI to draw the new black and white image. The benefit of this technique over the last one is that we don't need to know any information about the image's pixel format. The code here is pretty straight forward. First create the blank image and get a Graphics object from it. Next, create the ColorMatrix that will convert the original image to grayscale. Declare an ImageAttributes object that will use the ColorMatrix and use it to draw the new image using DrawImage . Below is code for your proble m      
Read more