JimBarry
亚博搜索yabovip28点com
‎04-10-2014
获得33个徽章
一周年纪念 探路者
查看所有获得的徽章
一个月前
1082 的帖子了
65 荣誉给
13 解决方案
166 荣誉收到
取消
显示结果
显示只有 | 而是搜索
你的意思是:

我的想法

(0份创意提交)

JimBarry的最新贡献

博客
1
0
113
博客
4
2
185
博客
0
0
430
博客
3.
0
1325
帖子
1
0
1145
帖子
0
0
1294
帖子
0
0
807
博客
1
0
1985
帖子

   

Ok so, how to deal with the contents of the Excel spreadsheet that may change from time to time, and which holds the full list of information about map book numbers, map page numbers, and PDF URLs. So, since this is a web page, that information is going to need to be http accessible, or readable by a web browser somehow.

If the number of map books is always going to be 1-N and the number of map pages is always going to be 1-999, and the URL paths to the PDFs are always going to follow some type of consistent naming pattern, like in my sample app above:  "https://///.pdf", then you don't really need to load the xlsx/csv.  If the mapbook and map number the user enters is valid, at that moment, then it'll return the PDF.

But... if the URL paths to the PDFs don't follow that kind of pattern, then I'm assuming in your xlsx, there's a mapbook column, a map number column, and a column that holds the URL where that map page is.  In which case converting the xlsx into a csv could be a way to go. Here is a sample that shows one way to read the csv.  Then, instead of drawing the csv to the page (like that sample does), you could read it all into a two-dimensional array, then when the user chooses a map book and map number, you do a lookup in that array, pull the correct URL out of the array, and open the PDF in the window.

Tons of different ways to do this. That's just one.

-->
好吧,那么,如何处理Excel电子表格的内容,可能会不时发生变化,并持有有关地图书号,地图页码和PDF url的完整信息列表。因为这是一个网页,这些信息需要通过http访问,或通过网络浏览器可读。如果地图书的数量总是1-N,地图页的数量总是1-999,并且pdf的URL路径总是遵循某种类型的一致命名模式,就像上面的示例应用程序:“https://<域>/<文件夹>/<地图-书-数字>/<地图-数字>.pdf”,那么您实际上不需要加载xlsx/csv。如果用户输入的地图簿和地图编号是有效的,那么它将返回PDF。 But... if the URL paths to the PDFs don't follow that kind of pattern, then I'm assuming in your xlsx, there's a mapbook column, a map number column, and a column that holds the URL where that map page is. In which case converting the xlsx into a csv could be a way to go. Here is a sample that shows one way to read the csv. Then, instead of drawing the csv to the page (like that sample does), you could read it all into a two-dimensional array, then when the user chooses a map book and map number, you do a lookup in that array, pull the correct URL out of the array, and open the PDF in the window. Tons of different ways to do this. That's just one. ...查看更多
0
0
770
帖子
0
2
770
活动提要
联系我
在线状态
离线
最后到访日期
一个月前