半岛外围网上直营

本文给出使用Aspose.Cells for Java格式化列表对象的示例

[Java]

         		//Create a workbook.
			Workbook workbook = new Workbook();

			//Obtaining the reference of the default(first) worksheet
			Worksheet sheet = workbook.getWorksheets().get(0);

			//Obtaining Worksheet's cells collection
			Cells cells = sheet.getCells();

			//Setting the value to the cells
			Cell cell = cells.get("A1");
			cell.putValue("Employee");
			cell = cells.get("B1");
			cell.putValue("Quarter");
			cell = cells.get("C1");
			cell.putValue("Product");
			cell = cells.get("D1");
			cell.putValue("Continent");
			cell = cells.get("E1");
			cell.putValue("Country");
			cell = cells.get("F1");
			cell.putValue("Sale");

			cell = cells.get("A2");
			cell.putValue("David");
			cell = cells.get("A3");
			cell.putValue("David");
			cell = cells.get("A4");
			cell.putValue("David");
			cell = cells.get("A5");
			cell.putValue("David");
			cell = cells.get("A6");
			cell.putValue("James");
			cell = cells.get("A7");
			cell.putValue("James");
			cell = cells.get("A8");
			cell.putValue("James");
			cell = cells.get("A9");
			cell.putValue("James");
			cell = cells.get("A10");
			cell.putValue("James");
			cell = cells.get("A11");
			cell.putValue("Miya");
			cell = cells.get("A12");
			cell.putValue("Miya");
			cell = cells.get("A13");
			cell.putValue("Miya");
			cell = cells.get("A14");
			cell.putValue("Miya");
			cell = cells.get("A15");
			cell.putValue("Miya");


			cell = cells.get("B2");
			cell.putValue(1);
			cell = cells.get("B3");
			cell.putValue(2);
			cell = cells.get("B4");
			cell.putValue(3);
			cell = cells.get("B5");
			cell.putValue(4);
			cell = cells.get("B6");
			cell.putValue(1);
			cell = cells.get("B7");
			cell.putValue(2);
			cell = cells.get("B8");
			cell.putValue(3);
			cell = cells.get("B9");
			cell.putValue(4);
			cell = cells.get("B10");
			cell.putValue(4);
			cell = cells.get("B11");
			cell.putValue(1);
			cell = cells.get("B12");
			cell.putValue(1);
			cell = cells.get("B13");
			cell.putValue(2);
			cell = cells.get("B14");
			cell.putValue(2);
			cell = cells.get("B15");
			cell.putValue(2);

			cell = cells.get("C2");
			cell.putValue("Maxilaku");
			cell = cells.get("C3");
			cell.putValue("Maxilaku");
			cell = cells.get("C4");
			cell.putValue("Chai");
			cell = cells.get("C5");
			cell.putValue("Maxilaku");
			cell = cells.get("C6");
			cell.putValue("Chang");
			cell = cells.get("C7");
			cell.putValue("Chang");
			cell = cells.get("C8");
			cell.putValue("Chang");
			cell = cells.get("C9");
			cell.putValue("Chang");
			cell = cells.get("C10");
			cell.putValue("Chang");
			cell = cells.get("C11");
			cell.putValue("Geitost");
			cell = cells.get("C12");
			cell.putValue("Chai");
			cell = cells.get("C13");
			cell.putValue("Geitost");
			cell = cells.get("C14");
			cell.putValue("Geitost");
			cell = cells.get("C15");
			cell.putValue("Geitost");

			cell = cells.get("D2");
			cell.putValue("Asia");
			cell = cells.get("D3");
			cell.putValue("Asia");
			cell = cells.get("D4");
			cell.putValue("Asia");
			cell = cells.get("D5");
			cell.putValue("Asia");
			cell = cells.get("D6");
			cell.putValue("Europe");
			cell = cells.get("D7");
			cell.putValue("Europe");
			cell = cells.get("D8");
			cell.putValue("Europe");
			cell = cells.get("D9");
			cell.putValue("Europe");
			cell = cells.get("D10");
			cell.putValue("Europe");
			cell = cells.get("D11");
			cell.putValue("America");
			cell = cells.get("D12");
			cell.putValue("America");
			cell = cells.get("D13");
			cell.putValue("America");
			cell = cells.get("D14");
			cell.putValue("America");
			cell = cells.get("D15");
			cell.putValue("America");


			cell = cells.get("E2");
			cell.putValue("China");
			cell = cells.get("E3");
			cell.putValue("India");
			cell = cells.get("E4");
			cell.putValue("Korea");
			cell = cells.get("E5");
			cell.putValue("India");
			cell = cells.get("E6");
			cell.putValue("France");
			cell = cells.get("E7");
			cell.putValue("France");
			cell = cells.get("E8");
			cell.putValue("Germany");
			cell = cells.get("E9");
			cell.putValue("Italy");
			cell = cells.get("E10");
			cell.putValue("France");
			cell = cells.get("E11");
			cell.putValue("U.S.");
			cell = cells.get("E12");
			cell.putValue("U.S.");
			cell = cells.get("E13");
			cell.putValue("Brazil");
			cell = cells.get("E14");
			cell.putValue("U.S.");
			cell = cells.get("E15");
			cell.putValue("U.S.");


			cell = cells.get("F2");
			cell.putValue(2000);
			cell = cells.get("F3");
			cell.putValue(500);
			cell = cells.get("F4");
			cell.putValue(1200);
			cell = cells.get("F5");
			cell.putValue(1500);
			cell = cells.get("F6");
			cell.putValue(500);
			cell = cells.get("F7");
			cell.putValue(1500);
			cell = cells.get("F8");
			cell.putValue(800);
			cell = cells.get("F9");
			cell.putValue(900);
			cell = cells.get("F10");
			cell.putValue(500);
			cell = cells.get("F11");
			cell.putValue(1600);
			cell = cells.get("F12");
			cell.putValue(600);
			cell = cells.get("F13");
			cell.putValue(2000);
			cell = cells.get("F14");
			cell.putValue(500);
			cell = cells.get("F15");
			cell.putValue(900);

			//Adding a new List Object to the worksheet
			ListObject listObject = sheet.getListObjects().get(sheet.getListObjects().add("A1", "F15", true));

			//Adding Default Style to the table
			listObject.setTableStyleType(TableStyleType.TABLE_STYLE_MEDIUM_10);

			//Show Total
			listObject.setShowTotals(true);


			//Set the Quarter field's calculation type
			listObject.getListColumns().get(1).setTotalsCalculation(TotalsCalculation.COUNT);


			//Saving the Excel file
			workbook.save("e:\\test\\List_Object.xlsx");