Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
package cn.gjing.tools.excel;
import cn.gjing.tools.excel.exception.ExcelInitException;
import cn.gjing.tools.excel.exception.ExcelTemplateException;
import cn.gjing.tools.excel.metadata.ExcelFieldProperty;
import cn.gjing.tools.excel.metadata.ExcelType;
import cn.gjing.tools.excel.read.ExcelReaderContext;
import cn.gjing.tools.excel.read.resolver.ExcelBindReader;
import cn.gjing.tools.excel.read.resolver.ExcelSimpleReader;
import cn.gjing.tools.excel.util.BeanUtils;
import cn.gjing.tools.excel.util.ParamUtils;
import cn.gjing.tools.excel.write.ExcelWriterContext;
import cn.gjing.tools.excel.write.resolver.ExcelBindWriter;
import cn.gjing.tools.excel.write.resolver.ExcelSimpleWriter;
import org.springframework.util.StringUtils;
import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;
/**
* Excel factory
* Create read and write actuators
*
* @author Gjing
**/
public final class ExcelFactory {
private ExcelFactory() {
}
/**
* Create an excel writer
*
* @param excelClass Excel mapped entity
* @param response response
* @param ignores Which table heads to be ignored when exporting, in the case of multiple table heads,
* there are more than one child table heads under the ignored table head,
* then the child table head will be ignored, if the ignored table head is from the table head
* then it is ignored
* @return ExcelWriter
*/
public static ExcelBindWriter createWriter(Class excelClass, HttpServletResponse response, String... ignores) {
return createWriter(null, excelClass, response, true, ignores);
}
/**
* Create an excel writer
*
* @param excelClass Excel mapped entity
* @param response response
* @param ignores The name of the header to be ignored when exporting.
* If it is a parent, all children below it will be ignored as well
* @param initDefaultStyle Use the default style listener
* @return ExcelWriter
*/
public static ExcelBindWriter createWriter(Class excelClass, HttpServletResponse response, boolean initDefaultStyle, String... ignores) {
return createWriter(null, excelClass, response, initDefaultStyle, ignores);
}
/**
* Create an excel writer
*
* @param excelClass Excel mapped entity
* @param response response
* @param ignores The name of the header to be ignored when exporting.
* If it is a parent, all children below it will be ignored as well
* @param fileName Excel file name，The priority is higher than the annotation specification
* @return ExcelWriter
*/
public static ExcelBindWriter createWriter(String fileName, Class excelClass, HttpServletResponse response, String... ignores) {
return createWriter(fileName, excelClass, response, true, ignores);
}
/**
* Create an excel writer
*
* @param fileName Excel file name，The priority is higher than the annotation specification
* @param excelClass Excel mapped entity
* @param response response
* @param ignores The name of the header to be ignored when exporting.
* If it is a parent, all children below it will be ignored as well
* @param initDefaultStyle Use the default style listener
* @return ExcelWriter
*/
public static ExcelBindWriter createWriter(String fileName, Class excelClass, HttpServletResponse response, boolean initDefaultStyle, String... ignores) {
ParamUtils.requireNonNull(excelClass, "Excel mapping class cannot be null");
Excel excel = excelClass.getAnnotation(Excel.class);
ParamUtils.requireNonNull(excel, "@Excel annotation was not found on the " + excelClass);
List properties = new ArrayList<>();
ExcelWriterContext context = new ExcelWriterContext();
context.setExcelFields(BeanUtils.getExcelFields(excelClass, ignores, properties));
context.setExcelClass(excelClass);
context.setFieldProperties(properties);
context.setExcelType(excel.type());
context.setFileName(StringUtils.isEmpty(fileName) ? "".equals(excel.value()) ? LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) : excel.value() : fileName);
context.setHeaderHeight(excel.headerHeight());
context.setHeaderSeries(properties.get(0).getValue().length);
context.setBodyHeight(excel.bodyHeight());
context.setUniqueKey("".equals(excel.uniqueKey()) ? excelClass.getName() : excel.uniqueKey());
return new ExcelBindWriter(context, excel, response, initDefaultStyle);
}
/**
* Create an excel writer
*
* @param fileName Excel file name
* @param response response
* @param initDefaultStyle Use the default style listener
* @return ExcelSimpleWriter
*/
public static ExcelSimpleWriter createSimpleWriter(String fileName, HttpServletResponse response, boolean initDefaultStyle) {
return createSimpleWriter(fileName, response, ExcelType.XLS, 500, initDefaultStyle);
}
/**
* Create an excel writer
*
* @param fileName Excel file name
* @param response response
* @param excelType Excel file type
* @return ExcelSimpleWriter
*/
public static ExcelSimpleWriter createSimpleWriter(String fileName, HttpServletResponse response, ExcelType excelType) {
return createSimpleWriter(fileName, response, excelType, 500, true);
}
/**
* Create an excel writer
*
* @param fileName Excel file name
* @param response response
* @param excelType Excel file type
* @param windowSize Window size, which is flushed to disk when exported
* if the data that has been written out exceeds the specified size
* only for xlsx
* @return ExcelSimpleWriter
*/
public static ExcelSimpleWriter createSimpleWriter(String fileName, HttpServletResponse response, ExcelType excelType, int windowSize) {
return createSimpleWriter(fileName, response, excelType, windowSize, true);
}
/**
* Create an excel writer
*
* @param fileName Excel file name
* @param response response
* @param excelType Excel file type
* @param windowSize Window size, which is flushed to disk when exported
* if the data that has been written out exceeds the specified size
* only for xlsx
* @param initDefaultStyle Whether init default excel style
* @return ExcelSimpleWriter
*/
public static ExcelSimpleWriter createSimpleWriter(String fileName, HttpServletResponse response, ExcelType excelType, int windowSize, boolean initDefaultStyle) {
ExcelWriterContext context = new ExcelWriterContext();
context.setFileName(StringUtils.isEmpty(fileName) ? LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) : fileName);
context.setExcelType(excelType);
context.setExcelClass(Object.class);
context.setBind(false);
return new ExcelSimpleWriter(context, windowSize, response, initDefaultStyle);
}
/**
* Create an Excel reader
*
* @param file Excel file
* @param excelClass Excel mapped entity
* @param ignores The name of the header to be ignored during import.
* If it is the parent header, all children below it will be ignored
* @param Entity type
* @return ExcelReader
*/
public static ExcelBindReader createReader(MultipartFile file, Class excelClass, String... ignores) {
try {
ExcelType excelType = ParamUtils.getExcelType(file.getOriginalFilename());
if (excelType == null) {
throw new ExcelTemplateException("File type does not belong to Excel");
}
return createReader(file.getInputStream(), excelClass, excelType, ignores);
} catch (IOException e) {
throw new ExcelInitException("Create excel reader error," + e.getMessage());
}
}
/**
* Create an Excel reader
*
* @param file Excel file
* @param excelClass Excel mapped entity
* @param ignores The name of the header to be ignored during import.
* If it is the parent header, all children below it will be ignored
* @param Entity type
* @return ExcelReader
*/
public static ExcelBindReader createReader(File file, Class excelClass, String... ignores) {
try {
ExcelType excelType = ParamUtils.getExcelType(file.getName());
if (excelType == null) {
throw new ExcelTemplateException("File type does not belong to Excel");
}
return createReader(new FileInputStream(file), excelClass, excelType, ignores);
} catch (IOException e) {
throw new ExcelInitException("Create excel reader error," + e.getMessage());
}
}
/**
* Create an Excel reader
*
* @param inputStream Excel file inputStream
* @param excelClass Excel mapped entity
* @param ignores Ignore the array of actual Excel table headers that you read when importing
* @param excelType Excel file type
* @param Entity type
* @return ExcelReader
*/
public static ExcelBindReader createReader(InputStream inputStream, Class excelClass, ExcelType excelType, String... ignores) {
ParamUtils.requireNonNull(excelClass, "Excel mapping class cannot be null");
Excel excel = excelClass.getAnnotation(Excel.class);
ParamUtils.requireNonNull(excel, "@Excel annotation was not found on the " + excelClass);
ExcelReaderContext readerContext = new ExcelReaderContext<>(excelClass, BeanUtils.getExcelFieldsMap(excelClass), ignores);
readerContext.setUniqueKey("".equals(excel.uniqueKey()) ? excelClass.getName() : excel.uniqueKey());
return new ExcelBindReader<>(readerContext, inputStream, excelType, excel.cacheRowSize(), excel.bufferSize());
}
/**
* Create an Excel reader
*
* @param file Excel file
* @param ignores Ignore the array of actual Excel table headers that you read when importing
* @param bufferSize buffer size to use when reading InputStream to file, only XLSX
* @param cacheRow How many lines of data in the Excel file need to be saved when imported, only XLSX
* @param Entity type
* @return ExcelReader
*/
public static ExcelSimpleReader createSimpleReader(File file, int cacheRow, int bufferSize, String... ignores) {
try {
ExcelType excelType = ParamUtils.getExcelType(file.getName());
if (excelType == null) {
throw new ExcelTemplateException("File type does not belong to Excel");
}
return createSimpleReader(new FileInputStream(file), excelType, cacheRow, bufferSize, ignores);
} catch (IOException e) {
throw new ExcelInitException("Create excel reader error," + e.getMessage());
}
}
/**
* Create an Excel reader
*
* @param file Excel file
* @param ignores Ignore the array of actual Excel table headers that you read when importing
* @param Entity type
* @return ExcelReader
*/
public static ExcelSimpleReader createSimpleReader(File file, String... ignores) {
try {
ExcelType excelType = ParamUtils.getExcelType(file.getName());
if (excelType == null) {
throw new ExcelTemplateException("File type does not belong to Excel");
}
return createSimpleReader(new FileInputStream(file), excelType, 100, 2048, ignores);
} catch (IOException e) {
throw new ExcelInitException("Create excel reader error," + e.getMessage());
}
}
/**
* Create an Excel reader
*
* @param file Excel file
* @param ignores Ignore the array of actual Excel table headers that you read when importing
* @param bufferSize buffer size to use when reading InputStream to file, only XLSX
* @param cacheRow How many lines of data in the Excel file need to be saved when imported, only XLSX
* @param Entity type
* @return ExcelReader
*/
public static ExcelSimpleReader createSimpleReader(MultipartFile file, int cacheRow, int bufferSize, String... ignores) {
try {
ExcelType excelType = ParamUtils.getExcelType(file.getOriginalFilename());
if (excelType == null) {
throw new ExcelTemplateException("File type does not belong to Excel");
}
return createSimpleReader(file.getInputStream(), excelType, cacheRow, bufferSize, ignores);
} catch (IOException e) {
throw new ExcelInitException("Create excel reader error," + e.getMessage());
}
}
/**
* Create an Excel reader
*
* @param file Excel file
* @param ignores Ignore the array of actual Excel table headers that you read when importing
* @param Entity type
* @return ExcelReader
*/
public static ExcelSimpleReader createSimpleReader(MultipartFile file, String... ignores) {
try {
ExcelType excelType = ParamUtils.getExcelType(file.getOriginalFilename());
if (excelType == null) {
throw new ExcelTemplateException("File type does not belong to Excel");
}
return createSimpleReader(file.getInputStream(), excelType, 100, 2048, ignores);
} catch (IOException e) {
throw new ExcelInitException("Create excel reader error," + e.getMessage());
}
}
/**
* Create an Excel reader
*
* @param inputStream Excel file inputStream
* @param ignores Ignore the array of actual Excel table headers that you read when importing
* @param excelType Excel file type
* @param bufferSize buffer size to use when reading InputStream to file, only XLSX
* @param cacheRow How many lines of data in the Excel file need to be saved when imported, only XLSX
* @param Entity type
* @return ExcelReader
*/
public static ExcelSimpleReader createSimpleReader(InputStream inputStream, ExcelType excelType, int cacheRow, int bufferSize, String... ignores) {
ExcelReaderContext readerContext = new ExcelReaderContext<>(null, null, ignores);
return new ExcelSimpleReader<>(readerContext, inputStream, excelType, cacheRow, bufferSize);
}
}
