← Back to all blogs

Featured Posts

Posts tagged with 'spreadjs'

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.

GrapeCity Spread.Services 1.3.0 Officially Released!

Spread.Services is a new GrapeCity spreadsheet server component for .NET Core and developers across all .NET platforms, including:

Spread v10 SP2 Release

We've released Spread V10 SP2. This release adds several features and fixes many reported issues. The biggest new feature is for SpreadJS.Sheets: Support for Angular! Here is a list of the resolved issues:

Spread.Sheets and Angular

For those of you wanting to use Spread with Angular, we have some great news, you can now use Spread.Sheets in an Angular project.

Spread.Sheets Year Sparkline

Spread.Sheets is a spreadsheet widget that works in browser applications that support HTML5. Spread.Sheets has a new Year sparkline feature. A Year sparkline allows you to quickly spot trends in your data.

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 and JSFiddle

You can now test Spread.Sheets in JSFiddle with a special license key. Spread.Sheets can be used in browser applications that support HTML5. For more information about Spread.Sheets, refer to http://spread.grapecity.com/spreadjs/sheets/.

SpreadJS V10 SP1 Release

SpreadJS V10 SP1 has now been released. This release fixes many reported issues. Here is a list of the resolved issues:

Spread.Sheets and JS Bin

You can now test Spread.Sheets in JS Bin with a special license key. Spread.Sheets can be used in browser applications that support HTML5. For more information about Spread.Sheets, refer to http://spread.grapecity.com/spreadjs/sheets/.

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.Sheets and the Month Sparkline

A Month sparkline can be a useful way to show data trends, such as finding the day with the highest call volume in the month.

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.

Spread.Views and the Timeline Layout

A Timeline layout can make your data easier to follow. This can be particularly useful for milestones in a project or a meeting schedule.

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.

Spread.Views and the Trellis Layout

If you want to create a card style layout that can be used to collaborate with others or to keep track of a process, the Trellis view in Spread.Views may be just what you need.

SpreadJS Designer and Tables

The SpreadJS designer allows you to create tables quickly and without code.