Please, read all comments to the question first.
Mugaw25 wrote:
the prog. should read the code from excel and should decrypt it before displaying the data in datagridview.
There is no way to "
read the code from Excel".
I suggest you to read data direct from Excel, then to decrypt it using C#. If you are the author of encrypt/decrypt algorithm, there is no obstacle to write it using C#.
Try!
By The Way: if you provide method to read Excel file, i would be able to add more information.
[EDIT]
Mugaw25 wrote:
where to insert that decryptor
Just when the data are being loaded to datatable. You can use
DataTable.RowChanging event[
^] (or other) to loop through the collection of data and decrypt it.
[/EDIT]