← Back to all blogs

Featured Posts

Posts tagged with 'spreadsheets'

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.

.NET Core 2.0 and Spread.Services make Excel files better

Spread.Services already provides super-fast Excel-compatible spreadsheet creation. Support for .NET Core 2.0 jumps it into overdrive.

How to generate Excel spreadsheets in code with Spread.Services

Jumping right into developing with a new API can be daunting. Well, at least if you're me it can. Let's walk through the basics together and get rid of any points of pain. We're going to make a gorgeous XLSX file in code with NO Microsoft Excel dependency! Woot!

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/.

Spread Studio V10 SP1 Release

Spread Studio V10 SP1 has now been released. This release adds support for Microsoft Visual Studio 2017 and fixes many reported issues. Here is a list of the resolved issues:

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 Windows Forms and the Waterfall Chart

A Waterfall chart is a popular visualization tool that you can now use in Spread for Windows Forms, a Visual Studio .NET control. Spread for Windows Forms also supports many other chart types. You can see a list of the many product features on our web site at http://spread.grapecity.com/spread-studio/.

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 for Windows Forms and the GcComboBox Cell

A combo box can be useful when creating a form for users such as an on-line order form.

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.

Spread Windows Forms and the Sunburst Chart

Sunburst charts are effective for showing hierarchical data visually. For example, you can use a Sunburst chart to find out what store and product have the most sales.

Spread Windows Forms and the Funnel Chart

Funnel charts can be a useful tool in your application. For example, since Funnel charts show values across multiple stages, they can be used to find out how many sales leads convert to purchases.