Microsft Jet oledb connection to excel loses formulae

Posted by Saubhagya on Stack Overflow See other posts from Stack Overflow or by Saubhagya
Published on 2010-04-12T17:29:06Z Indexed on 2010/04/12 17:33 UTC
Read the original article Hit count: 402

Filed under:

oledb

|

ms-office

|

c#

|

excel-formula

|

export-to-excel

I have a dataset and I write it's values to an excel file using Microsoft Jet 4.0 Oledb provider. I want to put hyperlinks into the excel, for this I write "=HYPERLINK("http://www.abc.org/x.pdf")" in DS and then write it to excel. But when the excel is opened it prefixes a ' (quote/apostrophe) before the formula and there it comes as a text, not link. Can you help me removing that quote so that my excel file has hyperlinks instead of that as text?

I need to use Microsoft Jet 4.0 provider (not excel component) as the client machine may or may not have MS-Excel installed on his machine.

© Stack Overflow or respective owner

Related posts about oledb

Running OLEDB VB6 Windows Progam Under Wine

as seen on Super User - Search for 'Super User'
I'm trying to install a VB6 Windows program that uses OLEDB to access VFP tables to run under Wine 1.0.1 on Ubuntu 9.10. Wine is configured to Windows version Windows XP. The program install ran okay, and I used winetricks to install MDAC 2.8 and JET 4.0 sp7. I also installed Microsoft's vfpoledb… >>> More
Using OLEDB parameters in .NET when connecting to an AS400/DB2

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been pulling my hair out trying to figure out what I can't get parameters to work in my query. I have the code written in VB.NET trying to do a query to an AS/400. I have IBM Access for Windows installed and I am able to get queries to work, just not with parameters. Any time I include a parameter… >>> More
How to determine MS Access field size via OleDb

as seen on Stack Overflow - Search for 'Stack Overflow'
The existing application is in C#. During startup the application calls a virtual method to make changes to the database (for example a new revision may need to calculate a new field or something). An open OleDb connection is passed into the method. I need to change a field width. The ALTER TABLE… >>> More
OleDb database to DataSet and back in c#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a program that lets a user: Connect to an (arbitrary) View all of the tables in that database in separate DataGridViews Edit them in the program, generate random data, and see the results Choose to commit those changes or revert So I discovered the DataSet class, which looks like it's… >>> More
Exception:Cannot Start your application.The Workgroup information file is missing or opened exclusiv

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We were getting this error when trying to connect to a password protected access file. This is what the connection string looked likestring conString =@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Path to your access file";User Id=;Password=password";To fix the issue this is what… >>> More

Related posts about ms-office

How to change ms office 2010 beta key

as seen on Super User - Search for 'Super User'
I have installed office 2010, using a key that I found on forums on the internet. It said it was used to many times already. But when I try to use the mak key that is on my account, it says that it is invalid. How do I change the key, if a key is still installed and is available for 30 days. >>> More
Creating the Previews of MS Office Files like word excel and PPT in cocoa

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi How can I create the preview image for MS Office files like word, excel , power point in cocoa. Can anyone suggest me on this like how to handle those file?. I tried using the Bitmap representation of the .doc files.It dint work.. Which API i can use?.. thank you.. >>> More
=rand(100,60) - MSOffice Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Oho ! Have you tried this one ?? Very simple office utility question. The question is something like this. Open Microsoft word ( 2003 or 2007 ) whatever you use. ( Let me clarify that - I am not here for any kind of advertisement of Micro soft - I want to solution to my Query ) After opening… >>> More
User (MS-Office) generated content - how?

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I allow users to share Microsoft Office generated content on an ASP.Net site? For example usage, imagine a site similar to StackOverflow. George, writing a question, uses Word, Excel or OneNote to create content, and then inserts the content into the question area (probably copying it into… >>> More
How to avoid the configuring ms office dialog box

as seen on Super User - Search for 'Super User'
I always see the configuring ms office with a an endless progress bar, 2 or more weeks after I installed ms office(2000, 2003, 2010 beta). I'm not exactly sure what it is called but it is trying to configure ms office.Or maybe repairing the installation. And it sucks because when I need to access… >>> More