I am exporting data from an SQL database into an existing excel file using C# and ADO.
I need to export a datatable where one of the columns is a hyperlink. I am using an OleDb update command to get the data in.
Can this be done?
So far I have tried writing the whole thing using interop but i find it very 'clunky' and anyway I cannot get Excel installed on the server so thats out the question.
Code snippet attached.
foreach (DataRow Row in BookiesData.Tables.Rows)
//I have an OleDB update command in here like:
UPDATE [Sheet1$] SET [F5] = Row, F6 = Row
//but obviously in a C# string.
//Say for example that i want F6 to contain a hyperlink with the URL stored in Row