package playground;

import java.io.FileInputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFHyperlink;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFHyperlink;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Poi {

	public static void main(String[] args) {

		try (FileInputStream isXLSX = new FileInputStream("1.xlsx");FileInputStream isXLS = new FileInputStream("1.xls")) {
			XSSFWorkbook workbookX = new XSSFWorkbook(isXLSX);
			XSSFCell cellX = workbookX.getSheetAt(0).getRow(0).getCell(0);

			XSSFHyperlink hyperlinkX = cellX.getHyperlink();
			System.out.println("Address: " + hyperlinkX.getAddress());
			System.out.println("Label: " + hyperlinkX.getLabel());
			workbookX.close();


			HSSFWorkbook workbook = new HSSFWorkbook(isXLS);
			HSSFCell cell = workbook.getSheetAt(0).getRow(0).getCell(0);
			HSSFHyperlink hyperlink = cell.getHyperlink();
			System.out.println("Address: " + hyperlink.getAddress());
			System.out.println("Label: " + hyperlink.getLabel());
			workbook.close();

		} catch (Exception e) {
			e.printStackTrace();
		}

	}

}