XlsxUtils (Jmix-all 2.4 API)

java.lang.Object

io.jmix.reports.yarg.formatters.impl.xlsx.XlsxUtils

public final class XlsxUtils extends Object

Method Summary

Modifier and Type

Method

Description

static org.docx4j.openpackaging.parts.DrawingML.Drawing

addCTDrawing(org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart worksheetPart, org.docx4j.openpackaging.parts.PartName drawingPart)

static org.docx4j.openpackaging.parts.relationships.RelationshipsPart

attachImageToCell(org.docx4j.openpackaging.parts.DrawingML.Drawing drawing, Integer col, Integer row, XlsxImage image, String imageRelID)

static Integer

computeColumnIndex(String cellName)

static long

convertPxToEmu(long px)

static org.docx4j.dml.spreadsheetdrawing.CTPicture

createPicture(String imageRelID)

static void

deleteCTAnchor(org.apache.poi.xssf.usermodel.XSSFPicture xssfPicture)

static String

getColumnReferenceFromNumber(int number)

static int

getNumberFromColumnReference(String columnReference)

static org.docx4j.openpackaging.parts.DrawingML.Drawing

getOrCreateWorksheetDrawing(org.docx4j.openpackaging.packages.SpreadsheetMLPackage pkg, org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart worksheetPart)

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details
- getNumberFromColumnReference
  
  public static int getNumberFromColumnReference(String columnReference)
- getColumnReferenceFromNumber
  
  public static String getColumnReferenceFromNumber(int number)
- convertPxToEmu
  
  public static long convertPxToEmu(long px)
- computeColumnIndex
  
  public static Integer computeColumnIndex(String cellName)
- createPicture
  
  public static org.docx4j.dml.spreadsheetdrawing.CTPicture createPicture(String imageRelID)
- attachImageToCell
  
  public static org.docx4j.openpackaging.parts.relationships.RelationshipsPart attachImageToCell(org.docx4j.openpackaging.parts.DrawingML.Drawing drawing, Integer col, Integer row, XlsxImage image, String imageRelID)
- getOrCreateWorksheetDrawing
  
  public static org.docx4j.openpackaging.parts.DrawingML.Drawing getOrCreateWorksheetDrawing(org.docx4j.openpackaging.packages.SpreadsheetMLPackage pkg, org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart worksheetPart)
- addCTDrawing
  
  public static org.docx4j.openpackaging.parts.DrawingML.Drawing addCTDrawing(org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart worksheetPart, org.docx4j.openpackaging.parts.PartName drawingPart) throws org.docx4j.openpackaging.exceptions.Docx4JException
  
  Throws:
  
  org.docx4j.openpackaging.exceptions.Docx4JException
- deleteCTAnchor
  
  public static void deleteCTAnchor(org.apache.poi.xssf.usermodel.XSSFPicture xssfPicture)