Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Current in the excel input to htm text
#1
Always appreciate the help.

Text input in the Excel Sheet
1. A1 B1 C1 D1 Cell input
2. A2 move
3, A2 B2 C2 D2 Cell input
3. A3 move

A B C D
1 apl dpl ra gd >> After input next cell move
2 |
3

Code:
Copy      Help
int IEFrame = win("" "IEFrame")
Htm title=htm("TD" "" "[]<TD width=261 align=left>" IEFrame "1" 31 0x28 3)
Htm number=htm("TD" "" "<TD style=''PADDING-LEFT: 10px'' " IEFrame "1" 23 0x28 3)
Htm diskfr=htm("TD" "" "[]<TD>" IEFrame "1" 28 0x28 3)
Htm UID=htm("A" "" "<A onfocus=blur() href=" IEFrame "1" 1 0x0 3)

str text=title.Text
str text1=number.Text
str text2=diskfr.Text
str text3=UID.Text

out text.trim(" "); out text1.trim(" "); out text2.trim(" "); out text3.trim(" ")

ExcelSheet es.Init
    es.SetCell(text 1 1); es.SetCell(text1 2 1); es.SetCell(text2 3 1); es.SetCell(text3 4 1)
    es.SelectCell(1 2)
#2
key (text) T (text1) T (text2) T (text3) Y

or

Macro Macro2431
Code:
Copy      Help
ExcelSheet es.Init
int row
es.GetRangeInfo("<sel>" 0 row)
es.SetCell(text 1 row); es.SetCell(text1 2 row); es.SetCell(text2 3 row); es.SetCell(text3 4 row)
es.SelectCell(1 row+1)
#3
Thankyou very much!! Big GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig GrinBig Grin


Forum Jump:


Users browsing this thread: 1 Guest(s)