Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Excel '07 Questions | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Excel/VBA Questions | Excel Programming |