论坛 › Python交流 › 有偿请教大佬，如何利用python处理excel，有偿请教!

wqx285314590 发表于 2020-3-9 22:47:00

有偿请教大佬，如何利用python处理excel，有偿请教!

各位大佬好，请问如何利用python写一个函数，实现输入“起始坐标”，‘间隔‘’，’‘’列数‘’，‘’行数’’等信息，自动生成左边X Y两列数据的功能？下图为X Y的示意图。
如果能解决问题，愿意私聊加微信或者支付宝付费10元人民币。跪谢！
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA0gAAAJQCAYAAAC0FUSZAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACM+SURBVHhe7d1NaF3nmQfw10lpSqeEym4IiDaYUaSm6RcZFEOJGrSJA02DGQg1ESSY7moRKC50p3GNGWbnTZHXIgsFF0pR2kCjlWhEYWy1XQz5uJIFTkldnNZSU9ppFh00vOc+J5VdyXEsnavzXv1+cH0+dOvy5LHOPf/znvPeA51OZ2NkZCQBAADsd3fFEgAAYN8TkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEwK6ZmZlJExMT6dvf/nZaWVmJvf9sbm6uel9+3a76/fn/41a+973vVe87d+5c7AGA2ycgAbBrnnrqqfSJT3wivf/+++lHP/pR7L3RH/7whyogZaOjo9XydtTv/cUvflH9HVuZn59Pv//976v1I0eOVEsA+CgEJAB2zX333Zcef/zxav31119Pi4uL1fpmr7zyShWgcpB67rnnYu+He/rpp6tl/t/mv2Mrr732WrUcGhpKY2Nj1ToAfBQCEgC76sSJE2lgYKBa/8lPflIta/m2uzzKkz3xxBNVoLpdw8PDtxxFymFsdXW1Wn/yySerJQB8VAISALvu2WefrZb5drf6drqsvu0uB6j6PR/FrUaRXn311Wpp9AiAnRCQANh1OaDkoJLlgJRHe/IIT77tLruTcJTdPIpUM3oEwG4RkABoxPPPP18t69Ge+na7L37xizsa4dk8ilSPTl28eLFaGj0CYKcEJAAakUd7vv71r1frm2eX+9a3vlUt79TmUaT89+bnmpaWlqpto0cA7JSABEBjnnnmmWq2utrRo0ergLNT9SjS+vr6B881GT0CYDcISAA05k9/+lN1K1ytfk5opzaPItXPNRk9AmA3HOh0OhsjIyOxCQC7Z2pqqgpFeda6PNqT5WnA80jSzfJ7t5KD0LFjx2LrH/KtdadPn67W8+jR2bNnq3UA2AkjSAA0Ij8fVI8Yffe7371hVrut5Pdu9bp69Wq840Z5FKn+O+slAOyUgATArsvTetdBKI8A5TBTz2qXR5JmZmaq9c1mZ2e3fH3nO9+JdwBA8wQkAHZdntY7B6E8QcNzzz1X7dv83FD+DqN8ixwAtI2ABMCuysGn/hLXxx9/PN13333VepbDUg5NeeKGn/70p7EXANpDQAJgV+Vpt3MAyhMz5AkZNsthKYemLH930eLiYrUOAG0hIAGwa3Lgqafd3mqmuuypp56qwlP26quvVksAaAsBCYBdUweePKvcVlNzZ3kUqf5ZnqVuN0aR7rnnnlgDgJ3xPUgAAADBCBIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAMKBTqezMTIyEpsf3dTUVFpdXU0nT55MY2NjsbdrZmYmzc/Px1ZKAwMDaXp6OrYAAADa5Y5HkBYXF9PExEQVjraSf37p0qU0Oztbvc6cOZPW19fT5ORkvAMAAKBd7jggnT9/Po2OjlYjR1vJo0mbR4uGh4er9+eQtLKyEnsBAADa444DUh4VOnXqVGwBAACUr6eTNOTb8fJzSHk0CQAAoG12PElDftYo32631SQNm83NzaULFy6k48ePp2PHjsXenVleXo41AACg3+0kt9yunowg5WeOcjjKzyDtVjhaWFhIV69ejS0AAKDf9WKApPERpByOTp8+nYaGhtLZs2dj787lgJSNj49XS8pQ/6PuRfpn9+hbefSsTPpWJn0rj56VqVd9a3wEqYlwBAAA0IRGA1L+nqQ8KYNwBAAAlOCOA1IOP/mVb6/L8jJvnzt3rtqemZmplvl7j+r31q/6PQAAAG2y42eQ9opnkMrknt8y6Vt59KxM+lYmfSuPnpWpV33r6fcgAQAAtJmABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAIQDnU5nY2RkJDY/uqmpqbS6uppOnjyZxsbGYu8/TE5OpvX19dhK277vo1pYWKiW4+Pj1ZIyLC8vV8ud/Jtrm9dev5YWX383Xb7652r7wcF70+jwofTEI4PVdsnq2t767Vq1/dADB/uutn7rm56VSd/K1K990zPaqlfnkXcckBYXF9P58+dja+vgMzExkUZHR9OpU6eq7ZmZmTQ/P78rIUlAKlM/BaS/vv/3NP2zt9Iv33g39txodOQzafKbD6WBT3089pRDbeXVpmdqaxu1OY60ST/Xtp/06jzyjm+xy+Eoh58cdraSw1BWh6PsxIkTaWBgIF28eDH2QLludaBNaSMtLf8x/fDlN2O7LGorrzY9U1vbqM1xpE36uTZ23x0HpNnZ2RvCz83ybXdDQ0Ox9Q95X/4ZlCwP0W9/oM0OVH/++vL19PNf/a5aL4XayqtNz9TWNmpzHGmTfq6NZjQ2ScPaWvfezq1sfiYJSpTvX75dSyvXY60MausqqTY961Jbe6ity3GkHfq5Npqx40ka6meRbn6uKE/OkEeLbh5lqp9DyiNQO1E/gzQ46KE6eu8/X/59eu9//y+2bu1f7rkrnf73cv6dqq2rpNr0rEtt7aG2LseRdujn2var1j6DdDu2Gim61cgSAADAXmpsBClP/52dPXu2WtbOnTtXPYM0PT0de+6MWezK1C+z2P3Xj/4n/fdbf4itW/u3Bw+l/5j4amy1n9q6SqpNz7rU1h5q63IcaYd+rm2/af0sdh9mu8kYtpu8AUqSvzOhayOW23tk6GCslUFtXSXVpmddamsPtXU5jrRDP9dGMxoLSI899li1zCNGtbyeb7t7+umnYw+UKX+hXP7OhHrmm+184YFPp288+tnYKoPayqtNz9TWNmpzHGmTfq6NZtz9wgsv/ODQoTpZ3778JbA//vGP06VLl6rtvMzbb7/9dvra176W8t/5la98pZqMIe/Pr6tXr1bbd/L/d7MrV65Uy8OHD1dLynD9end2mN34N7DXvnx4IF259pd0bf1vsedG+UD7/We+lD55z8diTznUVl5teqa2tlGb40ib9HNt+0mvziN3/AzSXvEMUpn65RmkzV659E76zepaWn7nvWr7wcF7qyH6fBXq7rtufbWq7era3ny7O7nK5z830He19Vvf9KxM+lamfu2bntFWvTqPFJDoqX4MSPuBvpVHz8qkb2XSt/LoWZl61bdGp/kGAAAoiYAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgNB4QJqYmLjhNTMzEz8BAABol0YDUg5Eo6OjaXZ2tnqdPHkyzc/PC0kAAEArNRaQFhcXq+WRI0eqZTY2NpaGhobS2tpa7AEAAGiPxgLS/fffXy0vX75cLbOVlZW0urqaDh48GHsAAADao7GANDw8nI4fP17dUjc5OVmNKJ0+fbq65e7EiRPxLgAAgPY40Ol0NkZGRmJz9+VgdP78+dhK1bNIu2FhYaFaDg4OVksAAKD/NZldskYnaZiamqrC0ZkzZ6pglJ8/yhM3zM3NxTsAAADao7ERpDxTXb69LoejfLtd7dy5c2lpaWnHI0n1CNL4+Hi1pAzLy8vVsunkz+7St/LoWZn0rUz6Vh49K1Ov+tbYCFKeqW5gYOCGcJSZoAEAAGirxgJSvp1ufX39n26ny6NK+WcAAABt01hAOnbsWDWL3YULF6rnjupXnsXu7Nmz8S4AAID2aHSShhyS8rNGm1+nTp2KnwIAALRLowEJAACgJAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAOdDqdjZGRkdgsx8LCQrUcHx+vlv3gtdevpcXX302Xr/652n5w8N40OnwoPfHIYLVdsrq2t367Vm0/9MDBvqtN38rSr33TszLpW5n6uW/9bnl5uVqWeA68n/WqbwJSC/z1/b+n6Z+9lX75xrux50ajI59Jk998KA186uOxpxxqU1vb9Gtteqa2tlFbmbXtFwJSmXrVN7fYtcCtDrIpbaSl5T+mH778ZmyXRW1qa5t+rU3P1NY2aiuzNkBA2nN5eH77g2x2oPrz15evp5//6nfVeinUpra26dfa9ExtbaO2MmsDugSkPZbvXb5dSyvXY60MautSW3v0a2161qW29lBbV2m1AV0C0h6rH1q9HcvvvBdrZVBbl9rao19r07MutbWH2rpKqw3oEpAAAACCgLTH8nSnt+ujvLcN1Naltvbo19r0rEtt7aG2rtJqA7oEpD2Wvy+hayOW23tk6GCslUFtXWprj36tTc+61NYeausqrTagS0DaY/nL5PL3JdSz3mznCw98On3j0c/GVhnUpra26dfa9ExtbaO2MmsDuu5+4YUXfnDoUH01pBxXrlyplocPH66WJfvy4YF05dpf0rX1v8WeG+WD7Pef+VL65D0fiz3lUJva2qZfa9MztbWN2sqsbb+4fr07w2CJ58D7Wa/6dqDT6WyU+C3CCwsL1XJ8fLxa9oNXLr2TfrO69sGsN/ne5Tw8n69A3X3Xra9UtV1d25tvr1Xbn//cQN/Vpm9l6de+6VmZ9K1M/dy3fre8vFwtSzwH3s961TcBiZ5yQCqTvpVHz8qkb2XSt/LoWZl61TfPIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIPQlIExMTN7xmZmbiJwAAAO3RaEBaXFysAtHRo0fT7OzsB68TJ07EOwAAANqj0YD00ksvpdHRUYEIAAAoQmMBaWVlJa2vr6cjR47EHgAAgHZrLCC98cYb1fLixYs3PH80OTlZ7QcAAGibA51OZ2NkZCQ2d8/c3Fy6cOFC9fzR5lvsckgaGhpKZ8+ejT13ZmFhoVoODg5WSwAAoP81kV02a3wWu8ceeyzWunJgWl1djS0AAID2aHwE6eTJk2lsbCz2pmqK7/n5+Wo2u52oR5DGx8erJWVYXl6ulk0nf3aXvpVHz8qkb2XSt/LoWZl61bfGRpAefvjhann9+vVqWVtbW0sDAwOxBQAA0B6NBaTh4eHqWaM8ilTL34u0tLRU3WYHAADQNo0+g5QnYsijRfUMdufPn69uuTt27Fi8AwAAoD0an6Rhenq6et6ofm1+HgkAAKBNGg9IAAAApRCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgHCg0+lsjIyMxGZzpqam0urqahodHU2nTp2KvXduYWGhWo6Pj1dLyrC8vFwte/Fvrldee/1aWnz93XT56p+r7QcH702jw4fSE48MVtslq2t767dr1fZDDxzsu9r6rW96ViZ9K1O/9k3PaKtenUf2JCDNzMykS5cuVetDQ0MC0j7WTwHpr+//PU3/7K30yzfejT03Gh35TJr85kNp4FMfjz3lUFt5temZ2tpGbY4jbdLPte0nvTqPbPwWu5WVlTQ/P5+effbZ2AP94VYH2pQ20tLyH9MPX34ztsuitvJq0zO1tY3aHEfapJ9rY/c1HpBefPHF6ra6sbGx2APly0P02x9oswPVn7++fD39/Fe/q9ZLobbyatMztbWN2hxH2qSfa6MZjQakubm56rmj3bilDtok3798u5ZWrsdaGdTWVVJtetaltvZQW5fjSDv0c200o9FnkCYmJtLx48fTsWPHqu3JycldfwZpcNBDdfTef778+/Te//5fbN3av9xzVzr97+X8O1VbV0m16VmX2tpDbV2OI+3Qz7XtV8U+g3Tu3LkqDNXhCAAAoO0aG0HKo0Xr6+ux9c9Onjy5o+eSzGJXpn6Zxe6/fvQ/6b/f+kNs3dq/PXgo/cfEV2Or/dTWVVJtetaltvZQW5fjSDv0c237TfGz2E1PT6fZ2dkbXgMDA9WEDXndpA2ULH9nQtdGLLf3yNDBWCuD2rpKqk3PutTWHmrrchxph36ujWY0Posd9KP8hXL5OxPqmW+284UHPp2+8ehnY6sMaiuvNj1TW9uozXGkTfq5NpohIMEdyl8o99V/3f5KUz7Qfv+ZL6W777r1AbmN1FZebXqmtrZRm+NIm/Rzbey+Rmexa5JnkMrUL88gbfbKpXfSb1bX0vI771XbDw7eWw3R56tQpR9o69refHut2v785wb6rrZ+65uelUnfytSvfdMz2qpX55ECEj3VjwFpP9C38uhZmfStTPpWHj0rU6/65hY7AACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIDQakObm5tLExMQNLwAAgLZqLCCtrKykCxcupNnZ2Q9emZAEAAC0VWMBaXh4+INQVDt69Gi1XFxcrJYAAABt4hkkAACA0NOAtLq6Wi3HxsaqJQAAQJsc6HQ6GyMjI7HZnHxb3fnz56vb7E6cOBF779zCwkK1HBwcrJYAAED/azq79GwEKYejoaGhXQlHAAAATejJCFKeuW5gYCBNT0/Hnp2rR5DGx8erJWVYXl6ulr0YtWT36Ft59KxM+lYmfSuPnpWpV31rfARpcnJy18MRAABAExoNSDkcra+vC0cAAEARGgtIc3NzVTjK8i12m19TU1PVfgAAgDbp2Sx2u80zSGVyz2+Z9K08elYmfSuTvpVHz8rUq7719HuQAAAA2kxAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAADCgU6nszEyMhKb5VhYWKiW4+Pj1bIfvPb6tbT4+rvp8tU/V9sPDt6bRocPpSceGay2S1bX9tZv16rthx442He16VtZ+rVvelYmfStTP/et3y0vL1fLEs+B97Ne9U1AaoG/vv/3NP2zt9Iv33g39txodOQzafKbD6WBT3089pRDbWprm36tTc/U1jZqK7O2/UJAKlOv+uYWuxa41UE2pY20tPzH9MOX34ztsqhNbW3Tr7XpmdraRm1l1gYISHsuD89vf5DNDlR//vry9fTzX/2uWi+F2tTWNv1am56prW3UVmZtQJeAtMfyvcu3a2nleqyVQW1damuPfq1Nz7rU1h5q6yqtNqBLQNpj9UOrt2P5nfdirQxq61Jbe/RrbXrWpbb2UFtXabUBXQISAABAEJD2WJ7u9HZ9lPe2gdq61NYe/VqbnnWprT3U1lVabUCXgLTH8vcldG3EcnuPDB2MtTKorUtt7dGvtelZl9raQ21dpdUGdAlIeyx/mVz+voR61pvtfOGBT6dvPPrZ2CqD2tTWNv1am56prW3UVmZtQNfdL7zwwg8OHaqvhpTjypUr1fLw4cPVsmRfPjyQrlz7S7q2/rfYc6N8kP3+M19Kn7znY7GnHGpTW9v0a216pra2UVuZte0X1693Zxgs8Rx4P+tV3w50Op2NEr9FeGFhoVqOj49Xy37wyqV30m9W1z6Y9Sbfu5yH5/MVqLvvuvWVqrara3vz7bVq+/OfG+i72vStLP3aNz0rk76VqZ/71u+Wl5erZYnnwPtZr/omINFTDkhl0rfy6FmZ9K1M+lYePStTr/rmGSQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIAhIAAEAQkAAAAIKABAAAEAQkAACAICABAAAEAQkAACAISAAAAEFAAgAACAISAABAEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAofGANDU1lSYmJj54zc3NxU8AAADapdGANDk5WS1nZ2er1/Hjx9OFCxeEJAAAoJUaC0g5BK2vr6fnn38+9qR07NixNDQ0lJaWlmIPAABAezQWkFZXV9PAwEAaHh6OPV05IOWfAQAAtE1jASmPHt3KyspKrAEAALTDgU6nszEyMhKbuydPzpCdPXu2WtbyrXf5OaQzZ8780+jSR7GwsBBrAADAfjA4OJiayC6bNTpJw9raWqz9w4eNLN2u8fHxWAMAAPaDpsNR1tgI0rlz56pnjaanp2NP18zMTJqfn69mtQMAAGiTxkaQ8mQMebTo5meNcmjKPwMAAGibxgJSntI7e/HFF6tllkePckB68sknYw8AAEB7NHaLXW1iYiLWunY6OQMAAEBTGg9IAAAApWh0FjsAAICSCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAAAQBCQAAIAgIAEAAAQBCQAAIAhIAAAAQUACAAAIBzqdzsbIyEhslmFmZibNz8/HVkqjo6Pp1KlTsUUb3dyzgYGBND09HVu03eLiYjp//ny1fubMmTQ8PFyt016Tk5NpfX09thwn227z71jt5MmTaWxsLLZoi6mpqbS6urptf27+3dPHvbeyspJOnz697bnHzT07evRoOnHiRGyxV+pzxw/rx7lz59LS0lIaGhpKZ8+ejb07U9wIUv6PkP9jzc7OVq98spb/o+T9tFP+4L906dINPcsHonxAogz5xC0feGi/fCIwMTFR9av+ncsv4ai96nB0/PjxD/qVTwjyvvwz2iH3Iv9u5XC0nZt/9/Rx7+XzwxyOtpN//uijj97Qs3yemU/O2Tv5d2nzhfXtzM3NfRCOdlNRASl/8Of/CPlDpJavZOd/zHk/7ZSvnG2+YpN7lq9m55CUe0q75Q+PfODJPaP9XnzxxapfAlE5Ll++XC2PHTtWLbP6aun169erJXsvB518HMwjQlupT6g3/+7lPuZRi4sXL8Yeeqk+ec492+4zLPdr8+hEvX6rIEyz8iht/r3JgfXDXLhw4YZcsFuKCkhvvPFGtXz44YerZe3BBx+slq7QwO7Kv1P5w+X555+PPbRd/lAXZsuSTwSyzZ9h+cQuO3ToULVk7+WTtVtdeMi/e1tdxc77nGzvjXzRIffNLY5lybfJ3c5jGPUF3M0Xl3ZLUQFp8/2hW3GlrRz5wyKfFHiWpd1eeumlaoRWn8pQn2Dn3698e8LmF+2VP9xzqM0jFPkDP49E1FdFndiVY21tLdb+2Yedv9Ae9XF0q7BLezR9AbfIWexuPlm7//77Y40S5Cuj+cMin3jTXvXtIrd6MJL2qu+nz698McIzf+2WRybq28XzffdNXRWlWfVo4GYHDx6MNUrw6quvVkuffe3W9AXcIgPSzc+tXLt2LdZou9y7fGU0Xy314d9euU/5JO3ZZ5+NPZTkyJEjsdaVP0Q889dueZRv82Q29SignpVlq5GiW40s0S75wmD+3dvuOTPaoRcXcIsKSFtdmdnMvdrtlj/o80wy+cqoB8jbrX7eL9/yU9+ilYNtlnuYH6CkvdxuXJb6geTN99zXI3950g3KcKuRog87f2Hv5ZPufGHQra3tl0NsvhhRn5/kV95XX1iqn+HciaICUj05Q33yVqtnAPIPut3qcLRbc9TTnPrB1s2vepaYPE27HrZTfQy8+Sp2ve1ZsnbKIwxbPe/g1qyy5B7mE7Sb5X1b9Zf2yCfUdThyd0v75XOQm89R8u9YfuX13ehhUQEpf7jn4usr2Vl+SCv/o/Y8S7vlRJ+voDmxhmbl21fzMbG+Nau+XdIxsr3y51p+9mjz7XT5s82JdVkee+yxapkn2qjl9XyB4umnn449tE0OR/m8Mh8jhSNqBzqdzsbIyEhslqH+FuuaxN9u9bD1VvLJnNvtylB/iOQRJCMR7eYYWZ58Ip1D0mb61i75Qt9WNn+O1beSb5avaLM36s+treTnjPKoe57AZqtnx7L6PfTWzZ9htZtvRd6svvV/ty7EFxmQAAAAmlDkLHYAAABNEJAAAACCgAQAABAEJAAAgCAgAQAABAEJAAAgCEgAAABBQAIAAAgCEgAAQBCQAAAAgoAEAABQSen/AaEIdmHe1iL6AAAAAElFTkSuQmCC


INDEXXY起始坐标X起始坐标X
11111
221
331同行中X的间隔不同行间的X间隔
44112
551
661行数列数1
771410
881
991
10101
1134
1244
1354
1464
1574
1684
1794
18104
19114
20124
2117
2227
2337
2447
2557
2667
2777
2887
2997
30107
31310
32410
33510
34610
35710
36810
37910
381010
391110
401210

wqx285314590 发表于 2020-3-9 22:50:37

数据有点乱码，图片也没有显示，不知道如何上传附件，愿意帮忙的鱼油请留言，我可以把数据发到你邮箱，谢谢！

XiaoPaiShen 发表于 2020-3-9 23:25:54

本帖最后由 XiaoPaiShen 于 2020-3-9 23:32 编辑

wqx285314590 发表于 2020-3-9 22:50
数据有点乱码，图片也没有显示，不知道如何上传附件，愿意帮忙的鱼油请留言，我可以把数据发到你邮箱，谢谢 ...

用鱼币悬赏，不是更简单吗？
另外，你的需求实在看不明白。

派生小生 发表于 2020-3-9 23:50:02

可以发数据到我qq邮箱：569673855


你给的例子是不是有问题，行数4，列数10，例子实际行数超过10，列数只有3；
数据有点乱，有示意图就更好了；

LYF511 发表于 2020-3-10 09:23:11

https://imgchr.com/
这个网站上传图片
https://s2.ax1x.com/2020/03/10/8C6Lex.png
这样上传到鱼C：https://s2.ax1x.com/2020/03/10/8C6Gzd.png

永恒的蓝色梦想 发表于 2020-3-10 11:11:55

看不懂题目，可以详细说一说吗？

wqx285314590 发表于 2020-3-13 17:26:19

本帖最后由 wqx285314590 于 2020-3-13 17:46 编辑

XiaoPaiShen 发表于 2020-3-9 23:25
用鱼币悬赏，不是更简单吗？
另外，你的需求实在看不明白。

不知道如何用鱼币悬赏。。。

我自己写了一部分，问题可以简化成：
1.如何让while 内的循环体（line5到13）执行指定次数，我想的是引入j，j+=1，j<3，那么while循环可以执行3次，但是出来的结果不是我想要的。或者j<30，也不对
x=
count=0
j=0
while j<3:
      if count<10:
          x+=1
          print(x)
          count+=1
      else:
          if count<20:
            x+=1
            print(x)
            count+=1
2.y想要输出的是连续10个1，10个3，10个5....以此类推。我写的只能实现10个1，不能循环，不能递增，请指教。
y=1
count=0
times=0
while times<4:
      times-=1
      while count<10:
          count+=1
          print(y)
      y+=2

wqx285314590 发表于 2020-3-13 17:35:10

派生小生 发表于 2020-3-9 23:50
可以发数据到我qq邮箱：569673855




我自己写了一部分，问题可以简化成：
1.如何让while 内的循环体（line5到13）执行指定次数，我想的是引入j，j+=1，j<3，那么while循环可以执行3次，但是出来的结果不是我想要的。或者j<30，也不对
x=
count=0
j=0
while j<3:
    if count<10:
      x+=1
      print(x)
      count+=1
    else:
      if count<20:
            x+=1
            print(x)
            count+=1

wqx285314590 发表于 2020-3-13 17:42:34

派生小生 发表于 2020-3-9 23:50
可以发数据到我qq邮箱：569673855




y想要输出的是连续10个1，10个3，10个5....以此类推。我写的只能实现10个1，不能循环，不能递增，请指教。
y=1
count=0
times=0
while times<4:
    times-=1
    while count<10:
      count+=1
      print(y)
    y+=2

wqx285314590 发表于 2020-3-13 17:43:53

永恒的蓝色梦想 发表于 2020-3-10 11:11
看不懂题目，可以详细说一说吗？

我自己写了一部分，问题可以简化成：
1.如何让while 内的循环体（line5到13）执行指定次数，我想的是引入j，j+=1，j<3，那么while循环可以执行3次，但是出来的结果不是我想要的。或者j<30，也不对
x=
count=0
j=0
while j<3:
   if count<10:
         x+=1
         print(x)
         count+=1
   else:
         if count<20:
             x+=1
             print(x)
             count+=1
2.y想要输出的是连续10个1，10个3，10个5....以此类推。我写的只能实现10个1，不能循环，不能递增，请指教。
y=1
count=0
times=0
while times<4:
   times-=1
   while count<10:
         count+=1
         print(y)
   y+=2

wqx285314590 发表于 2020-3-13 17:47:15

LYF511 发表于 2020-3-10 09:23
https://imgchr.com/
这个网站上传图片



好的，感谢！

派生小生 发表于 2020-3-14 00:48:53

其实我不是很理解你的意思，但是如果只是要输出你说的数据还是很容易的

派生小生 发表于 2020-3-14 00:50:50

x_list=
count=0
j=0
x = x_list
print("以下为x的数据：")
while j<4:
    if x == 0:
      for i in range(10):
            x +=1
            print(x)
      j += 1
      x = x_list
    elif x == 3:
      for i in range(10):
            print(x)
            x+=1
      j += 1
      x = x_list
print("以下为y的数据：")
y = 1
i = 0
while i < 4:
    for m in range(10):
      print(y)
    i += 1
    y += 2

派生小生 发表于 2020-3-14 00:52:36

x_list=
count=0
j=0
x = x_list
y = 1
print("以下为x,y的数据：")
while j<4:
    if x == 0:
      for i in range(10):
            x +=1
            print(x,y)
      j += 1
      x = x_list
      y += 2
    elif x == 3:
      for i in range(10):
            print(x,y)
            x+=1
      j += 1
      x = x_list
      y += 2

   


如果是想要x，y的数据一起的话就是这样

派生小生 发表于 2020-3-14 00:54:23

如果要实现你题目中的输入数据自动生成，只要把相应的变量变成参数就可以了

wangka 发表于 2020-3-14 07:07:14

XiaoPaiShen 发表于 2020-3-9 23:25
用鱼币悬赏，不是更简单吗？
另外，你的需求实在看不明白。

他等级太低

wangka 发表于 2020-3-14 07:08:10

你要重复一下

wqx285314590 发表于 2020-3-14 12:23:44

派生小生 发表于 2020-3-14 00:50


感谢您的回复！还有一点不明白：
单独对比我用的
while count<10:
      count+=1
      print(y)
和你用的
for i in range(10):
      print(y)
功能相同，为什么放在while 循环中我写的就不能执行循环，但你的就可以呢？

wqx285314590 发表于 2020-3-14 12:25:35

wangka 发表于 2020-3-14 07:07
他等级太低

难怪，昨天还找半天哪里可以用鱼币

wqx285314590 发表于 2020-3-14 12:43:36

派生小生 发表于 2020-3-14 00:50


还有一个问题：
您的代码是通过if else进行x==0或x==3的切换，但是单独把相关的几行拎出来就只有一个输出0，请问为什么?
x_list=
x = x_list
if x == 0:
    print(x)
    x = x_list
elif x == 3:
    print(x)

查看完整版本: 有偿请教大佬，如何利用python处理excel，有偿请教!