Enjoy the New Enhancements in the Spreadsheet for ASP.NET AJAX

栏目: IT技术 · 发布时间: 4年前

内容简介:Check out all the latest enhancements in the Spreadsheet for Telerik UI for ASP.NET AJAX.TheR1 2020 SP1 releaseofLet me reveal the features one by one plus the benefits for you in more detail:

Check out all the latest enhancements in the Spreadsheet for Telerik UI for ASP.NET AJAX.

TheR1 2020 SP1 releaseof Telerik UI for ASP.NET AJAX was not only about the PdfViewer control – definitely thestar of the release– but also about the Spreadsheet, which brought to you four highly anticipated features:

  • Built-in Import from an Excel File
  • Ability to add images
  • Out-of-the-box Export to PDF and Excel
  • Cell comments

Let me reveal the features one by one plus the benefits for you in more detail:

Import from Excel

This important functionality is now built-in and available at the client-side:

Enjoy the New Enhancements in the Spreadsheet for ASP.NET AJAX

You can make use of it through the fromFile() passing the actual Excel file to the function. For example, the RadAsyncUpload control can be used for selection of a file. In its OnClientFileSelected client-side event, you can get a reference to the selected file and supply the RadSpreadsheet with it:

<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1"></telerik:RadSpreadsheet>

<telerik:RadAsyncUpload ID="RadAsyncUpload1" runat="server" OnClientFileSelected="OnClientFileSelected"></telerik:RadAsyncUpload>

<script>

function OnClientFileSelected(sender, args) {

var file = args.get_fileInputField().files[0]; // get the selected file from the RadAsyncUpload

var spreadsheet = $find("<%= RadSpreadsheet1.ClientID %>");

spreadsheet.fromFile(file); //supply the RadSpreadsheet control with the Excel file.

$(args.get_row()).remove(); //remove the row, visualizing the selection in the RadAsyncUpload

}

</script>

Add Images

Right now, you can not only insert images in the sheet via the Insert Image dialog, but also drag and drop them on it for repositioning.

Enjoy the New Enhancements in the Spreadsheet for ASP.NET AJAX

To add the Insert Image button to the toolbar, register the InsertImage tool:

        <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1">

<Toolbar>

<telerik:SpreadsheetToolbarTab Text="Home">

<telerik:SpreadsheetToolbarGroup>

<telerik:SpreadsheetTool Name="InsertImage" ShowLabel="true" />

</telerik:SpreadsheetToolbarGroup>

</telerik:SpreadsheetToolbarTab>

</Toolbar>

</telerik:RadSpreadsheet>

Tip

If you want, you can delete the image by selecting it and pressing the Delete key.

Export to PDF and Excel

The brand-new ExportAs dialog allows you to export the spreadsheet content to two popular formats: PDF and XLSX.

Enjoy the New Enhancements in the Spreadsheet for ASP.NET AJAX

All you have to do to enable it is to register the ExportAs tool to the toolbar, e.g.

        <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1">

<Toolbar>

<telerik:SpreadsheetToolbarTab Text="Home">

<telerik:SpreadsheetToolbarGroup>

<telerik:SpreadsheetTool Name="ExportAs" ShowLabel="true" />

                    </telerik:SpreadsheetToolbarGroup>

                    …

The export to PDF and to Excel can be also triggered programmatically via the API of the underlying Kendo Spreadsheet widget:saveAsPDF andsaveAsExcel.

You can play with the new feature atExport to PDF andExport to Excel File demos.

Cell Comments

The comments feature allows you to insert, edit and remove comments via the provided Insert Comment dialog:

Enjoy the New Enhancements in the Spreadsheet for ASP.NET AJAX

To enable the Insert Comment button add the following entry to the RadSpreadsheet declaration:

        <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1">

<Toolbar>

<telerik:SpreadsheetToolbarTab Text="Home">

<telerik:SpreadsheetToolbarGroup>

<telerik:SpreadsheetTool Name="InsertComment" ShowLabel="true" />

</telerik:SpreadsheetToolbarGroup>

</telerik:SpreadsheetToolbarTab>

</Toolbar>

</telerik:RadSpreadsheet>

Tips

  • You can also add or remove comments via the API of the underlying Kendo widget -range.comment(). Go and test this feature at theCell Comments demo.
  • The workbook with Cell Comments can also be imported and exported using the built-in import/export tools.

What’s Next?

  • PdfViewer - If you have missed by any chance this super trendy component in the R1 2020 SP1 release, you can take a glance at the Show PDF Files within Your ASP.NET Web Form Page in No Time blog as well as play with thelive demos.
  • Timeline – Upcoming in May, another big addition to the R2 release will be the brand-new Timeline component. You will be able to visualize series of events or chronological facts in a stylish and interactive way. It will be a server wrapper of the Kendo UI timeline widget, so if you are curious to learn more about it visitthis link.

We Value Your Feedback!

You know how important the feedback for the development and enhancement of any product on the market is. As a company driven to serve developers around the world, we strive to satisfy your expectations and needs to speed up your development with supreme UI components, so you are always warmly welcomed to share your thoughts and feedback.

We do appreciate it, so do not hesitate to drop your comments below or in ourfeedback portal, and tell us how you feel about the new components or our plans, and don't forget to contribute with ideas on the AJAX future roadmap and backlog.

Be sure to grab the latest bits from your account or download a free trial today to get started.

Start Your Trial


以上就是本文的全部内容,希望本文的内容对大家的学习或者工作能带来一定的帮助,也希望大家多多支持 码农网

查看所有标签

猜你喜欢:

本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们

算法设计与分析

算法设计与分析

郑宗汉//郑晓明 / 清华大学 / 2011-7 / 45.00元

《算法设计与分析(第2版)》系统地介绍算法设计与分析的概念和方法,共4部分内容。第1部分介绍算法设计与分析的基本概念,结合穷举法、排序问题及其他一些算法,对算法的时间复杂性的概念及复杂性的分析方法作了较为详细的叙述;第2部分以算法设计技术为纲,从合并排序、堆排序、离散集合的union和find操作开始,进而介绍递归技术、分治法、贪婪法、动态规划、回溯法、分支与限界法和随机算法等算法设计技术及其复杂......一起来看看 《算法设计与分析》 这本书的介绍吧!

CSS 压缩/解压工具
CSS 压缩/解压工具

在线压缩/解压 CSS 代码

Base64 编码/解码
Base64 编码/解码

Base64 编码/解码

RGB HSV 转换
RGB HSV 转换

RGB HSV 互转工具