Excel API Library for Java - Sample Browser | Document Solutions | Export Pivot Table
[
フレーム]
src="bundle.js">
Document Solutions for Excel can export a spreadsheet with Pivot Tables to PDF.
// Create a new workbook
Workbook workbook = new Workbook();
Object sourceData = new Object[][]{
{"Order ID", "Product", "Category", "Amount", "Date", "Country"},
{1, "Broccoli", "Vegetables", 8239, new GregorianCalendar(2018, 0, 7), "United Kingdom"},
{2, "Banana", "Fruit", 617, new GregorianCalendar(2018, 0, 8), "United States"},
{3, "Banana", "Fruit", 8384, new GregorianCalendar(2018, 0, 10), "Canada"},
{4, "Beans", "Vegetables", 2626, new GregorianCalendar(2018, 0, 10), "Germany"},
{5, "Orange", "Fruit", 3610, new GregorianCalendar(2018, 0, 11), "United States"},
{6, "Broccoli", "Vegetables", 9062, new GregorianCalendar(2018, 0, 11), "Australia"},
{7, "Banana", "Fruit", 6906, new GregorianCalendar(2018, 0, 16), "New Zealand"},
{8, "Apple", "Fruit", 2417, new GregorianCalendar(2018, 0, 16), "France"},
{9, "Apple", "Fruit", 7431, new GregorianCalendar(2018, 0, 16), "Canada"},
{10, "Banana", "Fruit", 8250, new GregorianCalendar(2018, 0, 16), "Germany"},
{11, "Broccoli", "Vegetables", 7012, new GregorianCalendar(2018, 0, 18), "United States"},
{12, "Broccoli", "Vegetables", 2824, new GregorianCalendar(2018, 0, 22), "Canada"},
{13, "Apple", "Fruit", 6946, new GregorianCalendar(2018, 0, 24), "France"},
};
IWorksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getRange("K20:P33").setValue(sourceData);
worksheet.getRange("K:P").setColumnWidth(15);
// Add pivot table
IPivotCache pivotcache = workbook.getPivotCaches().create(worksheet.getRange("K20:P33"));
IPivotTable pivottable = worksheet.getPivotTables().add(pivotcache, worksheet.getRange("A1"), "pivottable1");
worksheet.getRange("N21:N35").setNumberFormat("$#,##0.00");
worksheet.getRange("A:G").setColumnWidth(12);
// config pivot table's fields
IPivotField field_Date = pivottable.getPivotFields().get("Date");
field_Date.setOrientation(PivotFieldOrientation.PageField);
IPivotField field_Category = pivottable.getPivotFields().get("Category");
field_Category.setOrientation(PivotFieldOrientation.RowField);
IPivotField field_Product = pivottable.getPivotFields().get("Product");
field_Product.setOrientation(PivotFieldOrientation.ColumnField);
IPivotField field_Amount = pivottable.getPivotFields().get("Amount");
field_Amount.setOrientation(PivotFieldOrientation.DataField);
field_Amount.setNumberFormat("$#,##0.00");
IPivotField field_Country = pivottable.getPivotFields().get("Country");
field_Country.setOrientation(PivotFieldOrientation.RowField);
// Set pivot style
pivottable.setTableStyle("PivotStyleMedium28");
// Save to a pdf file
workbook.save("SavePivotTable.pdf");
// Create a new workbook
var workbook = Workbook()
val sourceData = arrayOf(arrayOf
("Order ID", "Product", "Category", "Amount", "Date", "Country"), arrayOf(1, "Broccoli", "Vegetables", 8239, GregorianCalendar(2018, 0, 7), "United Kingdom"), arrayOf(2, "Banana", "Fruit", 617, GregorianCalendar(2018, 0, 8), "United States"), arrayOf(3, "Banana", "Fruit", 8384, GregorianCalendar(2018, 0, 10), "Canada"), arrayOf(4, "Beans", "Vegetables", 2626, GregorianCalendar(2018, 0, 10), "Germany"), arrayOf(5, "Orange", "Fruit", 3610, GregorianCalendar(2018, 0, 11), "United States"), arrayOf(6, "Broccoli", "Vegetables", 9062, GregorianCalendar(2018, 0, 11), "Australia"), arrayOf(7, "Banana", "Fruit", 6906, GregorianCalendar(2018, 0, 16), "New Zealand"), arrayOf(8, "Apple", "Fruit", 2417, GregorianCalendar(2018, 0, 16), "France"), arrayOf(9, "Apple", "Fruit", 7431, GregorianCalendar(2018, 0, 16), "Canada"), arrayOf(10, "Banana", "Fruit", 8250, GregorianCalendar(2018, 0, 16), "Germany"), arrayOf(11, "Broccoli", "Vegetables", 7012, GregorianCalendar(2018, 0, 18), "United States"), arrayOf(12, "Broccoli", "Vegetables", 2824, GregorianCalendar(2018, 0, 22), "Canada"), arrayOf(13, "Apple", "Fruit", 6946, GregorianCalendar(2018, 0, 24), "France"))
val worksheet = workbook.worksheets.get(0)
worksheet.getRange("K20:P33").value = sourceData
worksheet.getRange("K:P").columnWidth = 15.0
// Add pivot table
val pivotcache = workbook.pivotCaches.create(worksheet.getRange("K20:P33"))
val pivottable = worksheet.pivotTables.add(pivotcache, worksheet.getRange("A1"), "pivottable1")
worksheet.getRange("N21:N35").numberFormat = "$#,##0.00"
worksheet.getRange("A:G").columnWidth = 12.0
// config pivot table's fields
val field_Date = pivottable.pivotFields.get("Date")
field_Date.orientation = PivotFieldOrientation.PageField
val field_Category = pivottable.pivotFields.get("Category")
field_Category.orientation = PivotFieldOrientation.RowField
val field_Product = pivottable.pivotFields.get("Product")
field_Product.orientation = PivotFieldOrientation.ColumnField
val field_Amount = pivottable.pivotFields.get("Amount")
field_Amount.orientation = PivotFieldOrientation.DataField
field_Amount.numberFormat = "$#,##0.00"
val field_Country = pivottable.pivotFields.get("Country")
field_Country.orientation = PivotFieldOrientation.RowField
// Set pivot style
pivottable.tableStyle = "PivotStyleMedium28"
// Save to a pdf file
workbook.save("SavePivotTable.pdf")