如何创建一个读取Excel电子表格的Javascript程序？ [英] How do I create a Javascript program that reads an Excel spreadsheet?

问题描述

在开始之前，我想表达一个事实，即我是编码的初学者，所以我会接受任何建议/批评。



我有一个包含大约40,000行的Excel电子表格，每行都标明了一个城市的名称。在每一行中还有另外两列，每列都标明了城市的纬度和经度。我需要弄清楚如何创建一个读取Excel电子表格的Javascript程序，并在用户提示城市时将坐标保存到变量中。



任何人都可以给我提示或建议我应该做什么？



提前谢谢。

Before I start, I'd like to express the fact that I am a beginner at coding, so I will take any and all suggestions/criticism.

I have an Excel spreadsheet with some 40,000 rows, each stating the name of a city. In each row there are two other columns, each stating the latitude and longitude of the city. I need to figure out how to create a Javascript program that reads the Excel spreadsheet and saves the coordinates into variables when the user prompts the city.

Can anybody give me tips or advice as to what I should do?

Thanks in advance.

推荐答案

一些脚本做这已经存在了 -

解析和阅读excel文件 [ ^ ]

解析excel工作簿 [ ^ ]

Some scripts that do this already exist -
Parse and read excel files[^]
Parsing excel workbooks[^]

这篇关于如何创建一个读取Excel电子表格的Javascript程序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！