返回目录:excel表格制作
修改完需要写e5a48de588b6e799bee5baa6e997aee7ad94333入,也就是保存一下的。
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class ChangeCell {
@SuppressWarnings("deprecation")
public static void main(String[] args) {
String fileToBeRead = "C:\\exp.xls"; // excel位置
int coloum = 1; // 比如你要获取第1列
try {
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(
fileToBeRead));
HSSFSheet sheet = workbook.getSheet("Sheet1");
for (int i = 0; i <= sheet.getLastRowNum(); i++) {
HSSFRow row = sheet.getRow((short) i);
if (null == row) {
continue;
} else {
HSSFCell cell = row.getCell((short) coloum);
if (null == cell) {
continue;
} else {
System.out.println(cell.getNumericCellValue());
int temp = (int) cell.getNumericCellValue();
cell.setCellValue(temp + 1);
}
}
}
FileOutputStream out = null;
try {
out = new FileOutputStream(fileToBeRead);
workbook.write(out);
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
out.close();
} catch (IOException e) {
e.printStackTrace();
}
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
在excel中将表格copy线变为深黑色,可在表格边框设置中将边框线条颜色设置为深黑色。
方法步骤如下:百
1、打开需要操作的EXCEL表格,选中需要把边框线改为黑色的单元格,点击“字体”上面边框旁边的度下拉按钮。
2、在下拉选项中选点击“线条颜色”,并在右侧颜色选项中点击“黑色问”。
3、继续点击“边框”旁边的下拉按钮,点击“所有框线”即可。
4、返回EXCEL表格,可发现已成功将EXCEL的表格线变为深答黑色
HSSFCellStyle style = hwb.createCellStyle();
设置边框抄颜色(袭上下左右线百条度设置为问黑色)答
style.setTopBorderColor(HSSFColor.BLACK.index);
style.setBottomBorderColor(HSSFColor.BLACK.index);
style.setLeftBorderColor(HSSFColor.BLACK.index);
style.setRightBorderColor(HSSFColor.BLACK.index);
引用:https://zhidao.baidu.com/question/525827372.html
Java中设置表格边线颜色:
import com.spire.xls.*;
import java.awt.*;
public class AddBorders {
public static void main(String[] args){
//Create a workbook instance
Workbook workbook = new Workbook();
//Load the Excel file
workbook.loadFromFile("Sample-SetBorder.xlsx");
//Get the first worksheet
Worksheet sheet = workbook.getWorksheets().get(0);
//Get the cell range that you want to apply border style
CellRange cr = sheet.getCellRange(sheet.getFirstRow(), sheet.getFirstColumn(), sheet.getLastRow(), sheet.getLastColumn());
//Apply border style
cr.getBorders().setLineStyle(LineStyleType.Double);
cr.getBorders().getByBordersLineType(BordersLineType.DiagonalDown).setLineStyle(LineStyleType.None);
cr.getBorders().getByBordersLineType(BordersLineType.DiagonalUp).setLineStyle(LineStyleType.None);
cr.getBorders().setColor(Color.BLUE);
//Save the resultant file
workbook.saveToFile("SetBorder.xlsx", ExcelVersion.Version2010);
}
}
参考自:7a64e4b893e5b19e332网页链接