Data
Name | Capital | Continent | Area | Population |
Argentina | Buenos Aires | South America | 2777815 | 32300003 |
Bolivia | La Paz | South America | 1098575 | 7300000 |
Brazil | Brasilia | South America | 8511196 | 150400000 |
Canada | Ottawa | North America | 9976147 | 26500000 |
Chile | Santiago | South America | 756943 | 13200000 |
Colombia | Bagota | South America | 1138907 | 33000000 |
Cuba | Havana | North America | 114524 | 10600000 |
Ecuador | Quito | South America | 455502 | 10600000 |
El Salvador | San Salvador | North America | 20865 | 5300000 |
Guyana | Georgetown | South America | 214969 | 800000 |
Option
Excel Version: |
downloads
- Demo
- Java
- C# source
This demo shows you the usage of WorkbookDesigner.
import com.spire.data.table.DataTable; import com.spire.xls.FileFormat; import com.spire.xls.Workbook; import com.spire.xls.Worksheet; public class MarkerDesignerDemo { public void markerDesignerDemo(String filePath, String dataFilePath, String resultFilePath){ Workbook data_book = new Workbook(); data_book.loadFromFile(dataFilePath); DataTable table = data_book.getWorksheets().get(0).exportDataTable(); Workbook workbook = new Workbook(); workbook.loadFromFile(filePath); Worksheet sheet = workbook.getWorksheets().get(0); Worksheet sheet2 = workbook.getWorksheets().get(1); sheet.setName( "Result"); sheet2.setName("DataSource"); sheet2.insertDataTable(table,true,1,1); workbook.getMarkerDesigner().addParameter("Variable1", 1234.5678); workbook.getMarkerDesigner().addDataTable("Country", table); workbook.getMarkerDesigner().apply(); sheet.getAllocatedRange().autoFitRows(); sheet.getAllocatedRange().autoFitColumns(); workbook.saveToFile(resultFilePath, FileFormat.Version2013); } }
No Matter How Big or Small Your Project is,
Any technical question related to our product, contact us at support@e-iceblue.com.
Any question related to the purchase of product, contact us at sales@e-iceblue.com.
If you don't find the function you want, please request a free demo from us.