← Back to all blogs
About the Author

Kevin Ashley

One of GrapeCity's technical engagement engineers, Kevin Ashley enjoys trying to solve complex coding problems. After graduating from North Carolina State University with a bachelor's degree in Computer Science, he began his career in the software industry at GrapeCity. In his spare time, you can find Kevin playing guitar, drawing, or developing video games.

Recent Posts

How to Import/Export Excel files using JavaScript and Spread.Sheets

JavaScript is a versatile platform that allows easy customization of client-side scripting tools. In some applications, it is useful to have some sort of spreadsheet interface that is easy to code and maintain. The Spread.Sheets client-side JavaScript spreadsheet component, part of the SpreadJS package, is perfect for this. You can import and export Excel files, and provide users with an interface to interact with those files, all in pure JavaScript. In this tutorial, I will show you how easy it is to add a Spread.Sheets component to an HTML page and import an Excel file into it.

Spread.Sheets Excel Navigation

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.

Spread Studio V10 Fixed Bugs

In this article, you will find all of the .NET bugs that were fixed in the first release of Spread Studio V10.

Getting Started with SpreadJS V10

SpreadJS Version 10 now includes two JavaScript components: Spread.Sheets and Spread.Views. Spread.Sheets is a more traditional spreadsheet component, while Spread.Views is a highly customizable data view component. This tutorial shows how to get started with both components.

SpreadJS V10 Fixed Bugs

In this article, you will find all of the SpreadJS bugs that were fixed in first release of SpreadJS V10.

SpreadJS Rich Text

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.

SpreadJS and TypeScript

For some developers, working with TypeScript provides better tools and options than just JavaScript by itself. SpreadJS script code can be written in TypeScript to provide that enhanced functionality in conjunction with the power of SpreadJS. In this blog, you will learn how to use TypeScript in place of JavaScript code to implement SpreadJS functionality.

Excel to Spread Copy/Paste V9

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.

Adding a Ribbon to Spread WPF

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

Spread ASP CRUD Row Edit Template

While Spread for ASP.NET can be combined with CRUD operations, it might be useful to provide a better way for the user to enter data. In this blog, I will show how to combine a Row Edit Template with CRUD operations. This can be useful for cases where there are a lot of columns, and it would be tedious for the user to scroll through them all to edit the value that they want.

Spread ASP CRUD SpreadDataBinding

Using CRUD operations with Spread for ASP.NET provides useful database functionality along with an intuitive interface. Spread for ASP.NET has built-in functionality for connecting to a SQL Data Source that can be accomplished in the Design view of Visual Studio.

Spread ASP CRUD ADO.NET Binding

Using CRUD operations with Spread for ASP.NET provides useful database functionality along with an intuitive interface. You can use ADO.NET code and a SQL Server with Spread for ASP.NET with just a little bit of coding to connect everything.

SpreadJS Camera Shapes

Camera Shapes in Spread for WinForms allow the developer to take snapshots of content in a range of cells for use in other areas of the sheet, or different sheets entirely. This can help with organizing and presenting data in one cohesive view without having to worry about constraints on that view. In particular, camera shapes help make creating dashboards and complex reports simple and easy. In this blog post, I will show you how to create a custom CameraShape class for use in SpreadJS.

Using the Spread.Sheets Custom Slicer to Create a Filter Panel

Slicers provide an easy and efficient way for users to filter table data quickly. SpreadJS slicers allow the developer to customize the types of filters they want to provide to the users and these slicers can be used with different types of UI and JavaScript libraries. A very common use of slicers are the filter panels you see on common product websites such as Amazon.com. When you narrow your list down by price and brand, for example, you are using a slicer.

SpreadJS V9 Service Pack 1 Fixed Bugs

In this article, you will find all of the SpreadJS bugs that were fixed in the first Service Pack release of Spread V9.

Spread Studio V9 Service Pack 1 Fixed Bugs

In this article, you will find all of the .NET bugs that were fixed in the first Service Pack release of Spread V9.

SpreadJS and Angular Data Binding

AngularJS is a JavaScript library that is used for creating dynamic displays in web-applications. SpreadJS can work with Angular to make binding to data easier to understand by extending HTML. This blog is a part of the SpreadJS Data Binding series, which centers on binding the same data to SpreadJS using different JavaScript libraries.

SpreadJS and Knockout Data Binding

Knockout is a JavaScript library that helps you create responsive displays, as well as user interfaces that have an underlying data model. SpreadJS can work with Knockout to make binding to data easier to understand. This blog is a part of the SpreadJS Data Binding series, which centers on binding the same data to SpreadJS using different JavaScript libraries.

SpreadJS Data Binding

Data binding is a useful feature that enables the user to work with data without needing complex code. In SpreadJS, the workbook can be bound to data and then displayed on a web page to give the user access to that data.

Spread Windows Forms Ribbon Control

The Spread for Windows Forms spreadsheet control can be combined with other components, such as a Ribbon control in order to provide design functionality and other control to the user. In this example, you will learn how to add a Ribbon control to a project and connect it to a Spread component in a Windows Forms application.