Konst писал(а):
надо бы и пример Excel файла приложитьвот тестовый список Excel
--- Добавлено в 2016-10-04 09:26:12
список
--- Добавлено в 2016-10-04 09:38:44
тут что то со схемой выборки столбца происходит, возможно все дело пенели с СomboBox . делал выборку столбцов так
часть схемы
Add(ComboBox,9190551,707,42)
{
Left=530
Top=10
Width=160
Height=21
Font=[Arial Narrow,11,0,0,204]
WinStyle=1
Text=""
ReadOnly=0
ItemHeight=18
DropDownCount=15
BoxDrawManager="u"
Point(Index)
Point(onSelect)
Point(doSelect)
link(onClick,2006738:doEvent1,[])
}
Add(ComboBox,12976959,707,105)
{
Left=530
Top=35
Width=160
Height=21
Font=[Arial Narrow,11,0,0,204]
WinStyle=1
Text=""
ReadOnly=0
ItemHeight=18
DropDownCount=15
BoxDrawManager="u"
Point(Index)
Point(onSelect)
Point(doSelect)
link(onClick,14546244:doEvent1,[])
}
Add(ComboBox,14118439,707,168)
{
Left=530
Top=85
Width=160
Height=21
Font=[Arial Narrow,11,0,0,204]
WinStyle=1
Text=""
ReadOnly=0
ItemHeight=18
DropDownCount=15
BoxDrawManager="u"
Point(Index)
Point(onSelect)
Point(doSelect)
link(onClick,445091:doEvent1,[])
}
Add(ComboBox,16368869,707,231)
{
Left=530
Top=110
Width=160
Height=21
Font=[Arial Narrow,11,0,0,204]
WinStyle=1
Text=""
ReadOnly=0
ItemHeight=18
DropDownCount=15
BoxDrawManager="u"
Point(Index)
Point(onSelect)
Point(doSelect)
link(onClick,3555121:doEvent1,[])
}
Add(ComboBox,5801888,707,294)
{
Left=530
Top=135
Width=160
Height=21
Font=[Arial Narrow,11,0,0,204]
WinStyle=1
Text=""
ReadOnly=0
ItemHeight=18
DropDownCount=15
BoxDrawManager="u"
Point(Index)
Point(onSelect)
Point(doSelect)
link(onClick,11847291:doEvent1,[])
}
Add(ComboBox,9943641,707,357)
{
Left=530
Top=160
Width=160
Height=21
Font=[Arial Narrow,11,0,0,204]
WinStyle=1
Text=""
ReadOnly=0
ItemHeight=18
DropDownCount=15
BoxDrawManager="u"
Point(Index)
Point(onSelect)
Point(doSelect)
link(onClick,6798721:doEvent1,[])
}
Add(Edit,9240923,784,77)
{
Left=715
Top=10
Width=135
Font=[Times New Roman,10,0,0,204]
Ctl3D=1
Text="Фамилия Имя"
Point(doEnabled)
}
Add(Edit,15557466,791,140)
{
Left=715
Top=35
Width=135
Font=[Times New Roman,10,0,0,204]
Ctl3D=1
Text="Дата рождения"
Point(doEnabled)
}
Add(Edit,13834263,798,203)
{
Left=715
Top=60
Width=135
Font=[Times New Roman,10,0,0,204]
Ctl3D=1
Text="Пол"
Point(doEnabled)
}
Add(Edit,1025435,805,259)
{
Left=715
Top=85
Width=135
Font=[Times New Roman,10,0,0,204]
Ctl3D=1
Text="Тренер/Регион"
Point(doEnabled)
}
Add(Edit,10475092,819,371)
{
Left=715
Top=135
Width=135
Font=[Times New Roman,10,0,0,204]
Ctl3D=1
Text="Группа (А-Б)"
Point(doEnabled)
}
Add(Edit,12483492,826,434)
{
Left=715
Top=160
Width=135
Font=[Times New Roman,10,0,0,204]
Ctl3D=1
Text="Вид программы"
Point(doEnabled)
}
Add(ComboBox,1900216,707,420)
{
Left=530
Top=185
Width=160
Height=21
Font=[Arial Narrow,11,0,0,204]
WinStyle=1
Text=""
ReadOnly=0
ItemHeight=18
DropDownCount=15
BoxDrawManager="u"
Point(Index)
Point(onSelect)
Point(doSelect)
link(onClick,4095364:doEvent1,[])
}
Add(Edit,5507248,819,483)
{
Left=715
Top=185
Width=135
Font=[Times New Roman,10,0,0,204]
Ctl3D=1
Text="Партнер для Дуйлянь"
Point(doEnabled)
}
Add(CheckBox,1306476,868,77)
{
Left=695
Top=10
Width=15
Checked=0
Caption=""
Flat=0
}
Add(CheckBox,9996687,868,140)
{
Left=695
Top=35
Width=15
Checked=0
Caption=""
Flat=0
}
Add(CheckBox,4511359,868,203)
{
Left=695
Top=60
Width=15
Checked=0
Caption=""
Flat=0
}
Add(CheckBox,7854724,868,259)
{
Left=695
Top=85
Width=15
Checked=0
Caption=""
Flat=0
}
Add(CheckBox,16371521,868,308)
{
Left=695
Top=110
Width=15
Checked=0
Caption=""
Flat=0
}
Add(CheckBox,428583,868,371)
{
Left=695
Top=135
Width=15
Checked=0
Caption=""
Flat=0
}
Add(CheckBox,14401704,868,434)
{
Left=695
Top=160
Width=15
Checked=0
Caption=""
Flat=0
}
Add(Hub,7568766,658,476)
{
OutCount=8
link(onEvent1,9190551:doAdd,[(693,482)(693,48)])
link(onEvent2,12976959:doAdd,[(693,489)(693,111)])
link(onEvent3,14118439:doAdd,[(693,496)(693,174)])
link(onEvent4,16368869:doAdd,[(693,503)(693,237)])
link(onEvent5,5801888:doAdd,[(693,510)(693,300)])
link(onEvent6,9943641:doAdd,[(693,517)(693,363)])
link(onEvent7,1900216:doAdd,[(693,524)(693,426)])
link(onEvent8,15461858:doAdd,[(693,531)(693,496)])
}
Add(Hub,867147,658,385)
{
InCount=2
OutCount=9
link(onEvent1,9190551:doClear,[(693,391)(693,55)])
link(onEvent2,12976959:doClear,[(693,398)(693,118)])
link(onEvent3,14118439:doClear,[(693,405)(693,181)])
link(onEvent4,16368869:doClear,[(693,412)(693,244)])
link(onEvent5,5801888:doClear,[(693,419)(693,307)])
link(onEvent6,9943641:doClear,[(693,426)(693,370)])
link(onEvent7,1900216:doClear,[])
link(onEvent8,15461858:doClear,[(693,440)(693,503)])
link(onEvent9,7872250:doEvent2,[(679,447)(679,463)(636,463)(636,699)])
}
Add(FormatStr,16676898,777,651)
{
DataCount=9
Mask="%2=130\;%3=100==2\;%4=40\;%5=120\;%6=60\;%7=90\;%8=170\;%9=130"
Point(FString)
link(onFString,1089399:doEnum,[])
link(Str2,9240923:Text,[])
link(Str3,15557466:Text,[])
link(Str4,13834263:Text,[])
link(Str5,1025435:Text,[])
link(Str6,12191828:Text,[])
link(Str7,10475092:Text,[])
link(Str8,12483492:Text,[])
link(Str9,7698753:Part3,[])
}
Add(StrList,12961750,1120,651)
{
}
Add(Hub,3731093,665,623)
{
OutCount=7
link(onEvent1,12961750:doClear,[(1054,629)(1054,664)])
link(onEvent2,7754327:doClear,[(697,636)(697,573)])
link(onEvent3,7692095:doString,[(705,643)(705,559)])
link(onEvent4,13985413:doEvent1,[])
link(onEvent5,2724359:doClear,[])
link(onEvent6,2751956:doData,[(704,664)(704,741)])
link(onEvent7,12872175:doEnum,[(699,671)(699,748)])
}
Add(StrList,4165990,1036,679)
{
}
Add(ArrayEnum,12872175,1050,742)
{
link(onItem,12535587:doEvent1,[(1165,748)(1165,545)])
link(onEndEnum,12038690:doEvent1,[(1091,755)(1091,804)])
link(Array,4165990:Array,[])
}
Add(FormatStr,5551025,1211,595)
{
DataCount=9
Mask="%2;%3;%9;%4;%5;%6;%7;%8"
Point(FString)
link(Str2,2858264:Part1,[])
link(Str3,10546063:Part1,[(1231,363)(1224,363)])
link(Str4,15711505:Part1,[(1238,387)(1224,387)])
link(Str5,15186809:Part1,[(1245,425)(1224,425)])
link(Str6,7841049:Part1,[(1252,457)(1224,457)])
link(Str7,8785621:Part1,[(1259,481)(1224,481)])
link(Str8,8846148:Part1,[(1266,513)(1224,513)])
link(Str9,11780600:Part1,[(1273,541)(1224,541)])
AddHint(-6,63,148,13,Mask)
}
Add(MultiStrPart,8846148,1218,413)
{
Count=1
Point(doFrom)
}
Add(DoData,9247540,1078,427)
{
Data=Integer(0)
link(onEventData,8846148:doFrom,[])
link(Data,8140438:Var3,[(1084,411)])
}
Add(MultiStrPart,8785621,1218,350)
{
Count=1
Point(doFrom)
}
Add(DoData,9454781,1078,364)
{
Data=Integer(0)
link(onEventData,8785621:doFrom,[])
link(Data,2303222:Var3,[(1084,348)])
}
Add(MultiStrPart,7841049,1218,287)
{
Count=1
Point(doFrom)
}
Add(DoData,14120203,1078,301)
{
Data=Integer(0)
link(onEventData,7841049:doFrom,[])
link(Data,4160589:Var3,[(1084,285)])
}
Add(MultiStrPart,15186809,1218,224)
{
Count=1
Point(doFrom)
}
Add(DoData,261413,1078,238)
{
Data=Integer(0)
link(onEventData,15186809:doFrom,[])
link(Data,7467321:Var3,[(1084,222)])
}
Add(MultiStrPart,15711505,1218,161)
{
Count=1
Point(doFrom)
}
Add(DoData,11215507,1078,175)
{
Data=Integer(0)
link(onEventData,15711505:doFrom,[])
link(Data,13644517:Var3,[(1084,159)])
}
Add(MultiStrPart,10546063,1218,98)
{
Count=1
Point(doFrom)
}
Add(DoData,8235971,1078,112)
{
Data=Integer(0)
link(onEventData,10546063:doFrom,[])
link(Data,16734005:Var3,[(1084,96)])
}
Add(MultiStrPart,2858264,1218,35)
{
Count=1
Point(doFrom)
}
Add(DoData,15963495,1078,49)
{
Data=Integer(0)
link(onEventData,2858264:doFrom,[])
link(Data,6229501:Var3,[(1084,33)])
}
Add(Hub,12535587,1183,539)
{
OutCount=10
link(onEvent1,2858264:doSplit,[(1207,545)(1207,41)])
link(onEvent2,10546063:doSplit,[(1207,552)(1207,104)])
link(onEvent3,15711505:doSplit,[(1207,559)(1207,167)])
link(onEvent4,15186809:doSplit,[(1207,566)(1207,230)])
link(onEvent5,7841049:doSplit,[(1207,573)(1207,293)])
link(onEvent6,8785621:doSplit,[(1207,580)(1207,356)])
link(onEvent7,8846148:doSplit,[(1207,587)(1207,419)])
link(onEvent8,11780600:doSplit,[(1207,594)(1207,489)])
link(onEvent9,5551025:doString,[])
}
Add(BoxDrawManager,7072611,651,49)
{
Name="u"
StyleBack=1
ImageShift=1
GutterShift=1
GutterWidth=1
LightColor=15793151
DarkColor=-16777201
LightClrBack=15793151
DarkClrBack=-16777212
}
Add(Hub,3134335,1120,539)
{
InCount=9
link(onEvent2,3731093:doEvent1,[(1142,552)(1142,615)(653,615)(653,629)])
}
Add(Hub,2006738,1036,49)
{
InCount=2
link(onEvent1,15963495:doData,[])
link(onEvent2,3134335:doEvent1,[(1063,62)(1063,545)])
}
Add(Hub,14546244,1036,112)
{
InCount=2
link(onEvent1,8235971:doData,[])
link(onEvent2,3134335:doEvent2,[(1063,125)(1063,552)])
}
Add(Hub,445091,1036,175)
{
InCount=2
link(onEvent1,11215507:doData,[])
link(onEvent2,3134335:doEvent3,[(1063,188)(1063,559)])
}
Add(Hub,3555121,1036,238)
{
InCount=2
link(onEvent1,261413:doData,[])
link(onEvent2,3134335:doEvent4,[(1063,251)(1063,566)])
}
Add(Hub,11847291,1036,301)
{
InCount=2
link(onEvent1,14120203:doData,[])
link(onEvent2,3134335:doEvent5,[(1063,314)(1063,573)])
}
Add(Hub,6798721,1036,364)
{
InCount=2
link(onEvent1,9454781:doData,[])
link(onEvent2,3134335:doEvent6,[(1063,377)(1063,580)])
}
Add(Hub,4095364,1036,427)
{
InCount=2
link(onEvent1,9247540:doData,[])
link(onEvent2,3134335:doEvent7,[(1063,440)(1063,587)])
}
Add(MultiStrData,8412067,651,161)
{
Count=9
link(onPart1,9190551:doSelect,[(695,167)(695,90)])
link(onPart2,12976959:doSelect,[(695,174)(695,153)])
link(onPart3,14118439:doSelect,[(695,181)(695,216)])
link(onPart4,16368869:doSelect,[(695,188)(695,279)])
link(onPart5,5801888:doSelect,[(695,195)(695,342)])
link(onPart6,9943641:doSelect,[(695,202)(695,405)])
link(onPart7,1900216:doSelect,[(695,209)(695,468)])
link(onPart8,15461858:doSelect,[(695,216)(695,538)])
}
Add(FormatStr,7692095,917,553)
{
DataCount=9
Mask="%2;%3;%4;%5;%6;%7;%8;%9"
Point(FString)
link(Str2,6229501:Var2,[])
link(Str3,16734005:Var2,[])
link(Str4,13644517:Var2,[])
link(Str5,7467321:Var2,[])
link(Str6,4160589:Var2,[])
link(Str7,2303222:Var2,[])
link(Str8,8140438:Var2,[])
link(Str9,11930704:Var2,[])
}
Add(GetDataEx,6229501,924,28)
{
Angle=3
link(Data,9190551:Index,[(762,33)(762,99)(727,99)])
}
Add(GetDataEx,16734005,931,91)
{
Angle=3
link(Data,12976959:Index,[(762,96)(762,163)(727,163)])
}
Add(GetDataEx,13644517,938,154)
{
Angle=3
link(Data,14118439:Index,[(762,159)(762,228)(727,228)])
}
Add(GetDataEx,7467321,945,217)
{
Angle=3
link(Data,16368869:Index,[(762,222)(762,295)(727,295)])
}
Add(GetDataEx,4160589,952,280)
{
Angle=3
link(Data,5801888:Index,[(762,285)(762,353)(727,353)])
}
Add(GetDataEx,2303222,959,343)
{
Angle=3
link(Data,9943641:Index,[(762,348)(762,417)(727,417)])
}
Add(GetDataEx,8140438,966,406)
{
Angle=3
link(Data,1900216:Index,[(762,411)(762,478)(727,478)])
}
Add(Hub,9936957,994,539)
{
InCount=2
OutCount=9
link(onEvent1,2006738:doEvent2,[(1019,545)(1019,62)])
link(onEvent2,14546244:doEvent2,[(1019,552)(1019,125)])
link(onEvent3,445091:doEvent2,[(1019,559)(1019,188)])
link(onEvent4,3555121:doEvent2,[(1019,566)(1019,251)])
link(onEvent5,11847291:doEvent2,[(1019,573)(1019,314)])
link(onEvent6,6798721:doEvent2,[(1019,580)(1019,377)])
link(onEvent7,4095364:doEvent2,[(1019,587)(1019,440)])
link(onEvent8,13096878:doEvent2,[(1019,594)(1019,510)])
}
Add(Str_Enum,1089399,861,651)
{
link(onEnum,11183150:doReplace,[])
}
Add(Replace,15695488,994,651)
{
SubStr="\"
DestStr=";"
link(onReplace,12961750:doAdd,[])
}
Add(MST_Clear,7754327,707,567)
{
ClearAll=0
MSTControl="rrt"
}
Add(DoData,2751956,1120,735)
{
link(Data,12961750:Text,[])
}
Add(MST_Clear,2724359,707,651)
{
MSTControl="rrt"
}
Add(Hub,7872250,665,686)
{
InCount=2
OutCount=1
link(onEvent1,4165990:doClear,[])
}
Add(ComboBox,15461858,707,490)
{
Left=530
Top=60
Width=160
Height=21
Font=[Arial Narrow,11,0,0,204]
WinStyle=1
Text=""
ReadOnly=0
ItemHeight=18
DropDownCount=15
BoxDrawManager="u"
Point(Index)
Point(onSelect)
Point(doSelect)
link(onClick,13096878:doEvent1,[])
}
Add(DoData,4057761,1085,497)
{
Data=Integer(0)
link(onEventData,11780600:doFrom,[])
link(Data,11930704:Var1,[(1091,464)(979,464)])
}
Add(Hub,13096878,1036,497)
{
InCount=2
link(onEvent1,4057761:doData,[])
link(onEvent2,3134335:doEvent8,[(1063,510)(1063,594)])
}
Add(GetDataEx,11930704,973,469)
{
Angle=3
link(Data,15461858:Index,[(762,474)(762,552)(727,552)])
}
Add(MultiStrPart,11780600,1218,483)
{
Count=1
Point(doFrom)
}
Add(Edit,12191828,812,308)
{
Left=715
Top=110
Width=135
Font=[Times New Roman,10,0,0,204]
Ctl3D=1
Text="Разряд"
Point(doEnabled)
}
Add(MultiStrPart,7698753,819,560)
{
Char=" "
Count=3
link(Str,5507248:Text,[])
}
Add(Hub,13985413,749,644)
{
link(onEvent1,7698753:doSplit,[(772,650)(772,566)])
link(onEvent2,16676898:doString,[])
}
Add(CheckBox,3555934,868,483)
{
Left=695
Top=185
Width=15
Checked=0
Caption=""
Flat=0
}
Add(LineBreak,4247421,1253,1029)
{
Primary=[9641064,-14,-231]
}
Add(DoData,11410136,1134,798)
{
Data=String(CTRL + вверх / вниз ----> перемещение строк)
link(onEventData,9641064:In,[])
}
Add(LineBreak,4340443,1253,931)
{
Primary=[8331133,-14,-91]
}
Add(DoData,10084272,1190,840)
{
link(onEventData,8331133:In,[])
link(Data,1330640:Text,[])
}
Add(Hub,12038690,1099,798)
{
link(onEvent1,11410136:doData,[])
link(onEvent2,2038624:doTimer,[(1123,811)(1123,846)])
}
Add(Timer,2038624,1134,840)
{
Interval=5000
Enable=1
AutoStop=1
link(onTimer,10084272:doData,[])
}
Add(StrList,1330640,1190,749)
{
Strings=#39:Внимательно проверьте список участников|
}
Add(Replace,11183150,924,651)
{
SubStr="."
DestStr="-"
link(onReplace,15695488:doReplace,[])
}
немного сложно, но все получалось