Excel Oledb Engine

[Bhuvan]

--------------------------------------------------------------------------------

I'm developing .NET application which reads excel sheet information and updates the database and also writes the DB information back to the excel sheet.I have some issues in writing to the excel sheet. The excelsheet contains nearly 10 columns of datatypes: integer, text and boolean.

I'm using Oledb engine for reading and writing to the excel sheet.

Problems with Numeric values:

While writing to the excel sheet, the cells having numeric values are marked with a green triangle at the corner of the cell implying the as "the number in this column is formatted as text or preceded by an apostrophe". Even though i'm inserting the values as integer only.Why does it happens? How to solve it?

Problems with Text values:

Some of the rows may not contain values in DB.While writing to excel, the text values as follows

Int-column Text-Column Boolean-Column
123 AAA True
234 False
'432 'BBB 'True

After writing the empty column, the subsequent values in the excel cell are preceded by an apostrophe or single quoute. why does this happens?

Problem with Boolean values while reading data from excel:

While reading from excel, the boolean value(True or False) are not read. The respective cell values are Null.
Can anyone help me in solving this problem?

 

[cjard]

Whenever I've wanted to create an Excel file, I've written an XML file to disk, formatted in such a way that excel is capable of opening it. I have some code that will turn a datatable into such a file, and I've found it more reliable than using the Jet driver. Would it be something you can use?

 

[Bhuvan]

Thanks for your reply. Actually i'm looking for Excel oledb driver only.