I have smart markers in all sheets. The name of smart markers will be same in all sheets but the values will be different.
When I add new sheet in workbook I want to process it’s smart markers.
I am not able to get the WorkbookDesigner from workbook.
Please suggest me how can I process such kind of smart markers.
Do you use Aspose.Cells for Java. Well, every WorkbookDesigner has its internal Workbook object and I think you may utilize it for your requirement.
//Instantiating an WorkbookDesigner object
WorkbookDesigner designer = new WorkbookDesigner();
Workbook workbook = designer.getWorkbook();
Worksheet worksheet1 = workbook.getWorksheets().addSheet("mysheet");
//Set the data sources for the designer spreadsheet
//Process the smart markers
I don’t have any designerFilePath in order to perform
I am creating workbook as new Workbook().
I want designer of this workbook.
How can I get it ?
I am using aspose.cells 22.214.171.124
Sure you can get it by WorkbookDesigner, Following code may help you some:
WorkbookDesigner wd = new WorkbookDesigner();
Workbook wb = wd.getWorkbook();
Worksheets wsheets = wb.getWorksheets();
Cell cell = wsheets.getSheet(0).getCells().getCell(0,0);
cell = wsheets.addSheet().getCells().getCell(0,0);
Thank You Johnson.
It’s pretty simple now.