如何使用javascript查询excel数据 [英] How to query excel data using javascript

问题描述

我是JavaScript的新手，我正在尝试查询excel中的数据（比较使用我们在SQL中使用的s）。我能够阅读excel表格，但我无法阅读特定专栏。





我正在处理地理位置，如找到两点之间的最短距离并找到沿路线的坐标。我能够使用JavaScript实现这一点。



我有excel中的数据，包含坐标，事故，时间等变量......





现在我想将我在路线上找到的坐标与excel中的坐标进行比较，以便知道在该特定路线上发生了多少次事故。





有谁能建议我如何解决这个问题？



我尝试过：



我尝试使用JavaScript读取excel数据，但无法读取特定列并查询数据。

Hi ,


I am new to the JavaScript and i am trying to work on the querying the data in excel(comparing using like s we use in SQL). I am able to read the excel sheet but I am not able to read the particular column.


I am working on geographical locations like finding the shortest distance between the two points and finding the coordinates along the routes. I am able to achieve this using JavaScript.

I have the data in excel which contain variables like coordinate, accidents, time,...


Now I want to compare the coordinates which I found along the route with the coordinates in the excel so that I will know how many accidents happened in that particular route.


Can anyone suggest me how to approach this problem??

What I have tried:

I tried to read the excel data using JavaScript but not able to read particular columns and querying the data.

推荐答案

参见使用JavaScript阅读excel数据 - Google搜索 [ ^ ]。

这篇关于如何使用javascript查询excel数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！