| | |
|---|
| | | import com.whyc.util.ActionUtil; |
|---|
| | | import org.apache.poi.hssf.usermodel.*; |
|---|
| | | import org.apache.poi.ss.usermodel.ClientAnchor; |
|---|
| | | import org.apache.poi.ss.usermodel.IndexedColors; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | import org.springframework.transaction.annotation.Transactional; |
|---|
| | |
|---|
| | | ,"基本单位","子件数量","生产商","封装类型/材质","元件编号/料厚","表面处理/物料详情","备注","图片"}; |
|---|
| | | //字体格式-加粗 |
|---|
| | | HSSFCellStyle cellStyle = wb.createCellStyle(); |
|---|
| | | cellStyle.setFillForegroundColor(IndexedColors.GOLD.getIndex());//添加前景色,内容看的清楚 |
|---|
| | | cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); |
|---|
| | | HSSFFont font = wb.createFont(); |
|---|
| | | font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); |
|---|
| | | font.setColor(HSSFFont.COLOR_RED); |
|---|
| | | //font.setColor(HSSFFont.COLOR_RED); |
|---|
| | | cellStyle.setFont(font); |
|---|
| | | //创建单个sheet |
|---|
| | | HSSFSheet sheet = wb.createSheet("产品信息"); |
|---|
