It is so common requirement in any kind web apps – to have dependent lists of values. For example in order to choose location, first of all we choose country, then in another combo box choose state, which is already filtered out against country. MS Excel itself has such a feature. We implement lists of values in excel by adding…
Category: ADF Desktop Integration (ADFdi)
How to delete a record in table component of ADF Desktop integration (ADFDI) Excel workbook?
In my previous post I’ve introduced what needs to be done in order to be able to insert and update data in ADF Desktop integration (ADFDI) table component: How to insert new record in table component of ADF Desktop integration (ADFDI) Excel workbook ? How to update a record in table component of ADF Desktop Integration (ADFDI) Excel workbook ?…
How to insert new record in table component of ADF Desktop integration (ADFDI) Excel workbook ?
In previous post I’ve provided some guidance how to use update operation in ADFDI table component. Here I’m going to show how to insert data. Assuming that you’re already familiar with update from post – How to update a record in ADF Desktop Integration (ADFDI) Excel workbook table component?. I’ll just further extend demo application developed in preceding post. So, to support…
How to update a record in table component of ADF Desktop Integration (ADFDI) Excel workbook ?
Update – the easiest of CRUD operations to configure in ADF Desktop Integration (ADFDI) table component. Here is what needs to be assured to have it working: Commit action binding available in page definition file. Upload ribbon command is set up in excel worksheet. It must have at least to actions – upload and commit. Updating of row enabled in…
How to pass a parameter to ADF Desktop Integration (ADFDI) excel workbook?
ADF Desktop Integration (ADFDI) would not be so attractive and flexible if we could not parameterise data requests to limit data scope working on. Thus parameterising is must have feature and it might look not so straight forward how to leverage it. Because we need to set it up in several places all the way to application layer, where data…
How to create ADF Desktop Integration (ADFDI) Excel workbook
I’m going to show the basic steps to get ADF Desktop Integration (ADFDI) Excel workbook running. Here is what we need to accomplish: Create Fusion web application with some ADF bussiness components in model layer. Create ADFDI page definition file. This one will be dedicated for excel and provide necessary bindings to be utilised by ADFDI Excel components. Create special…
How to prepare ADF Desktop Integration (ADFDI) bindings to be utilised by Excel worksheet?
In this post I’m going to show how to prepare ADF bindings, which could be utilised by ADF Desktop Integration Excel workbook. This is particularly about type of page definition file, which is special for ADFDI. However just in case I’ll shortly point out to tree and execute action bindings which will be necessary for Excel workbook. In another post…
How to configure ADF Desktop Integration (ADFDI) worksheet to load data automatically on opening?
Assuming that you already have ADFDI excel workbook ready to download data and do it via explicit click of download action (like we did in the post – How to create ADF Desktop Integration (ADFDI) Excel workbook). And now you want to download table data automatically on workbook opening. Here are the steps to be accomplished: Open Worksheet Properties Go…
How to install ADF Desktop Integration (ADFDI) plugin?
Apparently, the very first step needs to be taken before enjoying amazing ADF Desktop Integration (ADFDI) features is installation of ADFDI plugin. It enables desktop integration with MS Excel spreadsheets to manage data from web applications via Excel. Probably the easiest way, which does not need any extra explanation, is just choose Tools -> Install ADF Desktop Integration in JDeveloper. And…
ADFDI-05538: The workbook integration has been altered after publishing. What can be the reason?
Here is full error message: ADFDI-05538: The workbook integration has been altered after publishing. It can no longer be used safely. The integration will now terminate. What is the reason? Most probably, you did publish excel with different file name and trying to open previously published (old file name) version. This even can be a legal case, for example if…