python可以读取电子表格中单元格的值吗? [英] Can python read the value of a cell in a spreadsheet?

问题描述

全部

python可以读取电子表格中单元格的值吗?

Can python read the value of a cell in a spreadsheet?

从制图/GIS/分析的角度来看:最简单的示例是在给定shapefile(GIS数据集)上运行缓冲(接近)工具的脚本.

From a mapping/GIS/analysis standpoint: the simplest example would be a script that ran a buffer (proximity) tool on a given shapefile (GIS dataset).

对于缓冲区距离参数，脚本将指向电子表格单元格中的值(不建议使用开放式或开放式办公室)，而不仅仅是使用"1000"英尺这样的数字.

For the buffer distance parameter, instead of just using a number like '1000' feet, the script would point to a value in a cell of a spreadsheet (libre or open office preferred).

如果有一种方法可以通过按钮从电子表格中触发脚本，那将是下一步(然后下一步是在电子表格中具有一个地图控件以查看更新的结果！)

If there was then a way to trigger the script from the spreadsheet by way of a button, that would be the next step (then the next step would be to have a map control inside the spreadsheet to see the updated results!)

只是为了让我了解我要做什么:我想使用电子表格作为分析仪表板"，用户可以在其中使用不同的参数进行分析-公园附近(杂货店等)附近会发生什么? .)在1/2英里和1/4英里之间...那么电子表格中的另一张纸会对该邻近区域内的人口统计数据进行细分.

Just to give some insight into where I'm going with this: I'd like to use a spreadsheet as an analysis 'dashboard' where users could run analysis with different parameters - what would proximity around parks (grocery stores, etc.) be at 1/2 mi vs 1/4 mi...then another sheet in the spreadsheet would have a breakdown of the demographics within that proximity.

谢谢！

(也发布在这里: https://gis.stackexchange.com/questions/49288/can-python-read-the-value-of-a-cell-in-a-spreadsheet )

-mb

推荐答案

有一些很棒的Python-Excel工具可用: http://www.python-excel.org

There are a few great Python-Excel tools available: http://www.python-excel.org

这篇关于python可以读取电子表格中单元格的值吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！