Click here to Skip to main content
16,010,334 members
Home / Discussions / C#
   

C#

 
QuestionConsuming java written webservices without adding reference in c# Pin
k23-Aug-09 20:19
k23-Aug-09 20:19 
AnswerRe: Consuming java written webservices without adding reference in c# Pin
Christian Graus23-Aug-09 21:29
protectorChristian Graus23-Aug-09 21:29 
QuestionFax Protocol , how to test Pin
ran923-Aug-09 20:11
ran923-Aug-09 20:11 
Questionretrieving values from datareader Pin
myinstincts23-Aug-09 19:48
myinstincts23-Aug-09 19:48 
AnswerRe: retrieving values from datareader Pin
N a v a n e e t h23-Aug-09 20:03
N a v a n e e t h23-Aug-09 20:03 
QuestionHow to make a button circular in shape? Pin
CoderForEver23-Aug-09 19:47
CoderForEver23-Aug-09 19:47 
AnswerRe: How to make a button circular in shape? Pin
stancrm23-Aug-09 20:49
stancrm23-Aug-09 20:49 
Questionc# excel date issue Pin
Suunil23-Aug-09 19:32
Suunil23-Aug-09 19:32 
Hi ..
I am stuck with issue & don’t seem to find a way around.

I have an excel sheet which I am reading in my C# windows application . I read values form F column to V column. I collect this in a string array & then display the values of the array to user.
The problem is in differentiating the dates & the number values .. here is the problem I faced:
I have 2 cells ..1st one has value 40524 & the 2nd has 12/12/2010. When I get the values both of them are returned as 40524 !! So how do you determine programmatically which cell actually was meant for numbers & which was for date because if I have to display the contents of a row (without knowing the format) I want to show 12/12/2010 as 12/12/2010 & not as 40524.

I am using the following code to get values from Excel

Range vrange = worksheet.get_Range("F" + i.ToString(), "V" + i.ToString());
System.Array vmyvalues = (System.Array)vrange.Cells.Value2;
string [] ret = ConvertToStringArray(vmyvalues);


As you can see i am getting values from column F to V & when I iterate through the above string array "ret" I can see the value as of 12/12/2010 as 40524 where as I need it as is shown by excel

Thanks for help.
Suunil
AnswerRe: c# excel date issue Pin
Mycroft Holmes23-Aug-09 19:38
professionalMycroft Holmes23-Aug-09 19:38 
GeneralRe: c# excel date issue Pin
Suunil23-Aug-09 19:41
Suunil23-Aug-09 19:41 
GeneralRe: c# excel date issue Pin
Mycroft Holmes23-Aug-09 21:21
professionalMycroft Holmes23-Aug-09 21:21 
QuestionRight to Left Comments Pin
cppwxwidgetsss23-Aug-09 19:10
cppwxwidgetsss23-Aug-09 19:10 
Questionapp.config Pin
Member 432709623-Aug-09 18:15
Member 432709623-Aug-09 18:15 
QuestionBindingList<t> - FindCore - What am I doing wrong?</t> Pin
Gilliann23-Aug-09 15:59
Gilliann23-Aug-09 15:59 
AnswerRe: BindingList - FindCore - What am I doing wrong? Pin
dan!sh 23-Aug-09 18:50
professional dan!sh 23-Aug-09 18:50 
GeneralRe: BindingList - FindCore - What am I doing wrong? Pin
Gilliann24-Aug-09 2:40
Gilliann24-Aug-09 2:40 
QuestionHow to load data from db to combobox? Pin
misCafe23-Aug-09 15:35
misCafe23-Aug-09 15:35 
AnswerRe: How to load data from db to combobox? Pin
Christian Graus23-Aug-09 16:18
protectorChristian Graus23-Aug-09 16:18 
GeneralRe: How to load data from db to combobox? Pin
misCafe23-Aug-09 20:11
misCafe23-Aug-09 20:11 
GeneralRe: How to load data from db to combobox? Pin
tamir1017-Sep-09 19:56
tamir1017-Sep-09 19:56 
QuestionNon-click through transparency C# Pin
Xmen Real 23-Aug-09 14:43
professional Xmen Real 23-Aug-09 14:43 
QuestionC# Class Library - How do I make my class interop and registerable? Pin
densher23-Aug-09 8:56
densher23-Aug-09 8:56 
AnswerRe: C# Class Library - How do I make my class interop and registerable? Pin
stancrm23-Aug-09 9:08
stancrm23-Aug-09 9:08 
AnswerRe: C# Class Library - How do I make my class interop and registerable? Pin
densher23-Aug-09 13:41
densher23-Aug-09 13:41 
GeneralRe: C# Class Library - How do I make my class interop and registerable? Pin
Luc Pattyn23-Aug-09 14:00
sitebuilderLuc Pattyn23-Aug-09 14:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.