← Back to all blogs
Profile photo of Kevin Ashley
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

Creating a JavaScript March Madness Bracket with Spread.Sheets

In this tutorial, we will go over how to create a JavaScript bracket for the March Madness Basketball Tournament, including a sheet for individuals to make predictions as to which team will win each matchup.

SpreadJS DevChannel 11.0.5 Hotfix Available

This DevChannel update includes bug fixes for SpreadJS.

SpreadJS DevChannel 11.0.4 Hotfix Available

This DevChannel update includes bug fixes for SpreadJS and Server-Side Excel I/O Component updates.

SpreadJS DevChannel 11.0.3 Hotfix Available

This DevChannel update includes bug fixes for Spread JS and Server-Side Excel I/O Component updates.

How to merge multiple Excel workbooks in JavaScript and SpreadJS

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.

How to License SpreadJS V11 in Your Application

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.

Create Angular Spreadsheet Apps with Angular CLI

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.

Slice and Dice Your Charts with SpreadJS Slicers

Slicers are a newly added feature to Spread.Sheets that gives users the ability to filter their table data in a new way. 

SpreadJS V11 Released

SpreadJS 11's set of JavaScript libraries has been enhanced to solve even more of your spreadsheet and data grid needs.

How to Import a Single Excel Sheet in JavaScript

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.

How to import XLSX from a URL with pure JS logic

The Client-Side ExcelIO component is pure JavaScript logic for importing and exporting Excel files, and is built right into SpreadJS. This is useful when you need to make your application platform-independent. Unlike the Server-Side ExcelIO component, the client-side component doesn’t require Windows Server. You can use this to import files from the user’s system, and to import Excel files hosted on the server using their URLs.

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