1.07 anywheresoftware.b4j.objects.PoiWorkbookWrapper PoiWorkbook org.apache.poi.ss.usermodel.Workbook process Ready (Success As Boolean) IsInitialized boolean GetSheetByName Returns the sheet with the given name. anywheresoftware.b4j.objects.PoiSheetWrapper SheetName java.lang.String AddImage Adds an image to the workbook. Returns the image index. Use PoiSheet.SetImage to put this image on a sheet. Supported formats: png and jpeg (file extension must be correct). int Dir java.lang.String FileName java.lang.String InitializeNew Creates a new workbook. XLSXFormat - True to use the new Excel 2007 format (xlsx). void XLSXFormat boolean GetSheet Returns the sheet at the specified index (first sheet index is 0). anywheresoftware.b4j.objects.PoiSheetWrapper Index int Close Closes the Workbook. void Save Saves the workbook to the given file. void Dir java.lang.String FileName java.lang.String InitializeExisting Initializes the workbook and reads the data from the specified file. Password - The workbook password. Pass an empty string if there is no password. void Dir java.lang.String FileName java.lang.String Password java.lang.String ReadOnly boolean AddSheet Adds a new sheet at the specified index. anywheresoftware.b4j.objects.PoiSheetWrapper Name java.lang.String Index int GetSheetNames Returns an array with the sheets names. java.lang.String[] InitializeExistingAsync Similar to InitializeExisting. This method is non-blocking. The Ready event will be fired when the workbook is ready. void ba anywheresoftware.b4a.BA EventName java.lang.String Dir java.lang.String FileName java.lang.String Password java.lang.String ReadOnly boolean Fonts anywheresoftware.b4a.objects.collections.List Returns a List with the workbook fonts. NumberOfSheets int Returns the number of sheets. PICTURE_TYPE_JPEG short PICTURE_TYPE_PNG short anywheresoftware.b4j.objects.PoiSheetWrapper PoiSheet org.apache.poi.ss.usermodel.Sheet process AddMergedRegion Merges the cells. void FirstColumn int FirstRow int LastColumn int LastRow int CreateRow Creates a new row with the specified index. First row index is 0. anywheresoftware.b4j.objects.PoiRowWrapper RowNumber int SetColumnWidth Sets the column width measured in 1 / 256 of a character width. void ColumnIndex int Width int GetRow Returns the row with the specified index. Returns an uninitialized PoiRow if the row is empty. anywheresoftware.b4j.objects.PoiRowWrapper RowNumber int IsInitialized boolean SetImage Puts an image, previously added with PoiWorkbook.AddImage, on the sheet. ImageIndex - The value returned from PoiWorkbook.AddImage. FirstRow, FirstColumn, LastRow, LastColumn - The image cells. void ImageIndex int FirstColumn int FirstRow int LastColumn int LastRow int GetColumnWidth Gets the column width measured in 1 / 256 of a character width. int ColumnIndex int FirstRowNumber int Gets the index of the first row on the sheet. RightToLeft boolean b boolean Gets or sets whether the sheet is in right to left mode. LastRowNumber int Gets the index of the last row on the sheet. Index int Returns the sheet index. Rows anywheresoftware.b4a.objects.collections.List Returns a List with PoiRow items representing the sheet rows. Note that empty rows will be excluded from the list. Name java.lang.String s java.lang.String Gets or sets the sheet name. anywheresoftware.b4j.objects.PoiRowWrapper PoiRow org.apache.poi.ss.usermodel.Row process CreateCellNumeric Creates a numeric cell at the given index. anywheresoftware.b4j.objects.PoiCellWrapper CellIndex int Value double CreateCellFormula Creates a formula cell at the given index. anywheresoftware.b4j.objects.PoiCellWrapper CellIndex int Value java.lang.String IsInitialized boolean GetCell Returns the cell at the given index. The object will not uninitialized if there is no defined cell. anywheresoftware.b4j.objects.PoiCellWrapper Column int CreateCellBoolean Creates a boolean cell at the given index. anywheresoftware.b4j.objects.PoiCellWrapper CellIndex int Value boolean CreateCellString Creates a string cell at the given index. anywheresoftware.b4j.objects.PoiCellWrapper CellIndex int Value java.lang.String CreateCellBlank Creates a blank cell. anywheresoftware.b4j.objects.PoiCellWrapper CellIndex int RowNumber int r int Gets or sets the row number. Height float f float Gets or sets the row height. RowStyle anywheresoftware.b4j.objects.PoiCellStyleWrapper s anywheresoftware.b4j.objects.PoiCellStyleWrapper Gets or sets the row style. The object returned will be uninitialized if the style was not set before. Cells anywheresoftware.b4a.objects.collections.List Returns a List with PoiCell items representing the row defined cells. anywheresoftware.b4j.objects.PoiFontWrapper PoiFont org.apache.poi.ss.usermodel.Font process IsInitialized boolean SetColor void Color int Initialize void Workbook anywheresoftware.b4j.objects.PoiWorkbookWrapper Italic boolean b boolean Size short s short Gets or sets the font size. Underline boolean b boolean Bold boolean b boolean IndexedColor short Color short Gets or sets an indexed color. Index int Returns the font index in the workbook fonts table. Name java.lang.String s java.lang.String Gets or sets the font name. anywheresoftware.b4j.objects.PoiCellWrapper PoiCell org.apache.poi.ss.usermodel.Cell process IsInitialized boolean ColumnIndex int Gets the cell column index. ValueFormula java.lang.String b java.lang.String Gets or sets the value of a formula cell. CellType java.lang.Object t java.lang.Object Gets or sets the cell's type. The value will be one of the TYPE constants. ValueBoolean boolean b boolean Gets or sets the value of a boolean cell. ValueNumeric double d double Gets or sets the value of a numeric cell. Value java.lang.Object Returns the cell value based on the cell type. ValueDate long l long Gets or sets the value of a date cell. CellStyle anywheresoftware.b4j.objects.PoiCellStyleWrapper s anywheresoftware.b4j.objects.PoiCellStyleWrapper Gets or sets the cell style object. PoiCellStyle objects can be shared by multiple cells (if the style is the same). ValueCached java.lang.Object Same as Value for cells other than formula cells. Returns the cached value for formula cells. ValueString java.lang.String s java.lang.String Gets or sets the value of a string cell. TYPE_NUMERIC java.lang.Object TYPE_STRING java.lang.Object TYPE_BOOLEAN java.lang.Object TYPE_ERROR java.lang.Object TYPE_FORMULA java.lang.Object TYPE_BLANK java.lang.Object anywheresoftware.b4j.objects.PoiCellStyleWrapper PoiCellStyle org.apache.poi.ss.usermodel.CellStyle process InitializeCopy Creates a new CellStyle which is a copy of the given CellStyle. This is useful if you want to create another style similar to an existing style. void Workbook anywheresoftware.b4j.objects.PoiWorkbookWrapper ExistingStyle anywheresoftware.b4j.objects.PoiCellStyleWrapper IsInitialized boolean Initialize Creates a new CellStyle. Note that you should avoid creating unnecessary PoiCellStyles objects. void Workbook anywheresoftware.b4j.objects.PoiWorkbookWrapper SetDataFormat Sets the data format string. void Workbook anywheresoftware.b4j.objects.PoiWorkbookWrapper Format java.lang.String SetFont void Font anywheresoftware.b4j.objects.PoiFontWrapper BorderBottom org.apache.poi.ss.usermodel.BorderStyle s org.apache.poi.ss.usermodel.BorderStyle Gets or sets the border style. One of the BORDER constants. WrapText boolean b boolean Gets or sets whether the text should be wrapped. BorderLeft org.apache.poi.ss.usermodel.BorderStyle s org.apache.poi.ss.usermodel.BorderStyle Gets or sets the border style. One of the BORDER constants. VerticalAlignment org.apache.poi.ss.usermodel.VerticalAlignment s org.apache.poi.ss.usermodel.VerticalAlignment Gets or sets the vertical alignment. One of the VERTICAL constants. ShrinkToFit boolean b boolean Gets or sets whether the cells will be auto sized to fit. ForegroundColor Color int Sets the cell's color. This method is only supported when working with xlsx workbooks (nothing will happen with xls format). Rotation short s short Gets or sets the degree of rotation (between -90 to 90). HorizontalAlignment org.apache.poi.ss.usermodel.HorizontalAlignment s org.apache.poi.ss.usermodel.HorizontalAlignment Gets or sets the horizontal alignment. One of the HORIZONTAL constants. BorderTop org.apache.poi.ss.usermodel.BorderStyle s org.apache.poi.ss.usermodel.BorderStyle Gets or sets the border style. One of the BORDER constants. BorderRight org.apache.poi.ss.usermodel.BorderStyle s org.apache.poi.ss.usermodel.BorderStyle Gets or sets the border style. One of the BORDER constants. VERTICAL_CENTER org.apache.poi.ss.usermodel.VerticalAlignment BORDER_SLANTED_DASH_DOT org.apache.poi.ss.usermodel.BorderStyle HORIZONTAL_RIGHT org.apache.poi.ss.usermodel.HorizontalAlignment BORDER_HAIR org.apache.poi.ss.usermodel.BorderStyle VERTICAL_TOP org.apache.poi.ss.usermodel.VerticalAlignment BORDER_DASHED org.apache.poi.ss.usermodel.BorderStyle BORDER_MEDIUM_DASH_DOT org.apache.poi.ss.usermodel.BorderStyle HORIZONTAL_FILL org.apache.poi.ss.usermodel.HorizontalAlignment BORDER_DASH_DOT org.apache.poi.ss.usermodel.BorderStyle BORDER_THICK org.apache.poi.ss.usermodel.BorderStyle BORDER_DOUBLE org.apache.poi.ss.usermodel.BorderStyle VERTICAL_BOTTOM org.apache.poi.ss.usermodel.VerticalAlignment VERTICAL_JUSTIFY org.apache.poi.ss.usermodel.VerticalAlignment BORDER_DASH_DOT_DOT org.apache.poi.ss.usermodel.BorderStyle BORDER_MEDIUM_DASH_DOT_DOT org.apache.poi.ss.usermodel.BorderStyle BORDER_DOTTED org.apache.poi.ss.usermodel.BorderStyle BORDER_THIN org.apache.poi.ss.usermodel.BorderStyle HORIZONTAL_GENERAL The default alignment. org.apache.poi.ss.usermodel.HorizontalAlignment BORDER_MEDIUM org.apache.poi.ss.usermodel.BorderStyle BORDER_MEDIUM_DASHED org.apache.poi.ss.usermodel.BorderStyle HORIZONTAL_CENTER org.apache.poi.ss.usermodel.HorizontalAlignment HORIZONTAL_LEFT org.apache.poi.ss.usermodel.HorizontalAlignment HORIZONTAL_JUSTIFY org.apache.poi.ss.usermodel.HorizontalAlignment BORDER_NONE org.apache.poi.ss.usermodel.BorderStyle 5.01 poi-5.0.0 poi-ooxml-5.0.0 xmlbeans-4.0.0 commons-collections4-4.4 commons-compress-1.20 commons-math3-3.6.1 commons-codec-1.15 SparseBitSet-1.2