业务要求:打印一串编码例如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();
}
}
}
}
}