← Back to all blogs

Posts tagged with 'excel'

Add Context Menu for SpreadJS

Do you want to add a context menu in SpreadJS? It is very simple. No mouse down event, no left or right mouse button checking, just popup the menu in contextmenu event of the SpreadJS place-holder element.

Getting results with WPF Excel

WPF Excel enables flexibility when working with data and spreadsheets - a must for organizations with end users that are accustomed to using the Microsoft application.

Load and Display Excel Files in your Windows Phone App

Control libraries are extremely useful when you need to work with special file formats, like PDF and Excel, because learning how to read and write to these raw formats is very time consuming. ComponentOne has plenty of libraries and tools for these popular file formats including our Excel library for the Windows Phone. In this blog post I show how you can load Excel (XLSX) and CSV files using the C1Excel library, and then I show how you can display the contents of the file in a C1FlexGrid and C1Chart control.

Excel Like formula with Spread for Silverlight

Spread for Silverlight has introduced an exciting new feature. Spread now provides a Formula TextBox which gets enabled when you enter a formula in a cell at run time. It now allows entering formulas in cells just like you do it in Microsoft Excel. Something like the image below:

Export Silverlight C1Chart Data to Excel

Mostly, when we talk about exporting chart to an Excel sheet, we expect Chart to be exported to Excel sheet as an Image. In case you are looking to export C1Chart for Silverlight as an Image, you can refer to this documentation link.

Spreadsheet Viewer App

A new version of the ComponentOne Spreadsheet Viewer app has arrived! This app was originally named ComponentOne Excel Viewer, and we’ve changed the name to ComponentOne Spreadsheet Viewer.

Announcing Spread WPF-Silverlight 7 v2!

ComponentOne is proud to announce the release of the new Spread WPF-Silverlight 7 v2. There are major upgrades to this version compared to the last release one year ago. There are many new features in this release including: the introduction of Excel 2013 like UI appearance and gesture touch support, Improvements for Excel file import/export and formula calculation performance, 10 categories 40+ chart types totally compatible with Excel, the ability to embed pictures into documents, a formula textbox control, and more...

Announcing Spread WinRT 7 v2!

ComponentOne is proud to announce the release of the new Spread WinRT 7 v2. There are major upgrades to this version compared to the last release 9 months ago. There are many new features in this release including: the introduction of Excel 2013 like UI and gesture touch support, Improvements for Excel file import/export and formula calculation performance, 10 categories 30+ chart types totally compatible with Excel, the ability to embed pictures into documents, a formula textbox control, and more...

Copy Data from Excel to ComponentOne Grids for Wpf

Provision to copy data from MS-Excel to any grid component is quite a common requirement. Here, we discuss the same implementation using C1DataGrid and C1FlexGrid for WPF.

How To Validate Data Entry in SpreadJS

Here are some common scenarios that may sound familiar to you:

First Look: The ComponentOne WorkSpace App

Check out our latest app in the Windows Store, ComponentOne WorkSpace. Create, open, edit, and save text documents and spreadsheets on your Windows 8 devices. The following file types are supported: XLS, XLSX, HTML, HTM, CSV, RTF, TXT, PDF. Open multiple files at one time and quickly access recent documents from the home page.

Import Images from Excel into Spread

Spread has several CellTypes that allow you to enter variety of data into the Spread cells including text, numbers, checkboxes, comboboxes and even images. Please refer to the following link that describes the same:

New Release of ComponentOne Excel Viewer

The ComponentOne Excel Viewer 5.0 release has arrived! We’ve created a new appearance and added some valuable features. Both will help you to view your Excel files easily and smoothly.

ComponentOne Excel Viewer for Windows 8 and WinRT

To all my fellow Excel users who have dreamed of a new productivity app, it is now a reality. At the end of last week we released ComponentOne Excel Viewer to the Windows Store, you can download it now. It is a free app to help you to view Excel files on your Windows 8 and WinRT devices. Besides being able to view Excel files, you can also operate it by selecting a range of cells, scrolling and even some editing.  Since the changes will not be saved back to the Excel file, we also built in some other functions via the AppBar, like copy/paste, undo/redo and filter/sort to help you view the document. The Excel Viewer app provides friendly touch support so you may easily operate and manipulate items by using your finger or stylus on touch-enabled devices.

Export Translated Text for DataGridTemplateColumn

This article on C1DataGrid for Silverlight is a utility blog to cater to the requirement of the developers who would like to show Translated text for cell values in DataGridTemplateColumn and along with that, export these translated Text to an excel sheet.

SpreadJS Alpha has landed

The Alpha release of SpreadJS is coming!