com.alibaba.excel.metadata.csv
类 CsvWorkbook
- java.lang.Object
-
- com.alibaba.excel.metadata.csv.CsvWorkbook
-
- 所有已实现的接口:
- Closeable, AutoCloseable, Iterable<org.apache.poi.ss.usermodel.Sheet>, org.apache.poi.ss.usermodel.Workbook
public class CsvWorkbook extends Object implements org.apache.poi.ss.usermodel.Workbook
csv workbook- 作者:
- Jiaju Zhuang
-
构造器概要
构造器 构造器和说明 CsvWorkbook(Appendable out, Locale locale, Boolean use1904windowing, Boolean useScientificFormat)
方法概要
所有方法 实例方法 具体方法 限定符和类型 方法和说明 int
addOlePackage(byte[] oleData, String label, String fileName, String command)
int
addPicture(byte[] pictureData, int format)
void
addToolPack(org.apache.poi.ss.formula.udf.UDFFinder toopack)
org.apache.poi.ss.usermodel.Sheet
cloneSheet(int sheetNum)
void
close()
org.apache.poi.ss.usermodel.CellStyle
createCellStyle()
org.apache.poi.ss.usermodel.DataFormat
createDataFormat()
org.apache.poi.ss.usermodel.Font
createFont()
org.apache.poi.ss.usermodel.Name
createName()
org.apache.poi.ss.usermodel.Sheet
createSheet()
org.apache.poi.ss.usermodel.Sheet
createSheet(String sheetname)
org.apache.poi.ss.usermodel.Font
findFont(boolean bold, short color, short fontHeight, String name, boolean italic, boolean strikeout, short typeOffset, byte underline)
int
getActiveSheetIndex()
List<? extends org.apache.poi.ss.usermodel.Name>
getAllNames()
List<? extends org.apache.poi.ss.usermodel.PictureData>
getAllPictures()
org.apache.poi.ss.usermodel.CellStyle
getCellStyleAt(int idx)
org.apache.poi.ss.usermodel.CreationHelper
getCreationHelper()
int
getFirstVisibleTab()
org.apache.poi.ss.usermodel.Font
getFontAt(int idx)
org.apache.poi.ss.usermodel.Font
getFontAt(short idx)
boolean
getForceFormulaRecalculation()
org.apache.poi.ss.usermodel.Row.MissingCellPolicy
getMissingCellPolicy()
org.apache.poi.ss.usermodel.Name
getName(String name)
org.apache.poi.ss.usermodel.Name
getNameAt(int nameIndex)
int
getNameIndex(String name)
List<? extends org.apache.poi.ss.usermodel.Name>
getNames(String name)
short
getNumberOfFonts()
int
getNumberOfFontsAsInt()
int
getNumberOfNames()
int
getNumberOfSheets()
int
getNumCellStyles()
String
getPrintArea(int sheetIndex)
org.apache.poi.ss.usermodel.Sheet
getSheet(String name)
org.apache.poi.ss.usermodel.Sheet
getSheetAt(int index)
int
getSheetIndex(org.apache.poi.ss.usermodel.Sheet sheet)
int
getSheetIndex(String name)
String
getSheetName(int sheet)
org.apache.poi.ss.usermodel.SheetVisibility
getSheetVisibility(int sheetIx)
org.apache.poi.ss.SpreadsheetVersion
getSpreadsheetVersion()
boolean
isHidden()
boolean
isSheetHidden(int sheetIx)
boolean
isSheetVeryHidden(int sheetIx)
Iterator<org.apache.poi.ss.usermodel.Sheet>
iterator()
int
linkExternalWorkbook(String name, org.apache.poi.ss.usermodel.Workbook workbook)
void
removeName(int index)
void
removeName(org.apache.poi.ss.usermodel.Name name)
void
removeName(String name)
void
removePrintArea(int sheetIndex)
void
removeSheetAt(int index)
void
setActiveSheet(int sheetIndex)
void
setFirstVisibleTab(int sheetIndex)
void
setForceFormulaRecalculation(boolean value)
void
setHidden(boolean hiddenFlag)
void
setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy missingCellPolicy)
void
setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow)
void
setPrintArea(int sheetIndex, String reference)
void
setSelectedTab(int index)
void
setSheetHidden(int sheetIx, boolean hidden)
void
setSheetName(int sheet, String name)
void
setSheetOrder(String sheetname, int pos)
void
setSheetVisibility(int sheetIx, org.apache.poi.ss.usermodel.SheetVisibility visibility)
Iterator<org.apache.poi.ss.usermodel.Sheet>
sheetIterator()
void
write(OutputStream stream)
从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
从接口继承的方法 java.lang.Iterable
forEach, spliterator
-
构造器详细资料
CsvWorkbook
public CsvWorkbook(Appendable out, Locale locale, Boolean use1904windowing, Boolean useScientificFormat)
方法详细资料
getActiveSheetIndex
public int getActiveSheetIndex()
- 指定者:
-
getActiveSheetIndex
在接口中org.apache.poi.ss.usermodel.Workbook
setActiveSheet
public void setActiveSheet(int sheetIndex)
- 指定者:
-
setActiveSheet
在接口中org.apache.poi.ss.usermodel.Workbook
getFirstVisibleTab
public int getFirstVisibleTab()
- 指定者:
-
getFirstVisibleTab
在接口中org.apache.poi.ss.usermodel.Workbook
setFirstVisibleTab
public void setFirstVisibleTab(int sheetIndex)
- 指定者:
-
setFirstVisibleTab
在接口中org.apache.poi.ss.usermodel.Workbook
setSheetOrder
public void setSheetOrder(String sheetname, int pos)
- 指定者:
-
setSheetOrder
在接口中org.apache.poi.ss.usermodel.Workbook
setSelectedTab
public void setSelectedTab(int index)
- 指定者:
-
setSelectedTab
在接口中org.apache.poi.ss.usermodel.Workbook
setSheetName
public void setSheetName(int sheet, String name)
- 指定者:
-
setSheetName
在接口中org.apache.poi.ss.usermodel.Workbook
getSheetName
public String getSheetName(int sheet)
- 指定者:
-
getSheetName
在接口中org.apache.poi.ss.usermodel.Workbook
getSheetIndex
public int getSheetIndex(String name)
- 指定者:
-
getSheetIndex
在接口中org.apache.poi.ss.usermodel.Workbook
getSheetIndex
public int getSheetIndex(org.apache.poi.ss.usermodel.Sheet sheet)
- 指定者:
-
getSheetIndex
在接口中org.apache.poi.ss.usermodel.Workbook
createSheet
public org.apache.poi.ss.usermodel.Sheet createSheet()
- 指定者:
-
createSheet
在接口中org.apache.poi.ss.usermodel.Workbook
createSheet
public org.apache.poi.ss.usermodel.Sheet createSheet(String sheetname)
- 指定者:
-
createSheet
在接口中org.apache.poi.ss.usermodel.Workbook
cloneSheet
public org.apache.poi.ss.usermodel.Sheet cloneSheet(int sheetNum)
- 指定者:
-
cloneSheet
在接口中org.apache.poi.ss.usermodel.Workbook
sheetIterator
public Iterator<org.apache.poi.ss.usermodel.Sheet> sheetIterator()
- 指定者:
-
sheetIterator
在接口中org.apache.poi.ss.usermodel.Workbook
getNumberOfSheets
public int getNumberOfSheets()
- 指定者:
-
getNumberOfSheets
在接口中org.apache.poi.ss.usermodel.Workbook
getSheetAt
public org.apache.poi.ss.usermodel.Sheet getSheetAt(int index)
- 指定者:
-
getSheetAt
在接口中org.apache.poi.ss.usermodel.Workbook
getSheet
public org.apache.poi.ss.usermodel.Sheet getSheet(String name)
- 指定者:
-
getSheet
在接口中org.apache.poi.ss.usermodel.Workbook
removeSheetAt
public void removeSheetAt(int index)
- 指定者:
-
removeSheetAt
在接口中org.apache.poi.ss.usermodel.Workbook
createFont
public org.apache.poi.ss.usermodel.Font createFont()
- 指定者:
-
createFont
在接口中org.apache.poi.ss.usermodel.Workbook
findFont
public org.apache.poi.ss.usermodel.Font findFont(boolean bold, short color, short fontHeight, String name, boolean italic, boolean strikeout, short typeOffset, byte underline)
- 指定者:
-
findFont
在接口中org.apache.poi.ss.usermodel.Workbook
getNumberOfFonts
public short getNumberOfFonts()
- 指定者:
-
getNumberOfFonts
在接口中org.apache.poi.ss.usermodel.Workbook
getNumberOfFontsAsInt
public int getNumberOfFontsAsInt()
- 指定者:
-
getNumberOfFontsAsInt
在接口中org.apache.poi.ss.usermodel.Workbook
getFontAt
public org.apache.poi.ss.usermodel.Font getFontAt(short idx)
- 指定者:
-
getFontAt
在接口中org.apache.poi.ss.usermodel.Workbook
getFontAt
public org.apache.poi.ss.usermodel.Font getFontAt(int idx)
- 指定者:
-
getFontAt
在接口中org.apache.poi.ss.usermodel.Workbook
createCellStyle
public org.apache.poi.ss.usermodel.CellStyle createCellStyle()
- 指定者:
-
createCellStyle
在接口中org.apache.poi.ss.usermodel.Workbook
getNumCellStyles
public int getNumCellStyles()
- 指定者:
-
getNumCellStyles
在接口中org.apache.poi.ss.usermodel.Workbook
getCellStyleAt
public org.apache.poi.ss.usermodel.CellStyle getCellStyleAt(int idx)
- 指定者:
-
getCellStyleAt
在接口中org.apache.poi.ss.usermodel.Workbook
write
public void write(OutputStream stream) throws IOException
- 指定者:
-
write
在接口中org.apache.poi.ss.usermodel.Workbook
- 抛出:
-
IOException
close
public void close() throws IOException
- 指定者:
-
close
在接口中Closeable
- 指定者:
-
close
在接口中AutoCloseable
- 指定者:
-
close
在接口中org.apache.poi.ss.usermodel.Workbook
- 抛出:
-
IOException
getNumberOfNames
public int getNumberOfNames()
- 指定者:
-
getNumberOfNames
在接口中org.apache.poi.ss.usermodel.Workbook
getName
public org.apache.poi.ss.usermodel.Name getName(String name)
- 指定者:
-
getName
在接口中org.apache.poi.ss.usermodel.Workbook
getNames
public List<? extends org.apache.poi.ss.usermodel.Name> getNames(String name)
- 指定者:
-
getNames
在接口中org.apache.poi.ss.usermodel.Workbook
getAllNames
public List<? extends org.apache.poi.ss.usermodel.Name> getAllNames()
- 指定者:
-
getAllNames
在接口中org.apache.poi.ss.usermodel.Workbook
getNameAt
public org.apache.poi.ss.usermodel.Name getNameAt(int nameIndex)
- 指定者:
-
getNameAt
在接口中org.apache.poi.ss.usermodel.Workbook
createName
public org.apache.poi.ss.usermodel.Name createName()
- 指定者:
-
createName
在接口中org.apache.poi.ss.usermodel.Workbook
getNameIndex
public int getNameIndex(String name)
- 指定者:
-
getNameIndex
在接口中org.apache.poi.ss.usermodel.Workbook
removeName
public void removeName(int index)
- 指定者:
-
removeName
在接口中org.apache.poi.ss.usermodel.Workbook
removeName
public void removeName(String name)
- 指定者:
-
removeName
在接口中org.apache.poi.ss.usermodel.Workbook
removeName
public void removeName(org.apache.poi.ss.usermodel.Name name)
- 指定者:
-
removeName
在接口中org.apache.poi.ss.usermodel.Workbook
linkExternalWorkbook
public int linkExternalWorkbook(String name, org.apache.poi.ss.usermodel.Workbook workbook)
- 指定者:
-
linkExternalWorkbook
在接口中org.apache.poi.ss.usermodel.Workbook
setPrintArea
public void setPrintArea(int sheetIndex, String reference)
- 指定者:
-
setPrintArea
在接口中org.apache.poi.ss.usermodel.Workbook
setPrintArea
public void setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow)
- 指定者:
-
setPrintArea
在接口中org.apache.poi.ss.usermodel.Workbook
getPrintArea
public String getPrintArea(int sheetIndex)
- 指定者:
-
getPrintArea
在接口中org.apache.poi.ss.usermodel.Workbook
removePrintArea
public void removePrintArea(int sheetIndex)
- 指定者:
-
removePrintArea
在接口中org.apache.poi.ss.usermodel.Workbook
getMissingCellPolicy
public org.apache.poi.ss.usermodel.Row.MissingCellPolicy getMissingCellPolicy()
- 指定者:
-
getMissingCellPolicy
在接口中org.apache.poi.ss.usermodel.Workbook
setMissingCellPolicy
public void setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy missingCellPolicy)
- 指定者:
-
setMissingCellPolicy
在接口中org.apache.poi.ss.usermodel.Workbook
createDataFormat
public org.apache.poi.ss.usermodel.DataFormat createDataFormat()
- 指定者:
-
createDataFormat
在接口中org.apache.poi.ss.usermodel.Workbook
addPicture
public int addPicture(byte[] pictureData, int format)
- 指定者:
-
addPicture
在接口中org.apache.poi.ss.usermodel.Workbook
getAllPictures
public List<? extends org.apache.poi.ss.usermodel.PictureData> getAllPictures()
- 指定者:
-
getAllPictures
在接口中org.apache.poi.ss.usermodel.Workbook
getCreationHelper
public org.apache.poi.ss.usermodel.CreationHelper getCreationHelper()
- 指定者:
-
getCreationHelper
在接口中org.apache.poi.ss.usermodel.Workbook
isHidden
public boolean isHidden()
- 指定者:
-
isHidden
在接口中org.apache.poi.ss.usermodel.Workbook
setHidden
public void setHidden(boolean hiddenFlag)
- 指定者:
-
setHidden
在接口中org.apache.poi.ss.usermodel.Workbook
isSheetHidden
public boolean isSheetHidden(int sheetIx)
- 指定者:
-
isSheetHidden
在接口中org.apache.poi.ss.usermodel.Workbook
isSheetVeryHidden
public boolean isSheetVeryHidden(int sheetIx)
- 指定者:
-
isSheetVeryHidden
在接口中org.apache.poi.ss.usermodel.Workbook
setSheetHidden
public void setSheetHidden(int sheetIx, boolean hidden)
- 指定者:
-
setSheetHidden
在接口中org.apache.poi.ss.usermodel.Workbook
getSheetVisibility
public org.apache.poi.ss.usermodel.SheetVisibility getSheetVisibility(int sheetIx)
- 指定者:
-
getSheetVisibility
在接口中org.apache.poi.ss.usermodel.Workbook
setSheetVisibility
public void setSheetVisibility(int sheetIx, org.apache.poi.ss.usermodel.SheetVisibility visibility)
- 指定者:
-
setSheetVisibility
在接口中org.apache.poi.ss.usermodel.Workbook
addToolPack
public void addToolPack(org.apache.poi.ss.formula.udf.UDFFinder toopack)
- 指定者:
-
addToolPack
在接口中org.apache.poi.ss.usermodel.Workbook
setForceFormulaRecalculation
public void setForceFormulaRecalculation(boolean value)
- 指定者:
-
setForceFormulaRecalculation
在接口中org.apache.poi.ss.usermodel.Workbook
getForceFormulaRecalculation
public boolean getForceFormulaRecalculation()
- 指定者:
-
getForceFormulaRecalculation
在接口中org.apache.poi.ss.usermodel.Workbook
getSpreadsheetVersion
public org.apache.poi.ss.SpreadsheetVersion getSpreadsheetVersion()
- 指定者:
-
getSpreadsheetVersion
在接口中org.apache.poi.ss.usermodel.Workbook
addOlePackage
public int addOlePackage(byte[] oleData, String label, String fileName, String command) throws IOException
- 指定者:
-
addOlePackage
在接口中org.apache.poi.ss.usermodel.Workbook
- 抛出:
-
IOException
Copyright © 2018–2021 Alibaba Group. All rights reserved.