Spread.Sheets can easily load Excel workbooks and render them on webpages. In some cases, these workbooks may need to be combined, like monthly reports. As with my other blog about loading specific sheets, we can also utilize hidden workbooks to load all the workbooks first before combining them into one.
In addition to all the great new features we introduced in SpreadJS v11, such as charts and more functions support, we’ve also simplified the licensing. In this blog I'll go over runtime licenses, designer licenses, and how to properly use them in your application.
The Angular CLI (Command Line Interface) has become the most popular addition to the Angular developer’s toolbox, allowing automation of the many challenges that come with developing with Angular, making it easier to get started. Since Spread.Sheets can work with Angular, it's only natural that developers may want to use Spread.Sheets with the Angular CLI. This tutorial demonstrates how to automate the creation of a simple Angular application with Spread.Sheets.
When working with Excel workbooks in SpreadJS, sometimes only one sheet from a workbook is relevant to your application and what your users are focusing on. In this case, you can use a hidden workbook to load the entire Excel workbook, and then get one of the sheets out of that workbook for your users to interact with.
In Excel, the key combination of Ctrl and an arrow key allows the user to navigate to the end of a data region in a worksheet. While this functionality is not currently automatically provided in Spread.Sheets, it is very easy to add. In this tutorial you will learn how to overwrite default behavior for key combinations, as well as how to write custom commands.
SpreadJS provides different cell types that give the user useful functionality. Rich text formatting is something that isn’t supported out-of-the-box in SpreadJS, but a custom HTML Cell Type can be implemented that provides most of the functionality of general HTML tags inside of cells in SpreadJS.
Spread for ASP.NET is a useful web tool for providing Excel-like functionality to users on a webpage. It might be useful to give users the ability to paste ranges from their Excel Spreadsheets into Spread. While this feature is not currently in Spread for ASP.NET, code can be written to achieve the same functionality. Rather than using purely client-side code to implement the pasting of cells from Excel to Spread, this tutorial sends HTML strings back to the server for parsing to recreate the copied cell range in Spread.
The Spread WPF Designer provides useful properties and settings that developers can change to create specific sheets and templates for use in their application. This functionality could be useful to users as well, and the bulk of that functionality is contained within a Ribbon toolbar. This tutorial provides step-by-step instructions for adding an open-source Ribbon toolbar to a WPF application with Spread. The toolbar that is used in this tutorial is an open-source ribbon for WPF applications called “Fluent Ribbon”, and it can be found here: Fluent Ribbon GitHub