Excel Formating questions
 

Few of questions
1) I have an embedded device pumping time data in excel using a format like
xxxUS, xxxMS, & xxxKS. How can I format the cells to understand the data as
numbers so I can plot it. Right now excel interprets it as text, I have
tried different cell formatting but no luck.

2) I am adding the above data from a VBScript using format like
objXL.Cells(x, y).Value = timedata. Is there a shortcut way from VBScript to
specify something like Sheet!Row:Column=Data in one shot.

3) The data comes from embedded device in a format like
"\$Excel\~Sheet\~Row\~Col\~Data\$". I am using regexp with a pattern
"\\\$|\\~" to parse it in subcomponents. Is there a .Net equivalent to
..Split() in vbscript to create a collection of subcomponents.


Thanks

Excel Formating questions
 

if your data was in a 2D array arrTimeData(1 x N, 1 x 1) you could do

ObjXl(cells(x,y).Resize(N,1).value = arrTimeData


I think you would have to remove the text from the end and just have numbers
in your array to get excel to see it as time. Time is stored as a fraction
of a 24 hour day, so 6 hours would be .25 (1/4th of a day).

--
Regards,
Tom Ogilvy


"Mr. NDIS" wrote in message
...
Few of questions
1) I have an embedded device pumping time data in excel using a format
like
xxxUS, xxxMS, & xxxKS. How can I format the cells to understand the data
as
numbers so I can plot it. Right now excel interprets it as text, I have
tried different cell formatting but no luck.

2) I am adding the above data from a VBScript using format like
objXL.Cells(x, y).Value = timedata. Is there a shortcut way from VBScript
to
specify something like Sheet!Row:Column=Data in one shot.

3) The data comes from embedded device in a format like
"\$Excel\~Sheet\~Row\~Col\~Data\$". I am using regexp with a pattern
"\\\$|\\~" to parse it in subcomponents. Is there a .Net equivalent to
.Split() in vbscript to create a collection of subcomponents.


Thanks