EXCEL操作替换单元格中的Alt+Enter
1:选中要替换的列
2:Ctrl+F
3:上面的输入框输入:Ctrl+J(按键)
4:下面输入要替换的符号
补充:另外的一种情况就是,进行了以上的操作之后。但是,因为编码的问题,
比如说我遇到的问题,**.xls格式的文件,可能因为编码格式的问题,不能存为
**.csv的文件,这个时候最好还是用JAVA程序来解决。
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ReadExcel {
public static void main(String[] args) {
// TODO Auto-generated method stub
ReadExcel readExcel = new ReadExcel();
readExcel.readExcel("*****.xls");
}
public static void readExcel(String fileName) {
Workbook wb = null;
try {
wb = Workbook.getWorkbook(new File(fileName));
Sheet sheet = wb.getSheet(0);
//ddd
WritableWorkbook wwb = Workbook.createWorkbook(new File("d:\\data.xls"));
WritableSheet ws = wwb.createSheet("data",0);
//10908
for(int i=0; i<10908; i++){
for(int j=0;j<=13;j++){
String content = sheet.getCell(j, i).getContents();
content = content.replaceAll("\n", "#"); //.replaceAll(",", " ");
System.out.println(content);
Label label = new Label(j, i, content);
ws.addCell(label);
}
}
wwb.write();
wwb.close();
} catch (Exception e) {
System.out.println("出现异常" + e);
e.printStackTrace();
} finally {
wb.close();
}
}
}