Aspose.Cells for Java
Getting Started
Developer Guide
Introduction
Loading, Saving, Converting and Managing
Fonts
Rendering
HTML
Workbook
Workbook Settings
Document Properties
Worksheets
Rows and Columns
Data
Formulas
Tables
Charts
Drawing Objects
Cells Helper
Pivot Tables
Slicers
Smart Markers
Workbook VBA Project
XML Maps
Migrating from Earlier Versions of Aspose.Cells
Aspose.Cells.GridWeb
Technical Articles
Setting Strong Encryption Type
Add Image Hyperlinks
Sort Data
Utilize Aspose.Cells in other Programming Languages
Create Table by Using Border Lines for a Range
Use Error Checking Options
Aspose.Cells Formula Calculation Engine
Using LightCells API
Insert a Picture based on Cell Reference
Change Text Direction of the Comment
Reading Cell Values in Multiple Threads Simultaneously
Implementing IStreamProvider for HtmlSaveOptions.StreamProvider
Rendering and Printing
Styling and Data Formatting
Managing Pivot Tables and Pivot Charts
Managing Workbooks and Worksheets
Managing Rows, Columns and Cells
Managing Charts and Shapes
Managing Database Connections
Retrieving External Data Sources Details
Retrieving SQL Connection Data
Modify existing SQL Data Connection using Aspose.Cells
Calculating IFNA function using Aspose.Cells
Easy way for Chart Setup using Chart.setChartDataRange method
Convert Revision of XLSB to XLSM
Get Cell String Value with and without Formatting
Render Custom Date Format Pattern g and ge mm dd
Copy Row Heights of Source Range to Destination Range
Calculate Page Setup Scaling Factor
Returning a Range of Values using ICustomFunction
Returning a Range of Values using AbstractCalculationEngine
Calculate the Width and Height of the Cell Value in Unit of Pixels
Release Unmanaged Resources of the Workbook
Render Worksheet to Graphic Context
Get the Cell object by DisplayName of PivotField of PivotTable
Change Adjustment Values of the Shape
Copy Range Data Only
Copy Range Data with Style
Copy Range Style Only
Delete Blank Rows and Columns in a Worksheet
Move Range of Cells in a Worksheet
Adding Custom Labels to Data Points in the Series of the Chart
Using WorkbookMetadata
Assign Macro Code to Form Control
Disable Exporting Frame Scripts and Document Properties
Editing Hyperlinks of Worksheet
Working with External Data Connection of type WebQuery
Access and Update the Portions of Rich Text of Cell
Change the HTML Link Target Type
Getting Notifications while Merging Data with Smart Markers
Remove Unused Styles inside the Workbook
Using Built-in Styles
Managing Conditional Formats
Knowledge Base
API Reference
Plugins
Showcases
Release Notes
Home
Aspose.Cells Product Family
Aspose.Cells for Java
Developer Guide
Technical Articles
Managing Database Connections
Managing Database Connections
Contents
[
Hide
]
This section includes the following topics:
Retrieving External Data Sources Details
Retrieving SQL Connection Data
Modify existing SQL Data Connection using Aspose.Cells
Managing Charts and Shapes
Calculating IFNA function using Aspose.Cells