业务要求:打印一串编码例如Aa0001-Aa1000。要求
1:编号从Aa 到Jj
2:要求每一组字母编号从1-1000 自上而下的输入xls表格:例如
Aa0001
Aa0002
.
.
Aa1000
文件名称为Aa0001到Aa1000.xls
Ab0001
Ab0002
.
.
.
Ab1000
文件名称:为Ab0001到Ab1000.xls
现在要弄到xls表格里 完成如下代码!
其实这是java的io操作。业务逻辑并不复杂。无非是三个循环就能搞定。难在IO文件操作呵呵 怎么做呢附上代码 给大家参考
import java.io.BufferedWriter; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStreamWriter; /** * * @author TengSir * */ public class GenerateNumbers { public static void main(String[] args) { for (int i = 'A'; i <='J'; i++) { for (int j = 'a'; j <='j'; j++) { StringBuffer text=new StringBuffer(); for (int t = 1; t <=1000; t++) { String message=String.valueOf((char)i)+String.valueOf((char)j); if(t<10) { message+="000"+t; }else if(t>=10&&t<100) { message+="00"+t; }else if(t>=100&&t<1000) { message+="0"+t; }else if(t>1000) { message+=t; }else { message+=t; } text.append(message+"\r\n"); } File numbers=new File("d:\\sou\\"+(char)i+""+(char)j+"0到"+(char)i+""+(char)j+"1000"+".xls"); FileOutputStream output=null; BufferedWriter writer=null; try { output=new FileOutputStream(numbers); writer=new BufferedWriter(new OutputStreamWriter(output)); } catch (FileNotFoundException e) { e.printStackTrace(); } try { writer.write(text.toString()); } catch (IOException e) { e.printStackTrace(); } try { writer.close(); } catch (IOException e) { e.printStackTrace(); } } } } }