I'm using Excel tools 2.2.6 to create excel documents from a template. I create a document where I have a table on the first sheet and a chart on the second sheet. What I want to do is to be able to dump the data in the first sheet so the graph is updated with the new data.
However, the problem is that when I export the data into the document, the formatting is lost and the charts are removed from the second sheet.
Is it possible to preserve any existing configurations and charts within the template when exporting the data?
Here is the code I'm working with.
a!localVariables( local!data: rule!EXT_QE_getSampleData(id: null).data, local!exportDocId, local!errorMessage, { if( isnull(local!exportDocId), /*This link field contains the link that starts the export*/ a!linkField( labelPosition: "COLLAPSED", links: a!dynamicLink( label: "Export to Excel File", saveInto: { a!exportDataStoreEntityToExcel( entity: cons!EXT_DS_SAMPLE_DATA, documentDescription: "Data exported to excel", documentToUpdate: cons!EXT_EXCEL_EXPORT_TEMPLATE, saveInFolder: cons!EXT_FOLDER_EXPORT_TO_EXCEL, includeHeader: false, sheetName: "Data", sheetNumber: 1, startingCell: "A2", onSuccess: a!save(local!exportDocId, fv!newDocument), onError: a!save(local!errorMessage, "Error Exporting File to Excel") ) } ) ), {} ), if( not(isnull(local!exportDocId)), a!linkField( links: a!documentDownloadLink( label: "Download Excel File", document: local!exportDocId ) ), a!textField(value: local!errorMessage, readOnly: true) ) } )
Discussion posts and replies are publicly visible
Hii could you please tell me how to add filters to excel so that what ever we are selecting that has to be show in the excel data to dwl