Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change Excel cell types from label to value
#2
Yes, changing cell format does not work. Also need to reenter cells. Using COM it would be

Code:
Copy      Help
ExcelSheet es.Init
Excel.Range ra=es.ws.Application.Selection
ra.NumberFormat="General"
ARRAY(VARIANT) a
a=ra.Value
ra.Value=a

Using copy/paste
str s
s.getsel
s.setsel
key ...


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)