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.metadata.ExcelType;
import cn.gjing.tools.excel.read.ExcelReaderContext;
import cn.gjing.tools.excel.read.resolver.ExcelReader;
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.lang.reflect.Field;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;
/**
* Excel factory
*
* @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 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
* @param initDefaultStyle Whether init default excel style
* @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 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
* @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 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
* @param initDefaultStyle Whether init default excel style
* @return ExcelWriter
*/
public static ExcelBindWriter createWriter(String fileName, Class excelClass, HttpServletResponse response, boolean initDefaultStyle, String... ignores) {
Excel excel = excelClass.getAnnotation(Excel.class);
ParamUtils.requireNonNull(excel, "@Excel annotation was not found on the " + excelClass);
List headerArr = new ArrayList<>();
ExcelWriterContext context = ExcelWriterContext.builder()
.excelFields(BeanUtils.getExcelFields(excelClass, ignores, headerArr))
.headNames(headerArr)
.excelType(excel.type())
.fileName(StringUtils.isEmpty(fileName) ? "".equals(excel.value()) ? LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) : excel.value() : fileName)
.excelClass(excelClass)
.build();
return new ExcelBindWriter(context, excel, response, initDefaultStyle);
}
/**
* Create an excel writer
*
* @param fileName Excel file name
* @param response response
* @param initDefaultStyle Whether init default excel style
* @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 = ExcelWriterContext.builder()
.fileName(fileName)
.excelType(excelType)
.excelClass(Void.class)
.build();
return new ExcelSimpleWriter(context, windowSize, response, initDefaultStyle);
}
/**
* Create an Excel reader
*
* @param file Excel file
* @param excelClass Excel mapped entity
* @param ignores Table headers to be ignored when importing, the number of table headers typically used in
* Excel files does not match the number of mapped entity fields,
* or some table headers are ignored when exporting templates
* @param Entity type
* @return ExcelReader
*/
public static ExcelReader createReader(MultipartFile file, Class excelClass, String... ignores) {
if (file == null) {
throw new ExcelInitException("File cannot be null");
}
Excel excel = excelClass.getAnnotation(Excel.class);
ParamUtils.requireNonNull(excel, "@Excel annotation was not found on the " + excelClass);
ParamUtils.isExcel(file.getOriginalFilename(), excel.type().name().toLowerCase());
try {
return createReader(file.getInputStream(), excelClass, excel, 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 Table headers to be ignored when importing, the number of table headers typically used in
* Excel files does not match the number of mapped entity fields,
* or some table headers are ignored when exporting templates
* @param Entity type
* @return ExcelReader
*/
public static ExcelReader createReader(File file, Class excelClass, String... ignores) {
if (file == null) {
throw new ExcelInitException("File cannot be null");
}
Excel excel = excelClass.getAnnotation(Excel.class);
ParamUtils.requireNonNull(excel, "@Excel annotation was not found on the " + excelClass);
ParamUtils.isExcel(file.getName(), excel.type().name().toLowerCase());
try {
return createReader(new FileInputStream(file), excelClass, excel, 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 Table headers to be ignored when importing, the number of table headers typically used in
* Excel files does not match the number of mapped entity fields,
* or some table headers are ignored when exporting templates
* @param Entity type
* @return ExcelReader
*/
public static ExcelReader createReader(InputStream inputStream, Class excelClass, String... ignores) {
Excel excel = excelClass.getAnnotation(Excel.class);
ParamUtils.requireNonNull(excel, "@Excel annotation was not found on the " + excelClass);
return createReader(inputStream, excelClass, excel, ignores);
}
private static ExcelReader createReader(InputStream inputStream, Class excelClass, Excel excel, String... ignores) {
List excelFieldList = BeanUtils.getExcelFields(excelClass, ignores, null);
ExcelReaderContext readerContext = new ExcelReaderContext<>(inputStream, excelClass, excelFieldList);
return new ExcelReader<>(readerContext, excel);
}
}
