Excel's spooky behaviour (OWC Question)

  • Thread starter Thread starter pontifikas
  • Start date Start date
P

pontifikas

The Main Question
Where Can I find the Class Documentation for OWC(Office Web
Components)?
I want to find how to tell to an Excel column to accept specific data
types of input values.

[b:ffd9a7a328]The Story Behind[/b:ffd9a7a328]
I'm using OWC to extract a DataTable or a C1.FlexGrid to Excel.

When I import the data I know what their data type is. So I use the
appropriate 'Convert.to_" statement.

i.e MyExcel.ActiveSh(i)eet.Cells = Convet.toDouble(dr);
(dr = datarow of the data table)

While the majority of the data gets copied to the Excel correctly(in
the same column), there are some specific inputs whose value change
when extracted to Excel.As a result,
String inputs appears as ... dates. For example "Olympiakos-FC"
becomes
"12/3/3029".

I 've deduced that the specific column tends to accept Date inputs.So
if a string can somehow be translated to date(doono, maybe it makes
it an Int and then cosiders this Int as a day count).

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
 
nope! That didnt work :?

BTW, what does the '@' infront of a variable implies??(yes I'm new to
C#)

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
 
Back
Top