← Back to all blogs

Posts tagged with 'excel'

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.

Find and Display Reports

Now that we've set up the Administrator Dashboard, we can shift over to the Report Portal, where our users will access reports.

ASP.NET - What's New for C1Studio Web Forms and MVC Controls

We are pleased to announce that 2016 V1 adds new business controls and capabilities to various C1Studio ASP.NET  Editions. MVC Edition now has a new FlexSheet control that enables you to build spreadsheet  like apps for the web, and we're also launching FlexViewer as beta. FlexViewer lets users view .NET reports built with FlexReport on the web. Save time building MVC applications with scaffolding support for our MVC Edition controls,  FinancialChart gets powerful analytical tools. Web Forms Edition continues to add features to major controls based on feedback from the community.

Getting started with FlexSheet for MVC, a Web-based Spreadsheet Control

Provide users with a familiar, Excel-like web-based spreadsheet control with FlexSheet for ASP.NET MVC. FlexSheet for ASP.NET MVC offers a unique combination of server and client side features:

How to Generate Excel from XML and JSON Data Using C#

Generate Excel spreadsheets from JSON, XML, and datatables with C# and the ComponentOne Studio Web API Edition.

What's New in ASP.NET in 2015 V3

At GrapeCity, your suggestions are an integral part of the product design and roadmap. The 2015 V3 release is an example of how much your feedback is important to us , the majority of features in the ASP.NET stack is a result of valuable inputs from you.  We have added new controls and features to all flavours of ASP.NET. In Web Forms we have added annotations in charts, ASP.NET MVC Edition has a new FinancialChart control and lot of features added to existing controls, the official release of Web API Edition has new excel and barcode REST API's.

How to Load and Save Macro Enabled Excel Files With OpenXMLMacro in Excel for WinForms

Excel for WinForms now supports OpenXMLMacro file format, with which you can save and load Macros-enabled Excel files in C1Excel. You can load and save such files from and to *.xlsm file extension. The VBA Code can be loaded in Binary format into xlsm files. While saving the files, user can set all needed parameters to support Macro code.

Getting Started with C1Studio Web API

Let's walk through an example of creating a Web API that uses the ComponentOne Studio Web APIs and how to consume this Web API to export Excel sheets from FlexGrid in a client application.

Export Anything, Anywhere: Introducing the New Web API

Introducing Web API for MVC Edition, a technical preview that's sure to add a flexible import and export tool to your MVC arsenal.

Context Menu in ComponentOne GridView

C1GridView lets you display items from a data source in an interactive, fully customizable table. And a common scenario is to display a ContextMenu and provide some functionality such as exporting to various formats etc.

C1Excel - Load Overloads !

I know the title seems a bit simple, and sounds more like a forum post at the wrong place, but sometimes the easiest assumptions may not be the best for us, same as the easiest implementation can be tricky for your code. It may happen that for unseen reasons, the environment where your application runs, changes and not every time can this be under your control. You cannot control where anyone is going to run the application you built, you can only suggest.

Spread Studio for .NET 7 v3 Released!

I am very happy to announce the release of Spread Studio for .NET 7 v3! This is the first release of 2014 and features new operating systems support, including Microsoft Windows® 8.1 and Microsoft Windows® Server 2012 R2, for all products, including Spread for WinForms, Spread for ASP.NET, Spread WPF-Silverlight, and Spread WinRT. We've also added design-time support for these products in Visual Studio 2013 and, in this release, Spread for ASP.NET now features support for Internet Explorer 11. Get it today, right here: