Aspose.Cells for Java
What's new in Aspose.Cells for Java
Getting Started
Developer Guide
Introduction
Loading, Saving, Converting and Managing
Workbook
Workbook Conversions
Document Properties
Workbook Settings
Worksheets
Rows and Columns
Data
Formulas
Cells Formatting
Fonts
Conditional Formatting
Protection
Comments and Notes
Tables
Charts
Drawing Objects
Cells Helper
Sparklines
Pivot Tables
Timelines
Slicers
Smart Markers
Workbook VBA Project
XML Maps
Migrating from Earlier Versions of Aspose.Cells
Technical Articles
Utilize Aspose.Cells in other Programming Languages
Create Table by Using Border Lines for a Range
Use Error Checking Options
Using LightCells API
Rendering and Printing
Managing Workbooks and Worksheets
Managing Rows, Columns and Cells
Managing Charts and Shapes
Managing data
Managing Database Connections
Retrieving External Data Sources Details
Retrieving SQL Connection Data
Modify existing SQL Data Connection using Aspose.Cells
Cut Copy Paste
Convert Revision of XLSB to XLSM
Calculate the Width and Height of the Cell Value in Unit of Pixels
Release Unmanaged Resources of the Workbook
Move Range of Cells in a Worksheet
Using WorkbookMetadata
Working with External Data Connection of type WebQuery
Load or Import CSV file with Formulas
Reading and Writing Query Table of Worksheet
Using Custom XML Parts in Aspose.Cells
Load Workbook with specified Printer Paper Size
Check if Workbook contains hidden External Links
Propagate Formula in Table or List Object automatically while entering data in new rows
Change the Absolute Path of External Link Data Source File
Detect File Format of Encrypted Office Open XML - OOXML Files
Knowledge Base
Rendering
API Reference
UI Components
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
]
Retrieving External Data Sources Details
Retrieving SQL Connection Data
Modify existing SQL Data Connection using Aspose.Cells
Managing data
Cut Copy Paste