Hello!
It is necessary in existing Exel the document to add sheet Лист96.
If the document contains in a case of figure all works successful (using
libraries: poi-2.5.1-final-20040804, poi-contrib-2.5.1-final-20040804,
poi-scratchpad-2.5.1-final-20040804).
If in the document there is a figure that the damaged document comes back.
I have recommendation to take advantage of newer libraries:
I had downloaded:
poi-bin-3.2-FINAL-20081019: <http: //
mirror.prvtgeo.com/apache/poi/release/bin/>
poi-bin-3.5-beta5-20090219: <http: //
mirror.prvtgeo.com/apache/poi/dev/bin/>
At their use there are errors:
When I used poi-bin-3.5-beta5-20090219, at compilation there is a error:
Exception in tread "main"
java.lang.NoSuchMethodError:org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion
<Lorg/apache/poi/hssf/unit/Region;>I ......;
When I used poi-bin-3.2-FINAL-20081019, after completion of the program, the
document is damaged.
error:
Error of initialization VBA (265). Also suggests to restore the document.
This is a full code of the program:
package VC34;
import VC34.classes.*;
import java.io.*;
import java.util.Date;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import java.sql.*;
import java.util.*;
import javax.naming.*;
import java.text.*;
import java.lang.reflect.*;
import org.apache.poi.hssf.util.Region;
//import org.apache.poi.hssf.util.CellRangeAddress;
import org.apache.poi.hssf.util.*;
//import org.apache.poi.ss.util.Region;
import org.apache.poi.hssf.model.Sheet.*;
import org.apache.poi.hssf.usermodel.HSSFWorkbook.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.usermodel.HSSFSheet.*;
import org.apache.poi.poifs.filesystem.*;
import org.apache.regexp.*;
import org.apache.*;
//import org.apache.struts.*;
import javax.swing.*;
import java.awt.event.*;
import java.applet.*;
/**
*
* @author apopovkin
*/
public class VC34_Excel {
/** Creates a new instance of VC34_Excel */
public VC34_Excel() {
}
/**
* @param args the command line arguments
*/
public static void main(String[] args)throws Exception {
// NumberFormat form = new DecimalFormat("#########0.0#");
System.out.println(args[0]);
System.out.println(args[1]);
System.out.println(args[2]);
System.out.println(args[3]);
System.out.println(args[4]);
System.out.println(args[5]);
System.out.println(args.length);
String beg_dt = "";
String tper = args[4];
String dbName ="";
String UserID ="";
String Password ="";
String Pyt ="";
String Driver ="COM.ibm.db2.jdbc.app.DB2Driver";
PrintStream out=System.out;
SimpleDateFormat dateFormatter1 = new
SimpleDateFormat("yyyy-MM-dd");
SimpleDateFormat dateFormatter2 = new
SimpleDateFormat("dd-MM-yyyy");
SimpleDateFormat dateFormatter3 = new SimpleDateFormat("dd-MM-yyyy
HH:mm:ss");
Calendar time1=Calendar.getInstance();
out.print("Begin:
"+dateFormatter3.format(time1.getTime()).toString()+"\n");
try {
if (args.length>=1){dbName+="db2:"+args[0];}
if (args.length>=2){UserID=args[1];}
if (args.length>=3){Password=args[2];}
if (args.length>=4){beg_dt=args[3];} else beg_dt = "current date
- 1 day";
if (args.length>=5){Pyt=args[5];}
}
catch (Exception e){System.out.print("23"+e);System.exit(1);}
if (dbName.equals("")||UserID.equals("")||Password.equals("")){
System.out.print("Неверно заданны параметры. Формат параметров
gen_stat db_alias user pass otchname year month \n По умолчанию
устанавливается текущий год и предыдущий месяц");
System.exit(0);
}
String dday = beg_dt.substring(0,2);
String mmonth = beg_dt.substring(3,5);
String yyear = beg_dt.substring(6,10);
String End_dt=yyear+"-"+mmonth+"-"+dday;//конец
String DT_OTCH_SYT_F2=dday+"-"+mmonth+"-"+yyear;
String Beg_dt=yyear+"-"+mmonth+"-"+"01";//начало
String DT_NACH_MES_F2="01"+"-"+mmonth+"-"+yyear;
String
GEnd_dt=String.valueOf(Integer.parseInt(yyear)-1)+"-"+mmonth+"-"+dday;//конец
Г
String
GBeg_dt=String.valueOf(Integer.parseInt(yyear)-1)+"-"+mmonth+"-"+"01";//начало
Г
Context initContext = null;
Vector report_VC_0 = new Vector();
Vector report_VC_1 = new Vector();
Vector report_VC_T = new Vector();
Connection connection_mm = null;
ResultSet resultSet_mm = null;
ResultSet resultSet_nod = null;
try {
Class.forName(Driver);
connection_mm = DriverManager.getConnection("jdbc:"+dbName ,
UserID, Password);
Calendar time=Calendar.getInstance();
out.print("DB conect open OK_kol_mm
time="+dateFormatter3.format(time.getTime()).toString()+"\n");
}
catch(Exception e){
out.print("DB error"+e+"\n");
System.exit(1);}
try{
PreparedStatement st1=null;
st1 = connection_mm.prepareStatement(
//SQL---------------
//SQL---------------
);
resultSet_nod=st1.executeQuery();
while (resultSet_nod.next()) {
VC34_Excel_ line0 =new VC34_Excel_();
line0.setDu_Sn(resultSet_nod.getString("co4_r3_1"));
line0.setDu_num(resultSet_nod.getInt("co4_r3_0"));
line0.setco4_r1_13a(resultSet_nod.getFloat("co4_r1_13a"));
line0.setco4_r1_13(resultSet_nod.getDouble("co4_r1_13"));
line0.setco4_r1_14(resultSet_nod.getDouble("co4_r1_14"));
line0.setco4_r3_3(resultSet_nod.getDouble("co4_r3_3"));
line0.setYch_speedM(resultSet_nod.getDouble("co4_r3_22"));
line0.setYch_speedD(resultSet_nod.getDouble("co4_r3_22d"));
line0.setYch_speedNorm(resultSet_nod.getDouble("sp_u"));
line0.setVt(resultSet_nod.getInt("VT"));
report_VC_0.add(line0);
}
resultSet_nod.close();
st1.close();
}catch (SQLException e) {
e.printStackTrace(); }
//закрытие соед.
try {
connection_mm.close();
Calendar time=Calendar.getInstance();
out.print("DB conect close OK_kol_mm
time="+dateFormatter3.format(time.getTime()).toString()+"\n");
} catch (SQLException e) {
e.printStackTrace(); //To change body of catch statement use
File | Settings | File Templates.
}
try {
Class.forName(Driver);
connection_mm = DriverManager.getConnection("jdbc:"+dbName ,
UserID, Password);
Calendar time=Calendar.getInstance();
out.print("DB conect open OK_kol_mm
time="+dateFormatter3.format(time.getTime()).toString()+"\n");
}
catch(Exception e){
out.print("DB error"+e+"\n");
System.exit(1);}
try{
PreparedStatement st1=null;
st1 = connection_mm.prepareStatement(
"Select CLASS.VT.vt_sn,CLASS.VT.VT from CLASS.VT ORDER BY VT "
);
resultSet_nod=st1.executeQuery();
while (resultSet_nod.next()) {
VC34_Excel_ line1 =new VC34_Excel_();
line1.setVt_sn(resultSet_nod.getString("vt_sn"));
line1.setVt(resultSet_nod.getInt("vt"));
report_VC_1.add(line1);
}
resultSet_nod.close();
st1.close();
}catch (SQLException e) {
e.printStackTrace(); }
//закрытие соед.
try {
connection_mm.close();
Calendar time=Calendar.getInstance();
out.print("DB conect close OK_kol_mm
time="+dateFormatter3.format(time.getTime()).toString()+"\n");
} catch (SQLException e) {
e.printStackTrace(); //To change body of catch statement use
File | Settings | File Templates.
}
//NumberFormat form = new DecimalFormat("#########0.##");
NumberFormat form = new DecimalFormat("#########0.0#");
HSSFWorkbook wb ;
InputStream fileInput = null;
try {
//FileDescriptor t=new FileDescriptor
fileInput = new FileInputStream(Pyt);
POIFSFileSystem fs111= new POIFSFileSystem(new
FileInputStream(Pyt));
wb = new HSSFWorkbook(fs111);
// wb = new HSSFWorkbook(fileInput);
out.println("1");
// fileInput.close();
}
catch(Exception e){
wb = new HSSFWorkbook();
}
HSSFSheet sheet =null;
out.println("index69_1="+wb.getSheetIndex("Лист69"));
if(wb.getSheetIndex("Лист69")<0){
sheet =wb.createSheet("Лист69");
wb.setSheetName( wb.getSheetIndex("Лист69"), "Лист69",
HSSFWorkbook.ENCODING_UTF_16 );
out.println("index69_2="+wb.getSheetName(wb.getSheetIndex("Лист69")));
}else
{ out.println("index69_3="+wb.getSheetIndex("Лист69"));
sheet=wb.getSheet("Лист69");
out.println("index69_4="+wb.getSheetName(wb.getSheetIndex("Лист69")));
}
sheet.setColumnWidth((short)0,(short)2200);
sheet.setColumnWidth((short)1,(short)5000);
sheet.setColumnWidth((short)2,(short)4200);
sheet.setColumnWidth((short)3,(short)4200);
sheet.setColumnWidth((short)4,(short)4200);
sheet.setColumnWidth((short)5,(short)4200);
//---------делаем альбомную страницу----------------------
HSSFPrintSetup print = sheet.getPrintSetup();
print.setScale((short)83);
print.setPaperSize((short) print.A4_PAPERSIZE);
String f1="ОТЧЕТ";
String f2="Анализ участковой скорости по диспетчерским участкам";
String f3="";
if(tper.equals("1")){
f3="За "+DT_OTCH_SYT_F2+" г.";}
if(tper.equals("2")){
f3="За период с "+DT_NACH_MES_F2+" по "+DT_OTCH_SYT_F2+" г.";}
String f4="Дорога ЮВОСТ";
String f5="";
HSSFFont font = wb.createFont();
font.setFontHeightInPoints((short)10);//шрифт
font.setFontName("Arial");
font.setBoldweight( HSSFFont.BOLDWEIGHT_BOLD);
HSSFFont font1 = wb.createFont();
font1.setFontHeightInPoints((short)13);//шрифт
font1.setFontName("Arial");
font1.setBoldweight( HSSFFont.BOLDWEIGHT_BOLD);
HSSFCellStyle styleN = wb.createCellStyle();
styleN.setFillBackgroundColor((short)12);
styleN.setAlignment(HSSFCellStyle.ALIGN_CENTER);
styleN.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
styleN.setWrapText(true);
styleN.setFont(font);
HSSFCellStyle styleN1 = wb.createCellStyle();
styleN1.setFillBackgroundColor((short)12);
styleN1.setAlignment(HSSFCellStyle.ALIGN_CENTER);
styleN1.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
styleN1.setFillBackgroundColor((short)155);
styleN1.setWrapText(true);
styleN1.setFont(font1);
HSSFCellStyle style = wb.createCellStyle();
style.setFillBackgroundColor((short)12);
style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style.setBorderRight(HSSFCellStyle.BORDER_THIN);
style.setBorderTop(HSSFCellStyle.BORDER_THIN);
style.setFont(font);
//style.setWrapText(true);
HSSFCellStyle style0 = wb.createCellStyle();
style0.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style0.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
style0.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style0.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style0.setBorderRight(HSSFCellStyle.BORDER_THIN);
style0.setBorderTop(HSSFCellStyle.BORDER_THIN);
style0.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style0.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
style0.setFont(font);
style0.setWrapText(true);
HSSFCellStyle style0_0 = wb.createCellStyle();
style0_0.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style0_0.setFillForegroundColor(HSSFColor.YELLOW.index);
style0_0.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style0_0.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style0_0.setBorderRight(HSSFCellStyle.BORDER_THIN);
style0_0.setBorderTop(HSSFCellStyle.BORDER_THIN);
style0_0.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style0_0.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
style0_0.setFont(font);
style0_0.setWrapText(true);
HSSFCellStyle style0_2 = wb.createCellStyle();
style0_2.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style0_2.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
style0_2.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style0_2.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style0_2.setBorderRight(HSSFCellStyle.BORDER_THIN);
style0_2.setBorderTop(HSSFCellStyle.BORDER_THIN);
style0_2.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style0_2.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
style0_2.setFont(font);
style0_2.setWrapText(true);
style0_2.setRotation((short)90);//вертикальный текст
HSSFCellStyle style0_1 = wb.createCellStyle();
style0_1.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style0_1.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style0_1.setBorderRight(HSSFCellStyle.BORDER_THIN);
style0_1.setBorderTop(HSSFCellStyle.BORDER_THIN);
style0_1.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style0_1.setFont(font);
style0_1.setWrapText(true);
HSSFCellStyle style0_1_0 = wb.createCellStyle();
style0_1_0.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style0_1_0.setBorderTop(HSSFCellStyle.BORDER_THIN);
style0_1_0.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style0_1_0.setFont(font);
style0_1_0.setWrapText(true);
HSSFRow rowN1 = sheet.createRow(0);
HSSFCell cellN1 = rowN1.createCell((short)0);
cellN1.setCellType( HSSFCell.CELL_TYPE_STRING );
cellN1.setCellValue(f1);
cellN1.setCellStyle(styleN1);
Region mmmm= new Region(0,(short)0,1,(short)5);
sheet.addMergedRegion(mmmm);
HSSFRow rowN2 = sheet.createRow(2);//начиная с какой строчки
(+1=строка)
HSSFCell cellN2 = rowN2.createCell((short)0);//начиная со столбца
(+1=столбц)
cellN2.setCellType( HSSFCell.CELL_TYPE_STRING );
cellN2.setCellValue(f2);
cellN2.setCellStyle(styleN1);
sheet.addMergedRegion(new Region(2,(short)0,3,(short)5));
HSSFRow rowN3 = sheet.createRow(4);//начиная с какой строчки (+1=строка)
HSSFCell cellN3 = rowN3.createCell((short)0);//начиная со столбца
(+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
cellN3.setCellValue(f5);
cellN3.setCellStyle(styleN1);
sheet.addMergedRegion(new Region(4,(short)0,5,(short)1));
cellN3 = rowN3.createCell((short)2);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
cellN3.setCellValue(f4);
cellN3.setCellStyle(styleN1);
sheet.addMergedRegion(new Region(4,(short)2,5,(short)3));
cellN3 = rowN3.createCell((short)4);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
cellN3.setCellValue(f3);
cellN3.setCellStyle(styleN1);
sheet.addMergedRegion(new Region(4,(short)4,5,(short)5));
int k_min=6;
int k_max=7;
for (int i1=0;i1<report_VC_1.size();i1++){
VC34_Excel_ line1 =(VC34_Excel_)report_VC_1.get(i1);
String vt_snstr=line1.getVt_sn();
int vtstr=line1.getVt();
//все
for (int i0=0;i0<report_VC_0.size();i0++){
VC34_Excel_ line0 =(VC34_Excel_)report_VC_0.get(i0);
if (line0.getVt()==vtstr )
{
if ((line0.getVt()==1)
&&((line0.getDu_num()==1)||(line0.getDu_num()==2)||(line0.getDu_num()==6)||
(line0.getDu_num()==7)||(line0.getDu_num()==8)||(line0.getDu_num()==9)||
(line0.getDu_num()==10)||(line0.getDu_num()==11)||(line0.getDu_num()==12)||
(line0.getDu_num()==13)||(line0.getDu_num()==15)||(line0.getDu_num()==17)||
(line0.getDu_num()==19)||(line0.getDu_num()==20)||(line0.getDu_num()==26)||
(line0.getDu_num()==27)
))
{
if((line0.getYch_speedM()+line0.getYch_speedD())!=0
)
{
VC34_Excel_ line3 =new VC34_Excel_();
line3.setYch_speedM(line0.getYch_speedM());
line3.setYch_speedD(line0.getYch_speedD());
line3.setDu_Sn(line0.getDu_Sn());
line3.setDu_num(line0.getDu_num());
line3.setYch_speedNorm(line0.getYch_speedNorm());
line3.setco4_r1_13a(line0.getco4_r1_13a());
line3.setco4_r1_13(line0.getco4_r1_13());
line3.setco4_r1_14(line0.getco4_r1_14());
line3.setco4_r3_3(line0.getco4_r3_3());
report_VC_T.add(line3); }
}
if ((line0.getVt()==2)
&&((line0.getDu_num()==3)||(line0.getDu_num()==4)||(line0.getDu_num()==5)||
(line0.getDu_num()==14)||(line0.getDu_num()==16)||(line0.getDu_num()==18)||
(line0.getDu_num()==21)||(line0.getDu_num()==22)||(line0.getDu_num()==23)||
(line0.getDu_num()==24)||(line0.getDu_num()==25)||(line0.getDu_num()==28)||
(line0.getDu_num()==29)
))
{
if((line0.getYch_speedM()+line0.getYch_speedD())!=0
)
{
VC34_Excel_ line3 =new VC34_Excel_();
line3.setYch_speedM(line0.getYch_speedM());
line3.setYch_speedD(line0.getYch_speedD());
line3.setDu_Sn(line0.getDu_Sn());
line3.setDu_num(line0.getDu_num());
line3.setYch_speedNorm(line0.getYch_speedNorm());
line3.setco4_r1_13a(line0.getco4_r1_13a());
line3.setco4_r1_13(line0.getco4_r1_13());
line3.setco4_r1_14(line0.getco4_r1_14());
line3.setco4_r3_3(line0.getco4_r3_3());
report_VC_T.add(line3); }
}
}
}//все
if (report_VC_T.size()!=0){
rowN3 = sheet.createRow(k_min);//начиная с какой строчки (+1=строка)
cellN3 = rowN3.createCell((short)0);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue(line1.getVt_sn());
cellN3.setCellStyle(styleN1);
sheet.addMergedRegion(new Region(k_min,(short)0,k_min+1,(short)1));
rowN3 = sheet.createRow(k_min);//начиная с какой строчки (+1=строка)
cellN3 = rowN3.createCell((short)2);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue("");
cellN3.setCellStyle(styleN1);
sheet.addMergedRegion(new Region(k_min,(short)2,k_min+1,(short)5));
k_min=k_min+2;
rowN3 = sheet.createRow(k_min);//начиная с какой строчки (+1=строка)
cellN3 = rowN3.createCell((short)0);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue("№ ДУ");
cellN3.setCellStyle(style0);
sheet.addMergedRegion(new Region(k_min,(short)0,k_min+1,(short)0));
cellN3 = rowN3.createCell((short)1);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue("Диспетчерский участок");
cellN3.setCellStyle(style0);
sheet.addMergedRegion(new Region(k_min,(short)1,k_min+1,(short)1));
cellN3 = rowN3.createCell((short)2);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue("Участковая скорость, норма");
cellN3.setCellStyle(style0);
sheet.addMergedRegion(new Region(k_min,(short)2,k_min+1,(short)2));
cellN3 = rowN3.createCell((short)3);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue("Участковая скорость, сутки");
cellN3.setCellStyle(style0);
sheet.addMergedRegion(new Region(k_min,(short)3,k_min+1,(short)3));
cellN3 = rowN3.createCell((short)4);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue("Участковая скорость, с/сутки");
cellN3.setCellStyle(style0);
sheet.addMergedRegion(new Region(k_min,(short)4,k_min+1,(short)4));
cellN3 = rowN3.createCell((short)5);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue("+/- к норме");
cellN3.setCellStyle(style0);
sheet.addMergedRegion(new Region(k_min,(short)5,k_min+1,(short)5));
for (int w=0;w<=5;w++ )
{ for (int k=k_min+1; k<=k_min+1;k++) {
rowN3 = sheet.createRow(k);
cellN3 = rowN3.createCell((short)w);//начиная со столбца (+1=столбц)
cellN3.setCellStyle(style0);}}
k_min=k_min+2;
for (int i3=0;i3<report_VC_T.size();i3++){
VC34_Excel_ line3 =(VC34_Excel_)report_VC_T.get(i3);
rowN3 = sheet.createRow(k_min);//начиная с какой строчки
(+1=строка)
cellN3 = rowN3.createCell((short)0);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue(line3.getDu_num());
cellN3.setCellStyle(style0_1);
sheet.addMergedRegion(new Region(k_min,(short)0,k_min,(short)0));
cellN3 = rowN3.createCell((short)1);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue(line3.getDu_Sn());
if((line3.getYch_speedM()-line3.getYch_speedNorm())<0){
cellN3.setCellStyle(style0_0);
}else{
cellN3.setCellStyle(style0_1);}
sheet.addMergedRegion(new Region(k_min,(short)1,k_min,(short)1));
rowN3 = sheet.createRow(k_min);//начиная с какой строчки (+1=строка)
cellN3 = rowN3.createCell((short)2);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue(form.format((line3.getYch_speedNorm())));
cellN3.setCellStyle(style0_1);
sheet.addMergedRegion(new Region(k_min,(short)2,k_min,(short)2));
cellN3 = rowN3.createCell((short)3);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue(form.format(line3.getYch_speedD()));
if((line3.getYch_speedD()-line3.getYch_speedNorm())<0){
cellN3.setCellStyle(style0_0);
}else{
cellN3.setCellStyle(style0_1);}
sheet.addMergedRegion(new Region(k_min,(short)3,k_min,(short)3));
cellN3 = rowN3.createCell((short)4);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue(form.format(line3.getYch_speedM()));
if((line3.getYch_speedM()-line3.getYch_speedNorm())<0){
cellN3.setCellStyle(style0_0);
}else{
cellN3.setCellStyle(style0_1);}
sheet.addMergedRegion(new Region(k_min,(short)4,k_min,(short)4));
cellN3 = rowN3.createCell((short)5);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue(form.format((line3.getYch_speedM()-line3.getYch_speedNorm())));
if((line3.getYch_speedM()-line3.getYch_speedNorm())<0){
cellN3.setCellStyle(style0_0);
}else{
cellN3.setCellStyle(style0_1);}
sheet.addMergedRegion(new Region(k_min,(short)5,k_min,(short)5));
k_min=k_min+1;
}//line3
rowN3 = sheet.createRow(k_min);//начиная с какой строчки (+1=строка)
cellN3 = rowN3.createCell((short)0);//начиная со столбца (+1=столбц)
cellN3.setCellType( HSSFCell.CELL_TYPE_STRING );
// cellN3.setEncoding( HSSFCell.ENCODING_UTF_16 );
cellN3.setCellValue("");
cellN3.setCellStyle(style0_1_0);
sheet.addMergedRegion(new Region(k_min,(short)0,k_min+1,(short)5));
k_min=k_min+2;
report_VC_T.clear();
}//size
}//тяга
OutputStream fileOut = new FileOutputStream(Pyt);
// POIFSFileSystem fs112= new POIFSFileSystem(new FileOutputStream(Pyt));
wb.write(fileOut);
fileOut.close();
}
}
Give me please advise that it is possible to make in the given situation.
Sorry, I have a bad english.
--
View this message in context:
http://www.nabble.com/Images-and-Exel-tp23937543p23980019.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
