PC Review


Reply
Thread Tools Rate Thread

Automatic type conversion prblm when populating Excel sheet from C

 
 
=?Utf-8?B?QXRsZUg=?=
Guest
Posts: n/a
 
      14th Dec 2006
Hi,

I am using the technique described in this article:

http://support.microsoft.com/kb/306023/

to populate a range in Excel from an array of values in C# (technique no 2
in document). The only difference between my solution and the code example in
the document is that I use an array of Object instead of an array of double
(but I populate this array with both String and Double objects).

The problem is that I run into some automatic type conversion in Excel based
on the actual values in the array. To be more specific, some of the double
values are displayed as dates in Excel.

Any suggestions on how to get around this problem?

AtleH


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Type Conversion Error on Importing Excel S/sheet Chris Gorham Microsoft Access VBA Modules 1 29th Jul 2008 08:07 PM
Automatic data conversion in Excel =?Utf-8?B?RGVqYW4=?= Microsoft Excel Misc 2 26th Jul 2005 09:22 PM
COUNTIF and automatic type conversion problem joes Microsoft Excel Misc 2 25th Jul 2005 03:26 PM
COUNTIF and automatic type conversion problem joes Microsoft Excel Worksheet Functions 2 25th Jul 2005 03:26 PM
US To Euros automatic conversion in excel Tafari Microsoft Excel Misc 1 6th Oct 2003 06:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:17 PM.