Excel Utility Library for Anar Framework

A flexible and easy to use java excel reading and writing. It is a wrapper around Apache POI that provides elegant and user friendly interface for creating Excel documents.

Usage Guide

		<dependency>
	               <groupId>af.gov.anar.lib.excel</groupId>
	                <artifactId>anar-lib-excel</artifactId>
                        <version>${project.version}</version>
		</dependency>

Supported Cells

• Text Cell
• Numeric Cell
• Empty Cell
• Formula Cell
• Date Cell
• Calendar Cell
• Flexible for adding more types of cells

Supported Template

• Cell Template
• Row Template
• Style Template

Supported Styles

• Vertical Alignment
• Horizontal Alignment
• Background Color
• Border Bottom
• Border Left
• Border Right
• Border Top
• Date Format
• Fill Pattern
• Font Style
• Foreground Color
• Hidden
• Indention
• Lock
• Rotation
• Wrap Text

Supported Props

• Row Height
• Row Height In Points
• Row Zero Height
• Sheet Auto Size Column
• Sheet Column Width
• Sheet Default Column Width
• Sheet Row Height
• Sheet Fit To Page
• Sheet Merge Region

Documentation

Refer to this repository Wiki section. https://github.com/Anar-Framework/anar-lib-excel/wiki