Excel Jetcell .NET

Spreadsheet programs primarily simulate the conventional paper mode based work consisting of tables. The worksheets of such programs usually contain rows and columns on a 2D matrix in which numeric, alphanumeric characters and formulae can be entered. Modern spreadsheet programs such as the latest versions of Excel also have improved supportability for 2D as well as 3D graphical representation of graphs and charts. Thus, the utility of spreadsheet programs in modern days is indispensable. The users who want direct integration of access to Excel sheet through their .NET applications without even ever launching Excel can use Excel Jetcell .NET v.2.3 as a standalone solution.

Excel Jetcell .NET v.2.3 is a component that allows reading and writing of Excel-sheet files in XLS, XLSX and CSV format from their website projects such as VB.NET and C# and .NET applications. It works with a set of Application Programming Interface functions allowing VB.NET and C# developers to access Excel sheets. The component supports access and editing to various cell objects and data types like strings, floating points, numbers, dates etc. and allows the user to work with multiple worksheets at the same time. The whole worksheet is presented in the form of a tree structure whose root is a Workbook object which has a number of worksheets. Almost all the frequently used functionalities that you can do with normal Excel program are available through your applications with the help of this component like text formatting including bold, italics, color size, superscript, subscript etc. Other functionalities include setting cell alignments and formatting cells like setting patterns and backgrounds.

To conclude with, Excel Jetcell .NET v.2.3 is a utility oriented application that makes it easy for developers to access and work on spreadsheets from their applications without any external dependencies, leading it to score four points on the scale of five.

Excel Jetcell .NET is a professional component that enables .NET developers to read, write Excel Spreadsheet files ( XLSX , XLS , CSV ) from their .NET applications or website projects (C#, VB.NET). The Excel spreadsheet is represented as a tree structure. Root of the tree is a Workbook object that has different Worksheets and so on.
Excel Jetcell .NET Key Features:
- Excel file types – XLSX, XLS, CSV.
- Various cell data types (numbers, strings, dates, floating point etc.)
- Multiple worksheets.
- Number formatting (number, currency, date, time, fraction etc.)
- Font formatting (size, color, font type, italic and strikeout properties, boldness, underlining, subscript and superscript).
- Cell alignment (vertical, horizontal).
- Cell Background and Fill Pattern.
- Cell borders (color, style).
- Merged cells.
- Import/Export to DataTable, DataSet.
- CSV files (delimited with comma, tab, semicolon or any other separator).
For more details see the examples (C# VB.NET) at website (devtriogroup.com) of the component.
Excel Jetcell .NET API Functions:
The set of API functions allows C# and VB.NET developers to read, write Excel data up to Excel Cell value and its styles, fonts, colors, borders etc. Also Excel Jetcell .NET has functions to get access to range of cells or whole Worksheet. The component can export data from Excel to DataTable, DataSet using corresponding function and much more - all this without the need to use Microsoft Excel or Microsoft Office Automation.
Standalone .NET Component
Excel Jetcell .NET component requires only .NET Framework and is available for C#, VB.NET developers. It is many times faster than Excel automation objects. The code of Excel Jetcell .NET component is fully managed and works under .NET Framework started from 1.1 version. Developers can create C# / VB.NET applications or deploy website on servers with medium-trust level without needing to rely on Microsoft Excel.