Connecting Microsoft Jet Oledb with Excel Exceeds Formulas

Question

I have a dataset and am writing its values ​​to an excel file using the Microsoft Jet 4.0 Oledb provider. I want to put hyperlinks in excel, for this I write "= HYPERLINK (" http://www.abc.org/x.pdf ")" in DS, and then write it down to succeed. But when excel opens, it prefix "(quote / apostrophe) in front of the formula, and there it appears as text, not a link. Can you help me remove this quote so that my excel file has hyperlinks instead as text?

I need to use a Microsoft Jet 4.0 provider (not an excel component), since the client machine may or may not have MS-Excel installed on its machine.

Answer 1

Jet will integrate data with Excel. You can read / write data. Not formulas or formatting or anything else.

To do what you want, you will need to output formatted data. You can do this by creating an HTML file and letting the client know that it is an Excel that will work fine but has minor side effects. A better option would be to use an actual Excel binary script. There are many options:

Import and Export Excel - What is the Best Library?