org.jxls.transform.jexcel.WritableHyperlinkCell Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jxls-jexcel Show documentation
Jexcel API Transformer implementation for Jxls library
The newest version!
package org.jxls.transform.jexcel;

import java.io.File;
import java.net.URL;

import org.jxls.common.Context;

import jxl.Cell;
import jxl.write.Label;
import jxl.write.WritableCell;
import jxl.write.WritableHyperlink;
import jxl.write.WritableSheet;
import jxl.write.WriteException;

/**
 * Writable cell value implementation for Hyperlink
 * 
 * @author Leonid Vysochyn
 * @deprecated use jxls-poi
 */
public class WritableHyperlinkCell implements WritableCellValue {
    public static final String LINK_URL = "URL";
    public static final String LINK_DOCUMENT = "DOCUMENT";
    public static final String LINK_FILE = "FILE";

    File file;
    URL url;
    String description;

    public WritableHyperlinkCell(URL url, String description) {
        this.url = url;
        this.description = description;
    }

    public WritableHyperlinkCell(File file, String description){
        this.file = file;
        this.description = description;
    }

    public WritableCell writeToCell(WritableSheet sheet, int col, int row, Context context) throws WriteException {
        WritableHyperlink hyperlink = null;
        if( url != null ){
            if( description != null ){
                hyperlink = new WritableHyperlink(col, row, col, row, url, description);
            }else{
                hyperlink = new WritableHyperlink(col, row, url);
            }
        }
        if( file != null ){
            if( description != null ){
                hyperlink = new WritableHyperlink(col, row, file, description);
            }else{
                hyperlink = new WritableHyperlink(col, row, file);
            }
        }
        sheet.addHyperlink(hyperlink);
        Cell cell = sheet.getCell(col, row);
        WritableCell writableCell = new Label(col, row, description != null ? description : url.toString());
        if( cell != null && cell.getCellFormat() != null ){
            writableCell.setCellFormat( cell.getCellFormat() );
        }
        sheet.addCell(writableCell);
        return writableCell;
    }

    public File getFile() {
        return file;
    }

    public void setFile(File file) {
        this.file = file;
    }

    public URL getUrl() {
        return url;
    }

    public void setUrl(URL url) {
        this.url = url;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }
}