Excel sayfasına internetten veri almak

A

akdir

Katılım
21 Şubat 2008
Mesajlar
42
Excel Vers. ve Dili
Türkçe
arkadaşlar hepinize iyi günler. Ben excel de bir proğram yapmaya çalışıyorum. bunun içinde 2 web sayfasından düzenli olarak veri almam gerekiyor. bir tanesini ayarladım o siteden düzenli olarak veri akışını sağlıyorum ama diğer siteden tüm ayarları yapmamağa rağmen "BU WEB SORGUSU HİÇBİR VERİ DÖNDÜREMEDİ. SORGUYU DEĞİŞTİRMEK İÇİN TAMAMI TIKLAYIN ......" gibi mesaj geliyor ve veri alamıyorum.
bu konuda bana yardımcı olursanız sevinirim teşekkürler.
 
N

Necdet

Moderatör
Yönetici
Katılım
4 Haziran 2005
Mesajlar
15,371
Excel Vers. ve Dili
Ofis 365 Türkçe
e yani.

web sayfasından veri alma konusunda çok arkadaşım uzman.

Ama bu sorunu dile getirirken web adreslerini de verseydiniz de arkadaşlarımız ilgilense idi.

dimi yani sarı çizmeli memed ağa.
 
A

akdir

Katılım
21 Şubat 2008
Mesajlar
42
Excel Vers. ve Dili
Türkçe
necdet bey ben bu soruyu yazarken sizinde belirttiğiniz gibi web sayfasından veri alma konusunda çok arkadaşım vardır bu çok uzman arkadaşlarımızın başına benim yaşadığım gibi bir sıkıntı nasıl olsa gelmiştir diye düşündüğüm için sayfanın adını yazma gereği duymadım.
ama yinede siteyi yazayım http://1x2.7m.cn/default_en.shtml
şimdiden teşekkürler
 
H

Haluk

Özel Üye
Katılım
7 Temmuz 2004
Mesajlar
12,406
Excel Vers. ve Dili
64 Bit 2010 - İngilizce
+
Google Sheets
+
JScript
Altın Üyelik Bitiş Tarihi
∞
Verdiğiniz linkte yer alan sayfanın yapısı klasik HTML sayfaları gibi hazırlanmamış.

Yani, sayfanın gövdesinde table, tr, td ... gibi DOM nesneleri yok. Bunun yerine, sayfa daha yüklenmeden "Head" kısmındaki JavaScriptlerle sayfa içeriği dinamik olarak hazırlanıyor.

Örneğin, sözkonusu sunucu üzerindeki bu işi yapan com_en.js scritinde yer alan dizilerde gerekli datalar var ve bunlar DOM'a yazdırılıyor.

Sözkonusu scriptteki dizi ve elemanları şu şekilde; (Bunun gibi birtakım scriptler daha var...)

Kod: 
var arrCOMPANY = new Array();
arrCOMPANY[1] = ['10BET','England',''];
arrCOMPANY[2] = ['176bet','',''];
arrCOMPANY[253] = ['188bet','',''];
arrCOMPANY[3] = ['24hBET','Sweden',''];
arrCOMPANY[4] = ['24hPoker','Sweden',''];
arrCOMPANY[285] = ['2BetOnline','England',''];
arrCOMPANY[5] = ['3bwin','',''];
arrCOMPANY[6] = ['5 Dimes','Costa Rica',''];
arrCOMPANY[286] = ['AA-in','',''];
arrCOMPANY[7] = ['Admiral','Austria',''];
arrCOMPANY[8] = ['Aebet','Honduras',''];
arrCOMPANY[9] = ['AnyBets','',''];
arrCOMPANY[275] = ['AscotSports','',''];
arrCOMPANY[10] = ['Asianodds.com','',''];
arrCOMPANY[11] = ['Astrabet','',''];
arrCOMPANY[12] = ['At Home','',''];
arrCOMPANY[13] = ['Back2Bet','England',''];
arrCOMPANY[266] = ['bc080','',''];
arrCOMPANY[287] = ['bc080.com','',''];
arrCOMPANY[14] = ['BestSportWorld','England',''];
arrCOMPANY[15] = ['Bet','England',''];
arrCOMPANY[16] = ['BET 1128','',''];
arrCOMPANY[17] = ['Bet 365','England',''];
arrCOMPANY[18] = ['Bet Jamaica','',''];
arrCOMPANY[19] = ['BET on USA','West Indies',''];
arrCOMPANY[21] = ['Bet19.com','',''];
arrCOMPANY[22] = ['Bet24','Denmark',''];
arrCOMPANY[309] = ['Bet3000','',''];
arrCOMPANY[23] = ['Betabet','England',''];
arrCOMPANY[24] = ['Betako','',''];
arrCOMPANY[25] = ['betandgame','',''];
arrCOMPANY[26] = ['Betandwin','Austria',''];
arrCOMPANY[27] = ['Bet-at-home.com','Austria',''];
arrCOMPANY[28] = ['betbull','',''];
arrCOMPANY[304] = ['Betchance','',''];
arrCOMPANY[276] = ['Betchoice','',''];
arrCOMPANY[29] = ['BetClass','Malta',''];
arrCOMPANY[30] = ['BetClick','',''];
arrCOMPANY[31] = ['BETCOM','Costa Rica',''];
arrCOMPANY[32] = ['BETCRIS','Costa Rica',''];
arrCOMPANY[33] = ['BETDAQ','Ireland',''];
arrCOMPANY[34] = ['BetDirect','England',''];
arrCOMPANY[35] = ['BetEuro','England',''];
arrCOMPANY[36] = ['Beteurope','',''];
arrCOMPANY[37] = ['Betfair','England',''];
arrCOMPANY[38] = ['Betfred','',''];
arrCOMPANY[39] = ['BetGameDay','Antilles',''];
arrCOMPANY[40] = ['betgrande.com','',''];
arrCOMPANY[261] = ['BetGun.com','',''];
arrCOMPANY[41] = ['Betinternet','England',''];
arrCOMPANY[42] = ['Betmaker','Costa Rica',''];
arrCOMPANY[43] = ['betoddoreven','England',''];
arrCOMPANY[44] = ['BetOnBet','England',''];
arrCOMPANY[45] = ['BetOnGames','Antilles',''];
arrCOMPANY[46] = ['betoto.com','Gibraltar',''];
arrCOMPANY[47] = ['BetRoyal','Antilles',''];
arrCOMPANY[48] = ['Bets4all.com','Austria',''];
arrCOMPANY[49] = ['Betsafe','',''];
arrCOMPANY[50] = ['BetSense.com','England',''];
arrCOMPANY[51] = ['Betshop','England',''];
arrCOMPANY[53] = ['Betsson','England',''];
arrCOMPANY[288] = ['Betsson Exchang','',''];
arrCOMPANY[52] = ['Betsson Sportsbook','',''];
arrCOMPANY[54] = ['Betstar','',''];
arrCOMPANY[55] = ['betSuperbet','',''];
arrCOMPANY[271] = ['betterbet','',''];
arrCOMPANY[272] = ['bettingstar24.com','',''];
arrCOMPANY[312] = ['BetUS','',''];
arrCOMPANY[56] = ['Betway','',''];
arrCOMPANY[20] = ['BetWin','Austria',''];
arrCOMPANY[57] = ['BetWWTS','',''];
arrCOMPANY[58] = ['BetXC','Lithuania',''];
arrCOMPANY[59] = ['Betzone.com','Holland',''];
arrCOMPANY[60] = ['Bill Hurley','Australia',''];
arrCOMPANY[61] = ['BINGOAL','Holland',''];
arrCOMPANY[62] = ['Blue Square','England',''];
arrCOMPANY[63] = ['BoDog','Costa Rica',''];
arrCOMPANY[269] = ['Bookmaker.com','',''];
arrCOMPANY[64] = ['Bowman','England',''];
arrCOMPANY[65] = ['Boylesports','Ireland',''];
arrCOMPANY[66] = ['bwin','',''];
arrCOMPANY[67] = ['Canbet','England',''];
arrCOMPANY[68] = ['Capital Sports','England',''];
arrCOMPANY[69] = ['CaribSports','Honduras',''];
arrCOMPANY[70] = ['Cash Point','Austria',''];
arrCOMPANY[71] = ['CBM Bookmakers','England',''];
arrCOMPANY[72] = ['Centrebet','Australia',''];
arrCOMPANY[73] = ['Certbet','Austria',''];
arrCOMPANY[74] = ['Chance','Czech',''];
arrCOMPANY[75] = ['ciaobet.com','Malta',''];
arrCOMPANY[76] = ['cnnbest.com','',''];
arrCOMPANY[77] = ['com-bet.com','Austria',''];
arrCOMPANY[314] = ['Completesportsbetting','',''];
arrCOMPANY[78] = ['Coral','England',''];
arrCOMPANY[79] = ['cp080.com','',''];
arrCOMPANY[308] = ['Crown','',''];
arrCOMPANY[80] = ['Cybersportsbook','',''];
arrCOMPANY[81] = ['Dansk Tipstjeneste','Denmark',''];
arrCOMPANY[82] = ['Davidson','Australia',''];
arrCOMPANY[83] = ['Denmark','Denmark',''];
arrCOMPANY[267] = ['derby-games.com','',''];
arrCOMPANY[311] = ['dialabet','',''];
arrCOMPANY[84] = ['Diamond Sportsbook','',''];
arrCOMPANY[259] = ['Digibet','',''];
arrCOMPANY[85] = ['dimeplayer.com','',''];
arrCOMPANY[86] = ['Domebet','',''];
arrCOMPANY[300] = ['dorobet','',''];
arrCOMPANY[87] = ['Doxx','Slovakia',''];
arrCOMPANY[316] = ['Doxxbet','',''];
arrCOMPANY[257] = ['Easybets','',''];
arrCOMPANY[88] = ['eb248','',''];
arrCOMPANY[89] = ['Eurobet','England',''];
arrCOMPANY[277] = ['Eurobet.it','',''];
arrCOMPANY[90] = ['Europlay','Austria',''];
arrCOMPANY[91] = ['EuroSportwetten','Austria',''];
arrCOMPANY[92] = ['Eurotip','England',''];
arrCOMPANY[93] = ['Expekt','England',''];
arrCOMPANY[94] = ['Favorit','Croatia',''];
arrCOMPANY[95] = ['Fonbet','Russia',''];
arrCOMPANY[96] = ['Formula','Slovakia',''];
arrCOMPANY[97] = ['Fortuna','Canada',''];
arrCOMPANY[98] = ['Francaise des jeux','',''];
arrCOMPANY[99] = ['Galaxy Betting','',''];
arrCOMPANY[100] = ['game2bet.com','',''];
arrCOMPANY[102] = ['gamebookers','Antigua and Barbuda',''];
arrCOMPANY[101] = ['Gamebookers Italia','',''];
arrCOMPANY[103] = ['GameDay','Holland',''];
arrCOMPANY[104] = ['Gameshold','',''];
arrCOMPANY[105] = ['Gaming Club','',''];
arrCOMPANY[106] = ['Global','',''];
arrCOMPANY[107] = ['Global Sportsbet','Australia',''];
arrCOMPANY[108] = ['Globet','England',''];
arrCOMPANY[109] = ['GoldBet','Austria',''];
arrCOMPANY[270] = ['Greekbet','',''];
arrCOMPANY[110] = ['GS Network','',''];
arrCOMPANY[111] = ['GWbet','Austria',''];
arrCOMPANY[305] = ['He Dui','British Virgin Islands',''];
arrCOMPANY[112] = ['Hititbet','Turkey',''];
arrCOMPANY[113] = ['HK Jockey Club','Hong Kong',''];
arrCOMPANY[114] = ['Hollywood','USA',''];
arrCOMPANY[115] = ['Hooball','',''];
arrCOMPANY[116] = ['IASbet','Australia',''];
arrCOMPANY[117] = ['IBCBET','',''];
arrCOMPANY[118] = ['Iceland','Iceland',''];
arrCOMPANY[119] = ['Iconbet','',''];
arrCOMPANY[120] = ['Interaction','',''];
arrCOMPANY[121] = ['Internet1x2','Honduras',''];
arrCOMPANY[122] = ['Intertops','West Indies',''];
arrCOMPANY[123] = ['Interwetten','Cyprus',''];
arrCOMPANY[124] = ['Islenskar Getraunir','Iceland',''];
arrCOMPANY[302] = ['Jaxx','',''];
arrCOMPANY[299] = ['Jazz','',''];
arrCOMPANY[125] = ['Jokerbets','Austria',''];
arrCOMPANY[126] = ['jp1388.com','',''];
arrCOMPANY[254] = ['Ladbrokes','England',''];
arrCOMPANY[298] = ['Ladbrokes.com(lad168.com)','',''];
arrCOMPANY[318] = ['Lasseters','','http://www.lasseters.com.au'];
arrCOMPANY[127] = ['LevelBet','',''];
arrCOMPANY[128] = ['LinesMaker','England',''];
arrCOMPANY[129] = ['Littlewoods','England',''];
arrCOMPANY[250] = ['Macauslot','Macao',''];
arrCOMPANY[297] = ['Mansion Exchang','',''];
arrCOMPANY[131] = ['Mansion Exchange','',''];
arrCOMPANY[130] = ['Mansion Sportsbook','',''];
arrCOMPANY[262] = ['Mansion88','',''];
arrCOMPANY[296] = ['Mansion88.com','',''];
arrCOMPANY[132] = ['matchbook','',''];
arrCOMPANY[278] = ['MatchMyWager','',''];
arrCOMPANY[133] = ['Maxi-tip','Czech',''];
arrCOMPANY[134] = ['Mediabet','Germany',''];
arrCOMPANY[279] = ['Megasportsworld','',''];
arrCOMPANY[263] = ['MeridianBet','',''];
arrCOMPANY[135] = ['Milenium','',''];
arrCOMPANY[301] = ['Ming Sheng','',''];
arrCOMPANY[310] = ['Mozzart','',''];
arrCOMPANY[136] = ['MrBookmaker','Malta',''];
arrCOMPANY[137] = ['Multibet','Australia',''];
arrCOMPANY[138] = ['myBet.com','',''];
arrCOMPANY[139] = ['Nike','Ireland',''];
arrCOMPANY[140] = ['nn-new.com','',''];
arrCOMPANY[141] = ['Nordicbet','Costa Rica',''];
arrCOMPANY[142] = ['Norsk Tipping','Norway',''];
arrCOMPANY[143] = ['Norway','Norway',''];
arrCOMPANY[144] = ['odds4you','Gibraltar',''];
arrCOMPANY[315] = ['Oddscompany','',''];
arrCOMPANY[145] = ['Oddset','Germany',''];
arrCOMPANY[295] = ['Oddset.de','Germany',''];
arrCOMPANY[146] = ['Olympic Sports','Jamaica',''];
arrCOMPANY[147] = ['OmniBet','',''];
arrCOMPANY[148] = ['Paddy Power','Ireland',''];
arrCOMPANY[149] = ['PAF','',''];
arrCOMPANY[150] = ['Paradisebet.com','England',''];
arrCOMPANY[151] = ['Parbet','England',''];
arrCOMPANY[152] = ['Parier','',''];
arrCOMPANY[264] = ['PartyBets','',''];
arrCOMPANY[153] = ['PasarBola','USA',''];
arrCOMPANY[294] = ['Petica Plus','',''];
arrCOMPANY[293] = ['Pianeta Scommes','',''];
arrCOMPANY[154] = ['Pianeta Scommesse','',''];
arrCOMPANY[155] = ['Pinnacle Reduced','',''];
arrCOMPANY[156] = ['Pinnacle Sports','Holland',''];
arrCOMPANY[157] = ['Playit.com','England',''];
arrCOMPANY[252] = ['PointBet','Singapore',''];
arrCOMPANY[292] = ['Portlandbet','',''];
arrCOMPANY[158] = ['Premierbet','England',''];
arrCOMPANY[159] = ['Primebet','Malta',''];
arrCOMPANY[160] = ['Profesjonal','',''];
arrCOMPANY[282] = ['Proline','',''];
arrCOMPANY[161] = ['PWsport','',''];
arrCOMPANY[162] = ['RaceBook.com','',''];
arrCOMPANY[163] = ['Redbet','England',''];
arrCOMPANY[164] = ['Regency','',''];
arrCOMPANY[165] = ['Reno 2000','',''];
arrCOMPANY[166] = ['Royal Sports','',''];
arrCOMPANY[167] = ['s195','',''];
arrCOMPANY[168] = ['S456','',''];
arrCOMPANY[169] = ['Sazka','Czech',''];
arrCOMPANY[170] = ['sb1888.com','',''];
arrCOMPANY[281] = ['SBG Global','',''];
arrCOMPANY[171] = ['sbo8.com','',''];
arrCOMPANY[172] = ['sbobet.com','',''];
arrCOMPANY[173] = ['Scandic Bookmakers','England',''];
arrCOMPANY[174] = ['Schwechat','Austria',''];
arrCOMPANY[175] = ['ScommesseAndromeda','',''];
arrCOMPANY[176] = ['Set2Go','Gibraltar',''];
arrCOMPANY[177] = ['Simon Beasley','',''];
arrCOMPANY[178] = ['Singapore Pools','Singapore',''];
arrCOMPANY[265] = ['Singbet','',''];
arrCOMPANY[179] = ['singbet3.com','',''];
arrCOMPANY[303] = ['SkandiaBet','',''];
arrCOMPANY[180] = ['skybet','England',''];
arrCOMPANY[181] = ['Skyline','',''];
arrCOMPANY[182] = ['SNAI','Italy',''];
arrCOMPANY[183] = ['SportBet','',''];
arrCOMPANY[184] = ['Sportfanatik','Costa Rica',''];
arrCOMPANY[185] = ['Sporting','',''];
arrCOMPANY[251] = ['Sportingbet','',''];
arrCOMPANY[307] = ['sportingbet.com.au','',''];
arrCOMPANY[187] = ['SportingbetUSA','Costa Rica',''];
arrCOMPANY[186] = ['SportingOdds','England',''];
arrCOMPANY[188] = ['Sportna loterija','Slovenia',''];
arrCOMPANY[189] = ['SportOdds','Australia',''];
arrCOMPANY[306] = ['Sports Acumen','',''];
arrCOMPANY[190] = ['Sports.com','',''];
arrCOMPANY[191] = ['Sportsbet','Australia',''];
arrCOMPANY[192] = ['Sportsbetting','',''];
arrCOMPANY[193] = ['Sportsbook.com','',''];
arrCOMPANY[194] = ['SPORTSinteraction','Canada',''];
arrCOMPANY[195] = ['SportsTAB','Australia',''];
arrCOMPANY[196] = ['Sportwetten Gera','',''];
arrCOMPANY[197] = ['SSP','England',''];
arrCOMPANY[198] = ['Stan James','Gibraltar',''];
arrCOMPANY[199] = ['Stanleybet','Malta',''];
arrCOMPANY[313] = ['Starbet','',''];
arrCOMPANY[200] = ['StarPrice','Austria',''];
arrCOMPANY[201] = ['stepscommesse','',''];
arrCOMPANY[202] = ['Strike','',''];
arrCOMPANY[203] = ['STS','Poland',''];
arrCOMPANY[273] = ['Sunderlands','',''];
arrCOMPANY[289] = ['Super268','',''];
arrCOMPANY[204] = ['Superbook','',''];
arrCOMPANY[205] = ['SuperOdds','',''];
arrCOMPANY[206] = ['Supporterbet','',''];
arrCOMPANY[207] = ['Svenska Spel','',''];
arrCOMPANY[208] = ['Swapbets','Gibraltar',''];
arrCOMPANY[209] = ['Sweden','Sweden',''];
arrCOMPANY[210] = ['Synot TIP','Czech',''];
arrCOMPANY[211] = ['Teletip','Czech',''];
arrCOMPANY[212] = ['Terno','Slovakia',''];
arrCOMPANY[213] = ['theBet.cc','Austria',''];
arrCOMPANY[228] = ['TheBetArena','',''];
arrCOMPANY[214] = ['TIP','Slovakia',''];
arrCOMPANY[291] = ['Tip Kurz','',''];
arrCOMPANY[260] = ['Tipico','',''];
arrCOMPANY[215] = ['TipKurz','',''];
arrCOMPANY[216] = ['Tipsport','Czech',''];
arrCOMPANY[284] = ['Tipsport-Sk','',''];
arrCOMPANY[217] = ['Toals','',''];
arrCOMPANY[218] = ['ToBo','',''];
arrCOMPANY[219] = ['topcil','',''];
arrCOMPANY[283] = ['TopSport','',''];
arrCOMPANY[220] = ['Totalbet','England',''];
arrCOMPANY[221] = ['Tote','',''];
arrCOMPANY[290] = ['Tote betXpress','',''];
arrCOMPANY[222] = ['totesport','',''];
arrCOMPANY[223] = ['TOTO','Holland',''];
arrCOMPANY[224] = ['Toto2000','',''];
arrCOMPANY[225] = ['TotoMix','Poland',''];
arrCOMPANY[226] = ['TotoSi','',''];
arrCOMPANY[227] = ['Tradesports','Ireland',''];
arrCOMPANY[274] = ['Triobet','',''];
arrCOMPANY[229] = ['Tutovka','',''];
arrCOMPANY[230] = ['ukbetting','England',''];
arrCOMPANY[258] = ['Unibet','',''];
arrCOMPANY[235] = ['Vcbet','England',''];
arrCOMPANY[231] = ['Veikkaus','Finland',''];
arrCOMPANY[232] = ['VICBET','',''];
arrCOMPANY[233] = ['Victoria-Tip','',''];
arrCOMPANY[234] = ['Victory','',''];
arrCOMPANY[317] = ['Vierklee','',''];
arrCOMPANY[256] = ['Vikingbet','Gibraltar',''];
arrCOMPANY[236] = ['VIP Sports','Antilles',''];
arrCOMPANY[237] = ['WagerOnSports','',''];
arrCOMPANY[238] = ['Wallstreet','',''];
arrCOMPANY[239] = ['wb1388.com','',''];
arrCOMPANY[280] = ['WBX','',''];
arrCOMPANY[240] = ['wetten.de','Germany',''];
arrCOMPANY[241] = ['Wettpunkt','Austria',''];
arrCOMPANY[255] = ['William Hill','',''];
arrCOMPANY[242] = ['Wilson','',''];
arrCOMPANY[268] = ['win368','',''];
arrCOMPANY[243] = ['Winamax.com','',''];
arrCOMPANY[244] = ['WINunited.com','',''];
arrCOMPANY[245] = ['World Sports Exchange','USA',''];
arrCOMPANY[246] = ['Worldbet','Czech',''];
arrCOMPANY[247] = ['WSEX','Antigua and Barbuda',''];
arrCOMPANY[248] = ['WWTS','Australia',''];
arrCOMPANY[249] = ['Yabet','Costa Rica',''];
var arrCOMPANYidx = [1,2,253,3,4,285,5,6,286,7,8,9,275,10,11,12,13,266,287,14,15,16,17,18,19,21,22,309,23,24,25,26,27,28,304,276,29,30,31,32,33,34,35,36,37,38,39,40,261,41,42,43,44,45,46,47,48,49,50,51,53,288,52,54,55,271,272,312,56,20,57,58,59,60,61,62,63,269,64,65,66,67,68,69,70,71,72,73,74,75,76,77,314,78,79,308,80,81,82,83,267,311,84,259,85,86,300,87,316,257,88,89,277,90,91,92,93,94,95,96,97,98,99,100,102,101,103,104,105,106,107,108,109,270,110,111,305,112,113,114,115,116,117,118,119,120,121,122,123,124,302,299,125,126,254,298,318,127,128,129,250,297,131,130,262,296,132,278,133,134,279,263,135,301,310,136,137,138,139,140,141,142,143,144,315,145,295,146,147,148,149,150,151,152,264,153,294,293,154,155,156,157,252,292,158,159,160,282,161,162,163,164,165,166,167,168,169,170,281,171,172,173,174,175,176,177,178,265,179,303,180,181,182,183,184,185,251,307,187,186,188,189,306,190,191,192,193,194,195,196,197,198,199,313,200,201,202,203,273,289,204,205,206,207,208,209,210,211,212,213,228,214,291,260,215,216,284,217,218,219,283,220,221,290,222,223,224,225,226,227,274,229,230,258,235,231,232,233,234,317,256,236,237,238,239,280,240,241,255,242,268,243,244,245,246,247,248,249];var arrCOMPANY = new Array();
arrCOMPANY[1] = ['10BET','England',''];
arrCOMPANY[2] = ['176bet','',''];
arrCOMPANY[253] = ['188bet','',''];
arrCOMPANY[3] = ['24hBET','Sweden',''];
arrCOMPANY[4] = ['24hPoker','Sweden',''];
arrCOMPANY[285] = ['2BetOnline','England',''];
arrCOMPANY[5] = ['3bwin','',''];
arrCOMPANY[6] = ['5 Dimes','Costa Rica',''];
arrCOMPANY[286] = ['AA-in','',''];
arrCOMPANY[7] = ['Admiral','Austria',''];
arrCOMPANY[8] = ['Aebet','Honduras',''];
arrCOMPANY[9] = ['AnyBets','',''];
arrCOMPANY[275] = ['AscotSports','',''];
arrCOMPANY[10] = ['Asianodds.com','',''];
arrCOMPANY[11] = ['Astrabet','',''];
arrCOMPANY[12] = ['At Home','',''];
arrCOMPANY[13] = ['Back2Bet','England',''];
arrCOMPANY[266] = ['bc080','',''];
arrCOMPANY[287] = ['bc080.com','',''];
arrCOMPANY[14] = ['BestSportWorld','England',''];
arrCOMPANY[15] = ['Bet','England',''];
arrCOMPANY[16] = ['BET 1128','',''];
arrCOMPANY[17] = ['Bet 365','England',''];
arrCOMPANY[18] = ['Bet Jamaica','',''];
arrCOMPANY[19] = ['BET on USA','West Indies',''];
arrCOMPANY[21] = ['Bet19.com','',''];
arrCOMPANY[22] = ['Bet24','Denmark',''];
arrCOMPANY[309] = ['Bet3000','',''];
arrCOMPANY[23] = ['Betabet','England',''];
arrCOMPANY[24] = ['Betako','',''];
arrCOMPANY[25] = ['betandgame','',''];
arrCOMPANY[26] = ['Betandwin','Austria',''];
arrCOMPANY[27] = ['Bet-at-home.com','Austria',''];
arrCOMPANY[28] = ['betbull','',''];
arrCOMPANY[304] = ['Betchance','',''];
arrCOMPANY[276] = ['Betchoice','',''];
arrCOMPANY[29] = ['BetClass','Malta',''];
arrCOMPANY[30] = ['BetClick','',''];
arrCOMPANY[31] = ['BETCOM','Costa Rica',''];
arrCOMPANY[32] = ['BETCRIS','Costa Rica',''];
arrCOMPANY[33] = ['BETDAQ','Ireland',''];
arrCOMPANY[34] = ['BetDirect','England',''];
arrCOMPANY[35] = ['BetEuro','England',''];
arrCOMPANY[36] = ['Beteurope','',''];
arrCOMPANY[37] = ['Betfair','England',''];
arrCOMPANY[38] = ['Betfred','',''];
arrCOMPANY[39] = ['BetGameDay','Antilles',''];
arrCOMPANY[40] = ['betgrande.com','',''];
arrCOMPANY[261] = ['BetGun.com','',''];
arrCOMPANY[41] = ['Betinternet','England',''];
arrCOMPANY[42] = ['Betmaker','Costa Rica',''];
arrCOMPANY[43] = ['betoddoreven','England',''];
arrCOMPANY[44] = ['BetOnBet','England',''];
arrCOMPANY[45] = ['BetOnGames','Antilles',''];
arrCOMPANY[46] = ['betoto.com','Gibraltar',''];
arrCOMPANY[47] = ['BetRoyal','Antilles',''];
arrCOMPANY[48] = ['Bets4all.com','Austria',''];
arrCOMPANY[49] = ['Betsafe','',''];
arrCOMPANY[50] = ['BetSense.com','England',''];
arrCOMPANY[51] = ['Betshop','England',''];
arrCOMPANY[53] = ['Betsson','England',''];
arrCOMPANY[288] = ['Betsson Exchang','',''];
arrCOMPANY[52] = ['Betsson Sportsbook','',''];
arrCOMPANY[54] = ['Betstar','',''];
arrCOMPANY[55] = ['betSuperbet','',''];
arrCOMPANY[271] = ['betterbet','',''];
arrCOMPANY[272] = ['bettingstar24.com','',''];
arrCOMPANY[312] = ['BetUS','',''];
arrCOMPANY[56] = ['Betway','',''];
arrCOMPANY[20] = ['BetWin','Austria',''];
arrCOMPANY[57] = ['BetWWTS','',''];
arrCOMPANY[58] = ['BetXC','Lithuania',''];
arrCOMPANY[59] = ['Betzone.com','Holland',''];
arrCOMPANY[60] = ['Bill Hurley','Australia',''];
arrCOMPANY[61] = ['BINGOAL','Holland',''];
arrCOMPANY[62] = ['Blue Square','England',''];
arrCOMPANY[63] = ['BoDog','Costa Rica',''];
arrCOMPANY[269] = ['Bookmaker.com','',''];
arrCOMPANY[64] = ['Bowman','England',''];
arrCOMPANY[65] = ['Boylesports','Ireland',''];
arrCOMPANY[66] = ['bwin','',''];
arrCOMPANY[67] = ['Canbet','England',''];
arrCOMPANY[68] = ['Capital Sports','England',''];
arrCOMPANY[69] = ['CaribSports','Honduras',''];
arrCOMPANY[70] = ['Cash Point','Austria',''];
arrCOMPANY[71] = ['CBM Bookmakers','England',''];
arrCOMPANY[72] = ['Centrebet','Australia',''];
arrCOMPANY[73] = ['Certbet','Austria',''];
arrCOMPANY[74] = ['Chance','Czech',''];
arrCOMPANY[75] = ['ciaobet.com','Malta',''];
arrCOMPANY[76] = ['cnnbest.com','',''];
arrCOMPANY[77] = ['com-bet.com','Austria',''];
arrCOMPANY[314] = ['Completesportsbetting','',''];
arrCOMPANY[78] = ['Coral','England',''];
arrCOMPANY[79] = ['cp080.com','',''];
arrCOMPANY[308] = ['Crown','',''];
arrCOMPANY[80] = ['Cybersportsbook','',''];
arrCOMPANY[81] = ['Dansk Tipstjeneste','Denmark',''];
arrCOMPANY[82] = ['Davidson','Australia',''];
arrCOMPANY[83] = ['Denmark','Denmark',''];
arrCOMPANY[267] = ['derby-games.com','',''];
arrCOMPANY[311] = ['dialabet','',''];
arrCOMPANY[84] = ['Diamond Sportsbook','',''];
arrCOMPANY[259] = ['Digibet','',''];
arrCOMPANY[85] = ['dimeplayer.com','',''];
arrCOMPANY[86] = ['Domebet','',''];
arrCOMPANY[300] = ['dorobet','',''];
arrCOMPANY[87] = ['Doxx','Slovakia',''];
arrCOMPANY[316] = ['Doxxbet','',''];
arrCOMPANY[257] = ['Easybets','',''];
arrCOMPANY[88] = ['eb248','',''];
arrCOMPANY[89] = ['Eurobet','England',''];
arrCOMPANY[277] = ['Eurobet.it','',''];
arrCOMPANY[90] = ['Europlay','Austria',''];
arrCOMPANY[91] = ['EuroSportwetten','Austria',''];
arrCOMPANY[92] = ['Eurotip','England',''];
arrCOMPANY[93] = ['Expekt','England',''];
arrCOMPANY[94] = ['Favorit','Croatia',''];
arrCOMPANY[95] = ['Fonbet','Russia',''];
arrCOMPANY[96] = ['Formula','Slovakia',''];
arrCOMPANY[97] = ['Fortuna','Canada',''];
arrCOMPANY[98] = ['Francaise des jeux','',''];
arrCOMPANY[99] = ['Galaxy Betting','',''];
arrCOMPANY[100] = ['game2bet.com','',''];
arrCOMPANY[102] = ['gamebookers','Antigua and Barbuda',''];
arrCOMPANY[101] = ['Gamebookers Italia','',''];
arrCOMPANY[103] = ['GameDay','Holland',''];
arrCOMPANY[104] = ['Gameshold','',''];
arrCOMPANY[105] = ['Gaming Club','',''];
arrCOMPANY[106] = ['Global','',''];
arrCOMPANY[107] = ['Global Sportsbet','Australia',''];
arrCOMPANY[108] = ['Globet','England',''];
arrCOMPANY[109] = ['GoldBet','Austria',''];
arrCOMPANY[270] = ['Greekbet','',''];
arrCOMPANY[110] = ['GS Network','',''];
arrCOMPANY[111] = ['GWbet','Austria',''];
arrCOMPANY[305] = ['He Dui','British Virgin Islands',''];
arrCOMPANY[112] = ['Hititbet','Turkey',''];
arrCOMPANY[113] = ['HK Jockey Club','Hong Kong',''];
arrCOMPANY[114] = ['Hollywood','USA',''];
arrCOMPANY[115] = ['Hooball','',''];
arrCOMPANY[116] = ['IASbet','Australia',''];
arrCOMPANY[117] = ['IBCBET','',''];
arrCOMPANY[118] = ['Iceland','Iceland',''];
arrCOMPANY[119] = ['Iconbet','',''];
arrCOMPANY[120] = ['Interaction','',''];
arrCOMPANY[121] = ['Internet1x2','Honduras',''];
arrCOMPANY[122] = ['Intertops','West Indies',''];
arrCOMPANY[123] = ['Interwetten','Cyprus',''];
arrCOMPANY[124] = ['Islenskar Getraunir','Iceland',''];
arrCOMPANY[302] = ['Jaxx','',''];
arrCOMPANY[299] = ['Jazz','',''];
arrCOMPANY[125] = ['Jokerbets','Austria',''];
arrCOMPANY[126] = ['jp1388.com','',''];
arrCOMPANY[254] = ['Ladbrokes','England',''];
arrCOMPANY[298] = ['Ladbrokes.com(lad168.com)','',''];
arrCOMPANY[318] = ['Lasseters','','http://www.lasseters.com.au'];
arrCOMPANY[127] = ['LevelBet','',''];
arrCOMPANY[128] = ['LinesMaker','England',''];
arrCOMPANY[129] = ['Littlewoods','England',''];
arrCOMPANY[250] = ['Macauslot','Macao',''];
arrCOMPANY[297] = ['Mansion Exchang','',''];
arrCOMPANY[131] = ['Mansion Exchange','',''];
arrCOMPANY[130] = ['Mansion Sportsbook','',''];
arrCOMPANY[262] = ['Mansion88','',''];
arrCOMPANY[296] = ['Mansion88.com','',''];
arrCOMPANY[132] = ['matchbook','',''];
arrCOMPANY[278] = ['MatchMyWager','',''];
arrCOMPANY[133] = ['Maxi-tip','Czech',''];
arrCOMPANY[134] = ['Mediabet','Germany',''];
arrCOMPANY[279] = ['Megasportsworld','',''];
arrCOMPANY[263] = ['MeridianBet','',''];
arrCOMPANY[135] = ['Milenium','',''];
arrCOMPANY[301] = ['Ming Sheng','',''];
arrCOMPANY[310] = ['Mozzart','',''];
arrCOMPANY[136] = ['MrBookmaker','Malta',''];
arrCOMPANY[137] = ['Multibet','Australia',''];
arrCOMPANY[138] = ['myBet.com','',''];
arrCOMPANY[139] = ['Nike','Ireland',''];
arrCOMPANY[140] = ['nn-new.com','',''];
arrCOMPANY[141] = ['Nordicbet','Costa Rica',''];
arrCOMPANY[142] = ['Norsk Tipping','Norway',''];
arrCOMPANY[143] = ['Norway','Norway',''];
arrCOMPANY[144] = ['odds4you','Gibraltar',''];
arrCOMPANY[315] = ['Oddscompany','',''];
arrCOMPANY[145] = ['Oddset','Germany',''];
arrCOMPANY[295] = ['Oddset.de','Germany',''];
arrCOMPANY[146] = ['Olympic Sports','Jamaica',''];
arrCOMPANY[147] = ['OmniBet','',''];
arrCOMPANY[148] = ['Paddy Power','Ireland',''];
arrCOMPANY[149] = ['PAF','',''];
arrCOMPANY[150] = ['Paradisebet.com','England',''];
arrCOMPANY[151] = ['Parbet','England',''];
arrCOMPANY[152] = ['Parier','',''];
arrCOMPANY[264] = ['PartyBets','',''];
arrCOMPANY[153] = ['PasarBola','USA',''];
arrCOMPANY[294] = ['Petica Plus','',''];
arrCOMPANY[293] = ['Pianeta Scommes','',''];
arrCOMPANY[154] = ['Pianeta Scommesse','',''];
arrCOMPANY[155] = ['Pinnacle Reduced','',''];
arrCOMPANY[156] = ['Pinnacle Sports','Holland',''];
arrCOMPANY[157] = ['Playit.com','England',''];
arrCOMPANY[252] = ['PointBet','Singapore',''];
arrCOMPANY[292] = ['Portlandbet','',''];
arrCOMPANY[158] = ['Premierbet','England',''];
arrCOMPANY[159] = ['Primebet','Malta',''];
arrCOMPANY[160] = ['Profesjonal','',''];
arrCOMPANY[282] = ['Proline','',''];
arrCOMPANY[161] = ['PWsport','',''];
arrCOMPANY[162] = ['RaceBook.com','',''];
arrCOMPANY[163] = ['Redbet','England',''];
arrCOMPANY[164] = ['Regency','',''];
arrCOMPANY[165] = ['Reno 2000','',''];
arrCOMPANY[166] = ['Royal Sports','',''];
arrCOMPANY[167] = ['s195','',''];
arrCOMPANY[168] = ['S456','',''];
arrCOMPANY[169] = ['Sazka','Czech',''];
arrCOMPANY[170] = ['sb1888.com','',''];
arrCOMPANY[281] = ['SBG Global','',''];
arrCOMPANY[171] = ['sbo8.com','',''];
arrCOMPANY[172] = ['sbobet.com','',''];
arrCOMPANY[173] = ['Scandic Bookmakers','England',''];
arrCOMPANY[174] = ['Schwechat','Austria',''];
arrCOMPANY[175] = ['ScommesseAndromeda','',''];
arrCOMPANY[176] = ['Set2Go','Gibraltar',''];
arrCOMPANY[177] = ['Simon Beasley','',''];
arrCOMPANY[178] = ['Singapore Pools','Singapore',''];
arrCOMPANY[265] = ['Singbet','',''];
arrCOMPANY[179] = ['singbet3.com','',''];
arrCOMPANY[303] = ['SkandiaBet','',''];
arrCOMPANY[180] = ['skybet','England',''];
arrCOMPANY[181] = ['Skyline','',''];
arrCOMPANY[182] = ['SNAI','Italy',''];
arrCOMPANY[183] = ['SportBet','',''];
arrCOMPANY[184] = ['Sportfanatik','Costa Rica',''];
arrCOMPANY[185] = ['Sporting','',''];
arrCOMPANY[251] = ['Sportingbet','',''];
arrCOMPANY[307] = ['sportingbet.com.au','',''];
arrCOMPANY[187] = ['SportingbetUSA','Costa Rica',''];
arrCOMPANY[186] = ['SportingOdds','England',''];
arrCOMPANY[188] = ['Sportna loterija','Slovenia',''];
arrCOMPANY[189] = ['SportOdds','Australia',''];
arrCOMPANY[306] = ['Sports Acumen','',''];
arrCOMPANY[190] = ['Sports.com','',''];
arrCOMPANY[191] = ['Sportsbet','Australia',''];
arrCOMPANY[192] = ['Sportsbetting','',''];
arrCOMPANY[193] = ['Sportsbook.com','',''];
arrCOMPANY[194] = ['SPORTSinteraction','Canada',''];
arrCOMPANY[195] = ['SportsTAB','Australia',''];
arrCOMPANY[196] = ['Sportwetten Gera','',''];
arrCOMPANY[197] = ['SSP','England',''];
arrCOMPANY[198] = ['Stan James','Gibraltar',''];
arrCOMPANY[199] = ['Stanleybet','Malta',''];
arrCOMPANY[313] = ['Starbet','',''];
arrCOMPANY[200] = ['StarPrice','Austria',''];
arrCOMPANY[201] = ['stepscommesse','',''];
arrCOMPANY[202] = ['Strike','',''];
arrCOMPANY[203] = ['STS','Poland',''];
arrCOMPANY[273] = ['Sunderlands','',''];
arrCOMPANY[289] = ['Super268','',''];
arrCOMPANY[204] = ['Superbook','',''];
arrCOMPANY[205] = ['SuperOdds','',''];
arrCOMPANY[206] = ['Supporterbet','',''];
arrCOMPANY[207] = ['Svenska Spel','',''];
arrCOMPANY[208] = ['Swapbets','Gibraltar',''];
arrCOMPANY[209] = ['Sweden','Sweden',''];
arrCOMPANY[210] = ['Synot TIP','Czech',''];
arrCOMPANY[211] = ['Teletip','Czech',''];
arrCOMPANY[212] = ['Terno','Slovakia',''];
arrCOMPANY[213] = ['theBet.cc','Austria',''];
arrCOMPANY[228] = ['TheBetArena','',''];
arrCOMPANY[214] = ['TIP','Slovakia',''];
arrCOMPANY[291] = ['Tip Kurz','',''];
arrCOMPANY[260] = ['Tipico','',''];
arrCOMPANY[215] = ['TipKurz','',''];
arrCOMPANY[216] = ['Tipsport','Czech',''];
arrCOMPANY[284] = ['Tipsport-Sk','',''];
arrCOMPANY[217] = ['Toals','',''];
arrCOMPANY[218] = ['ToBo','',''];
arrCOMPANY[219] = ['topcil','',''];
arrCOMPANY[283] = ['TopSport','',''];
arrCOMPANY[220] = ['Totalbet','England',''];
arrCOMPANY[221] = ['Tote','',''];
arrCOMPANY[290] = ['Tote betXpress','',''];
arrCOMPANY[222] = ['totesport','',''];
arrCOMPANY[223] = ['TOTO','Holland',''];
arrCOMPANY[224] = ['Toto2000','',''];
arrCOMPANY[225] = ['TotoMix','Poland',''];
arrCOMPANY[226] = ['TotoSi','',''];
arrCOMPANY[227] = ['Tradesports','Ireland',''];
arrCOMPANY[274] = ['Triobet','',''];
arrCOMPANY[229] = ['Tutovka','',''];
arrCOMPANY[230] = ['ukbetting','England',''];
arrCOMPANY[258] = ['Unibet','',''];
arrCOMPANY[235] = ['Vcbet','England',''];
arrCOMPANY[231] = ['Veikkaus','Finland',''];
arrCOMPANY[232] = ['VICBET','',''];
arrCOMPANY[233] = ['Victoria-Tip','',''];
arrCOMPANY[234] = ['Victory','',''];
arrCOMPANY[317] = ['Vierklee','',''];
arrCOMPANY[256] = ['Vikingbet','Gibraltar',''];
arrCOMPANY[236] = ['VIP Sports','Antilles',''];
arrCOMPANY[237] = ['WagerOnSports','',''];
arrCOMPANY[238] = ['Wallstreet','',''];
arrCOMPANY[239] = ['wb1388.com','',''];
arrCOMPANY[280] = ['WBX','',''];
arrCOMPANY[240] = ['wetten.de','Germany',''];
arrCOMPANY[241] = ['Wettpunkt','Austria',''];
arrCOMPANY[255] = ['William Hill','',''];
arrCOMPANY[242] = ['Wilson','',''];
arrCOMPANY[268] = ['win368','',''];
arrCOMPANY[243] = ['Winamax.com','',''];
arrCOMPANY[244] = ['WINunited.com','',''];
arrCOMPANY[245] = ['World Sports Exchange','USA',''];
arrCOMPANY[246] = ['Worldbet','Czech',''];
arrCOMPANY[247] = ['WSEX','Antigua and Barbuda',''];
arrCOMPANY[248] = ['WWTS','Australia',''];
arrCOMPANY[249] = ['Yabet','Costa Rica',''];
var arrCOMPANYidx = [1,2,253,3,4,285,5,6,286,7,8,9,275,10,11,12,13,266,287,14,15,16,17,18,19,21,22,309,23,24,25,26,27,28,304,276,29,30,31,32,33,34,35,36,37,38,39,40,261,41,42,43,44,45,46,47,48,49,50,51,53,288,52,54,55,271,272,312,56,20,57,58,59,60,61,62,63,269,64,65,66,67,68,69,70,71,72,73,74,75,76,77,314,78,79,308,80,81,82,83,267,311,84,259,85,86,300,87,316,257,88,89,277,90,91,92,93,94,95,96,97,98,99,100,102,101,103,104,105,106,107,108,109,270,110,111,305,112,113,114,115,116,117,118,119,120,121,122,123,124,302,299,125,126,254,298,318,127,128,129,250,297,131,130,262,296,132,278,133,134,279,263,135,301,310,136,137,138,139,140,141,142,143,144,315,145,295,146,147,148,149,150,151,152,264,153,294,293,154,155,156,157,252,292,158,159,160,282,161,162,163,164,165,166,167,168,169,170,281,171,172,173,174,175,176,177,178,265,179,303,180,181,182,183,184,185,251,307,187,186,188,189,306,190,191,192,193,194,195,196,197,198,199,313,200,201,202,203,273,289,204,205,206,207,208,209,210,211,212,213,228,214,291,260,215,216,284,217,218,219,283,220,221,290,222,223,224,225,226,227,274,229,230,258,235,231,232,233,234,317,256,236,237,238,239,280,240,241,255,242,268,243,244,245,246,247,248,249];
Yani, Excel'in klasik dış veri al yöntemi veya bu forumdaki klasik VBA yöntemleriyle bu sayfadan veri almanız pek mümkün değil.

Biraz daha değişik bir VBA kodlaması kullanmak gerekir ama üstünde çalışmak lazım....

.
 
A

akdir

Katılım
21 Şubat 2008
Mesajlar
42
Excel Vers. ve Dili
Türkçe
teşekkürler Haluk kardeş pek birşey anlamadım ama şunu net anladım. bu iş zor neyse artık bende klasik HTML biçiminde hazırlanmış bir site bulayım.
 
T

tahsinanarat

Altın Üye
Katılım
14 Mart 2005
Mesajlar
2,164
Excel Vers. ve Dili
Ofis 2019 Türkçe
Altın Üyelik Bitiş Tarihi
27-05-2028
Düzenli olarak ayarladığınız sayfayı

akdir' Alıntı:
arkadaşlar hepinize iyi günler. Ben excel de bir proğram yapmaya çalışıyorum. bunun içinde 2 web sayfasından düzenli olarak veri almam gerekiyor. bir tanesini ayarladım o siteden düzenli olarak veri akışını sağlıyorum ama diğer siteden tüm ayarları yapmamağa rağmen "BU WEB SORGUSU HİÇBİR VERİ DÖNDÜREMEDİ. SORGUYU DEĞİŞTİRMEK İÇİN TAMAMI TIKLAYIN ......" gibi mesaj geliyor ve veri alamıyorum.
bu konuda bana yardımcı olursanız sevinirim teşekkürler.
Genişletmek için tıkla ...
Düzenli olarak o ayarladıınız web sayfasını örnek açısından buraya eklerseniz, bizlerde bilgilenmiş oluruz. Teşekkürler
 
Cevap yazmak için giriş yap yada kayıt ol.
Üst