Is the following possible in Dynamics CRM 2011 via plugin?
I'd like to put a custom button on a ribbon that runs a plugin that runs when the button is pressed.
The plugin will need to do the following:
Receives data from a C# function/procedure containing values that have been generated via Query Expression
Then connects to a specially formatted excel spreadsheet that will be sitting out on disk, and performs the equivalent of "Pasting Values Only" column by column into that pre-existing excel spreadsheet.
The use case and requirements are very detailed so the only way to meet them is to connect to the sheet, find the first column based on the column name in the first row or a specific row I will know ahead of time, and then "past as values" into that column, the data obtained via query expression.
Then the process will repeat until all relevant columns are filled.
Nobody will open the spreadsheet while the process is happening, the only thing touching it will be Dynamics CRM.
If something like this is possible, can anyone provide some high level guidance as to the particulars I need to look into in order to achieve it?
Many thanks in advance for any guidance, recommendations, or assistance regarding how to approach this.
*This post is locked for comments