Package jxl.write

Examples of jxl.write.WritableSheet.addCell()

47
48
49
50
51
52
53
54
55
56
57
        WritableWorkbook workbook = Workbook.createWorkbook(outputFile);
        WritableSheet sheet = workbook.createSheet("results", 0);

        try {
            sheet.addCell(new Label(0, 0, "NUMBER OF PILE ELEMENTS"));
            sheet.addCell(new Label(0, 1, "PILE LENGTH (m)"));
            sheet.addCell(new Label(0, 2, "PILE EI (KN M²)"));
            sheet.addCell(new Label(0, 3, "DIAMETER OF PILE (m)"));
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
        WritableSheet sheet = workbook.createSheet("results", 0);

        try {
            sheet.addCell(new Label(0, 0, "NUMBER OF PILE ELEMENTS"));
            sheet.addCell(new Label(0, 1, "PILE LENGTH (m)"));
            sheet.addCell(new Label(0, 2, "PILE EI (KN M²)"));
            sheet.addCell(new Label(0, 3, "DIAMETER OF PILE (m)"));
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
        try {
            sheet.addCell(new Label(0, 0, "NUMBER OF PILE ELEMENTS"));
            sheet.addCell(new Label(0, 1, "PILE LENGTH (m)"));
            sheet.addCell(new Label(0, 2, "PILE EI (KN M²)"));
            sheet.addCell(new Label(0, 3, "DIAMETER OF PILE (m)"));
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
        try {
            sheet.addCell(new Label(0, 0, "NUMBER OF PILE ELEMENTS"));
            sheet.addCell(new Label(0, 1, "PILE LENGTH (m)"));
            sheet.addCell(new Label(0, 2, "PILE EI (KN M²)"));
            sheet.addCell(new Label(0, 3, "DIAMETER OF PILE (m)"));
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
            sheet.addCell(new jxl.write.Number(5, 3, data.getPileDiameter()));
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
            sheet.addCell(new Label(0, 1, "PILE LENGTH (m)"));
            sheet.addCell(new Label(0, 2, "PILE EI (KN M²)"));
            sheet.addCell(new Label(0, 3, "DIAMETER OF PILE (m)"));
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
            sheet.addCell(new jxl.write.Number(5, 3, data.getPileDiameter()));
            sheet.addCell(new jxl.write.Number(5, 4, data.getNumOfPiles()));
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
            sheet.addCell(new Label(0, 2, "PILE EI (KN M²)"));
            sheet.addCell(new Label(0, 3, "DIAMETER OF PILE (m)"));
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
            sheet.addCell(new jxl.write.Number(5, 3, data.getPileDiameter()));
            sheet.addCell(new jxl.write.Number(5, 4, data.getNumOfPiles()));

            sheet.addCell(new Label(0, 6, "DEPTH COORDINATES OF PILE NODES (M)"));
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
            sheet.addCell(new Label(0, 3, "DIAMETER OF PILE (m)"));
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
            sheet.addCell(new jxl.write.Number(5, 3, data.getPileDiameter()));
            sheet.addCell(new jxl.write.Number(5, 4, data.getNumOfPiles()));

            sheet.addCell(new Label(0, 6, "DEPTH COORDINATES OF PILE NODES (M)"));
            int currentRow = 7;
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
            sheet.addCell(new jxl.write.Number(5, 3, data.getPileDiameter()));
            sheet.addCell(new jxl.write.Number(5, 4, data.getNumOfPiles()));

            sheet.addCell(new Label(0, 6, "DEPTH COORDINATES OF PILE NODES (M)"));
            int currentRow = 7;
            int elementCounter =0;
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
           
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
            sheet.addCell(new jxl.write.Number(5, 3, data.getPileDiameter()));
            sheet.addCell(new jxl.write.Number(5, 4, data.getNumOfPiles()));

            sheet.addCell(new Label(0, 6, "DEPTH COORDINATES OF PILE NODES (M)"));
            int currentRow = 7;
            int elementCounter =0;
            for(int i=0;i<=(data.getNumOfElements()/5);i++){
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
            sheet.addCell(new jxl.write.Number(5, 3, data.getPileDiameter()));
            sheet.addCell(new jxl.write.Number(5, 4, data.getNumOfPiles()));

            sheet.addCell(new Label(0, 6, "DEPTH COORDINATES OF PILE NODES (M)"));
            int currentRow = 7;
            int elementCounter =0;
            for(int i=0;i<=(data.getNumOfElements()/5);i++){
                int col=0;
                for(int j=i*5;j<=(i*5)+4;j++){
 
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.