如何用人工的方式将Excel里的一堆数字变成一个数组

目的是抛砖引玉，有谁可以教教我如何吧Excle的数据导入MyEclipse么？

如果只有⑨个字符的话我肯定是直接人工输入的，然而这次有65536行乘以3组，遭不住啊。

一、数组之间要有逗号
在B列右键，选择插入1列。再B1输入一个逗号以后，双击B1格的右下角就可以填充整列了（我不清楚这样双击的操作具体怎么称呼）

合并是用Excel的&语句，找一列、例如E列的首行输入=A1&B1，意思就是此格等于A1格和B1格的合并。只有双击那一格的右下角向下填充整列，Excel会自动做每一行语句的修改，这样每一格动等于相应格的和了，E2等于A2&B2，E3等于A3&B3……。

二、梯子和数组要横放

横放是粘帖的工作。复制需要的长度后，找到选择性粘贴，勾选转置就横过来了

ps：中间那张图要在粘帖选项中选择“数值”，并在最后勾选转置，我忘记用红圈圈出来了。
p.ps:图片太宽了。全图点http://images2015.cnblogs.com/blog/807536/201509/807536-20150913194415856-1612403847.png

由于我用的wps最多支持16384列，所以要分至少5次，否则由于数据过量，会出现下图

这也是我迫切地想知道是否有其他途径复制数据的原因

三、最后只要添加一些细节，删除一些空格

横置以后再粘帖到word中，数值就不会分行了。需要粘帖为“无格式文本”。

然而会有很多莫名其妙的空格，我们用“替换”来批量删除它们

说是空格，但是其实他们和空格有不能划等号。总之复制到查找栏吧，不要用键盘输入的空格，那不一样

“替换为”那一栏空着，点击全部替换以后，文档会像是这样↓

之后就可以直接复制到MyEclips里了

 

附：A列1万行数组化  

int[] test1= { -2574,-4010,8243,771,2447,-5197,2556,8044,3314,3617,6065,-2817,3131,6318,2186,-113,629,-2582,-37,-1520,164,2055,-5936,5912,1717,5988,4781,5757,892,-4394,8034,2213,-1080,-2080,5364,106,2657,566,3940,-5116,4583,1806,6555,2621,-7197,528,1626,18,1049,6243,3198,4397,-1325,9087,936,-6291,662,-178,135,-3473,-2385,-165,1713,-7949,-4234,1138,2212,104,6968,-3632,3801,1137,-1296,-1215,4272,6223,-5922,-7723,7044,-2938,-8180,1356,1159,-4022,-3713,1158,-8715,-4081,-2541,-2555,-2284,461,940,6604,-3631,3802,-2037,-4354,-1213,767,-4619,2209,-7862,-3195,5676,4553,-784,-2010,-3046,1566,-1562,1021,2943,-7241,3847,3222,3001,-1731,-4889,2544,-7893,-1142,7523,7559,867,-4088,2001,-2532,-4488,-8557,5088,-7906,-2104,-1911,-1048,1886,5500,-890,1386,-2080,1431,-1607,5808,-8107,4418,450,1261,-3869,-1184,418,2413,-6418,4607,4059,-444,7821,-2605,-2241,-1390,3047,-1588,8529,1116,4085,4512,4008,4242,6382,-1824,2455,-9217,6014,-2490,-7241,-845,9680,-3756,-5569,3402,4704,-6267,-2393,3191,-965,-5042,-6951,-6184,-8752,525,2144,6195,541,-3336,6904,-3130,-3261,-4770,-34,-1991,292,3703,4590,7406,2272,5190,-5336,-1521,4381,-1579,4700,269,-1059,-2249,-166,-2553,-1098,-6839,-4172,303,7838,256,-931,-5243,-51,267,-3432,2351,58,49,5963,253,3616,-7918,-4486,1256,-3305,-5528,-5891,3779,-4004,950,-8741,1864,-1158,871,-2899,5178,3183,-784,-7603,-984,-2407,-3411,-1467,4295,1271,-778,-2478,-2442,4041,-1031,1999,973,-3647,3312,-4773,2333,-719,-4644,1092,-4944,4525,3831,4107,-1816,4407,-6907,-593,-3613,-8122,3122,2754,-44,511,-476,536,-5190,4507,3528,-236,2492,8688,-8008,8074,170,-1495,7394,3729,-9364,32,-2159,-4385,2309,-33,7063,3244,-769,-4364,4416,-3248,1072,-5013,-5120,-3099,-6878,-3406,-940,5078,-3698,-343,3186,3295,7153,4000,-884,4189,-2157,71,4328,1020,6166,-1053,1928,-2323,-4461,-7675,647,-1331,-4995,2529,-5159,-864,-767,-7490,-5511,-5163,-1485,5841,5197,2159,-1230,-3279,8196,-1884,1540,-25,341,342,3993,1052,-5887,-2900,-1078,-3975,-2384,-2723,-5255,1596,-5417,384,-4494,-4914,4367,6558,871,-5553,1950,6561,-3865,-1749,-2064,1780,2214,5699,-1443,4225,5653,-3386,5668,6535,-1381,1446,-3251,1970,-1096,1268,4906,-5583,-72,-2219,-1130,-1612,732,-6692,2995,-980,-4014,798,7262,2075,5981,3826,-2723,-6061,6636,-3409,4270,1624,-507,-6083,-4903,-7234,1722,1254,2237,-4372,6114,4675,3798,-904,1088,880,-6492,2681,686,-2807,724,-3478,-5423,1563,426,1378,-1947,2565,3219,8637,2034,-603,5334,311,-6940,1885,-1373,-963,-6699,476,577,-1925,550,6246,4291,1314,-1776,893,-1502,3264,-4634,-3258,7555,9062,-3355,6742,1441,4470,-7647,4468,-4237,-4125,-1592,4118,-8250,288,-3647,516,6258,-4654,3357,-888,1768,-688,2212,-4019,6385,1071,1336,-2179,3840,135,-5227,1956,-6513,6641,2189,6336,308,1351,-1122,9535,-5092,5651,-4241,752,3517,-8446,9373,-188,-2008,1695,1890,7163,5811,-663,1101,-6120,81,-1633,425,1662,-467,-6705,-1094,2833,-1479,-741,1210,343,-2973,-7979,-2369,-2234,-9345,-2033,4086,-700,636,4108,2120,-229,3826,-1917,-1101,-5373,2706,8152,-2783,-57,5379,3202,-4509,2417,-4422,-7256,-2235,-625,-7343,6916,3707,-1235,1597,-3520,-1391,-839,3004,2821,3390,-237,-6893,-2048,4593,395,3763,4510,-5615,1506,2451,5755,559,4170,2278,-4424,6534,87,1974,8483,1352,-8419,5894,-387,-319,1600,4019,4728,1815,-6280,1954,215,3671,2139,929,-6915,6792,-8318,7801,976,-1653,-2202,-4951,2148,1128,-3439,779,-4511,-6448,-5329,-1278,510,-336,-550,-1767,-2652,9132,-1150,4292,-3235,-2753,1443,-2495,148,4928,-3570,-5897,-493,-1282,3634,-4060,-2519,786,3505,498,-2670,-1077,-2883,882,2941,6548,-3832,-4179,-1173,2704,-7016,-327,123,2059,514,2417,2591,-5095,2331,-342,2619,-2838,2635,2628,-2782,371,-3750,-1819,4025,1701,8626,-1201,1301,-6055,5836,2586,-2068,-4480,4580,-6727,3432,470,2182,215,-2064,-1538,-3409,8393,2207,4790,6382,-1587,-2370,372,754,6505,6218,1750,-470,4524,608,1093,3160,-49,4060,6193,-7281,5891,463,468,-94,1075,4327,2962,7044,-142,789,-1657,-2917,2221,-4389,-3098,3597,-6231,5180,4559,786,-4267,-3493,2856,-6526,4968,-2770,-1039,-2891,3955,-4391,5668,-2233,798,532,1394,2146,-771,1510,181,-2430,-1397,-1319,1699,1989,-6099,2805,1240,3977,-4273,5269,-278,2733,313,-1914,-6312,8082,-486,3891,5306,472,810,-4053,2369,-9022,-2693,8141,-1705,1299,-2265,4983,2127,-6240,-3550,1611,8533,1309,-6568,-6213,-2195,-2479,4287,-2103,-4138,6594,245,953,4247,3354,-1839,591,128,3249,517,-4926,6298,2354,5417,3288,1174,-2633,6592,4745,-1201,5614,-6602,-419,-1157,-4957,815,-1441,6597,4228,-552,-6936,2979,2369,-4472,5109,4533,-710,910,-2669,-6574,5440,-6925,2990,7452,1893,5129,-4025,28,349,5801,796,198,3132,-552,-7410,-7371,3191,-3951,-2881,-2386,4100,1210,770,1072,58,6162,555,-5455,-4110,-2240,4109,-4799,7045,-1515,-304,5833,-403,-3558,6201,4860,245,5361,3136,-3677,-3686,4599,638,-108,-4247,9135,-531,859,-2864,-426,1016,142,-339,2148,7289,-5716,3154,8712,927,-4548,-1936,-3253,5190,1441,-4535,-643,3965,-4332,-2944,5273,-8235,-2825,-4839,-1148,-6275,632,2729,72,-4392,-3670,-6665,4540,3800,188,1178,3486,-4687,-6251,1083,-6234,-2217,-5820,8497,-2140,-527,-5725,-503,3873,-731,2452,780,5537,-3317,2754,-329,2206,-8149,-5152,-5881,-1139,5536,-5972,-7301,-3893,-877,1211,-5390,176,4625,2940,-325,2921,-5321,1385,-1655,1825,-7455,-5664,1693,-9,2112,-4787,1418,-3848,-2110,-6941,-155,4662,5016,2541,-76,-4499,-747,-6048,5227,4276,-3014,-6790,-45,2216,-4773,1859,-1068,6178,1613,7066,-2394,-1359,-5593,1624,2053,-2289,2494,3951,-1030,7119,5386,8090,-4316,6219,3220,3710,142,-7,-3241,-3898,919,-954,-2613,6186,7214,-391,-2882,504,-1148,-6464,-1413,-8777,-3719,-1691,5057,6138,577,-2968,415,8665,3437,-1563,-829,-2151,7186,-3122,-3536,-1644,-5226,2337,-1946,480,-225,418,328,139,-3612,2353,297,-1125,-563,-5004,-4400,-6143,-5629,828,4497,-2122,-2735,-2045,-4125,9356,4817,107,-754,2333,4353,6639,4746,-3522,3821,-7468,-6862,-2916,1795,-1608,-4193,-4932,-2525,448,4766,-3027,685,557,-7348,4968,-8126,-3801,2726,6845,2117,479,-1126,-3977,3112,2128,-4391,1545,7184,-4499,-1933,-1923,-2719,579,2011,-4086,-3021,2967,3826,973,477,3895,524,4798,2598,220,-257,4555,-1208,4422,-257,3039,5133,-5395,-588,-1333,8320,4501,-1738,-4518,-4322,3465,-3572,-6847,-4844,-3523,-5327,-3029,5328,4143,4383,-2145,-4607,2694,-2429,-7651,-4825,3985,-3127,-7381,5124,5496,5550,6459,-3687,332,7489,-2712,443,-2775,-2797,4147,-163,530,-173,-8295,-2555,227,1124,255,-3160,-8078,-2520,5714,2222,6844,-4093,-374,-1584,1851,4042,-841,-9131,-579,146,7106,-4342,-2339,3106,1885,-520,301,2434,7538,-340,6697,-1734,-6267,-5853,1828,-8635,-4235,1516,-3699,3116,4549,966,-3654,-4468,-3369,2320,3818,-8750,4176,-3971,-3802,-6469,-5020,-6834,6592,6261,-7542,5431,3729,3953,-4345,5147,1965,1744,-761,5264,1281,5394,3501,-643,-2717,1291,-5639,1624,1200,6446,-6639,-3111,-112,-1503,7670,603,5827,5705,80,-1161,-2876,-3044,-992,-1705,-2492,-8238,-1501,-3702,-3665,260,-1780,795,-1414,3212,3464,361,-5135,2005,-4850,4196,1404,-1350,-181,2122,58,-4217,-360,-5409,-1693,6667,2406,2675,-743,-4811,1535,-1926,1639,5860,6070,3113,-193,3816,679,740,3742,4820,5654,4530,-950,5258,-3085,-1318,-3039,2142,-3997,-1981,-5669,3109,87,-2007,3639,-3580,-8041,4676,2993,962,38,-5233,-3879,-3754,8367,-4408,-7620,2411,-3386,-4901,-3250,216,71,1862,-164,1050,-344,5082,-2131,-3077,1913,-5419,2704,-9527,-990,809,1823,-5039,-1261,4840,-1671,4273,4518,-1626,955,-7078,-4609,3735,-5945,-3955,6025,3872,-2391,-598,-3286,-7641,-2777,-619,3374,3396,4129,2994,-2450,1806,5180,-2124,-3590,3039,-7142,2291,2745,3169,-4732,-4876,-5025,-1105,6140,-4113,-2859,-2458,4831,-5282,-1087,-2941,6320,-7623,5583,6020,1213,251,-1931,-6376,5740,353,-7086,-305,1757,-4681,2286,-5317,6744,-1590,3978,9662,-6192,-6486,1408,-3669,1677,-4859,3618,-2986,-5292,-1570,-4722,-5340,-7118,-859,6679,-7155,1803,-6339,-6260,5766,2703,-998,-1996,-1752,-7565,2800,-3361,-4259,-6517,-6682,-7563,4319,-6051,-558,3817,680,7566,684,4822,2149,-6312,-2819,-4881,6676,-2704,-307,2,2833,-1005,-391,-9612,-178,5017,-1061,2821,-2534,-2784,321,-532,-3787,3072,-2984,-1877,7139,-4308,-7090,2203,-8057,3806,2516,752,-7052,1769,971,8437,3105,-439,4035,5551,-4014,2789,-1904,-1988,-4208,2683,166,-2636,-2653,-3903,-2119,774,6100,5513,-498,1035,-1876,-963,3917,-3434,120,397,638,1408,-588,-1049,-200,-4769,3948,-322,2166,3327,-7697,-6815,-877,6613,-6323,-4300,2682,1634,-2107,-919,5479,557,5400,806,778,1174,-2727,3983,2463,-3095,-4788,7341,-4952,-3209,1539,-4765,3668,5502,-794,-2353,-5914,3329,1784,181,2688,-3809,3475,4069,-3514,-4370,-898,6165,3117,-1184,4115,-1049,842,8540,-5414,531,-1452,-6779,7217,4635,-4253,-3099,-669,621,-7424,-751,-1123,3467,-205,-4442,-5570,-6220,-1207,6745,5188,-2210,1580,-647,976,-2648,794,-4448,2243,-53,-304,-6868,64,-1320,2172,-4487,-3863,2282,2