想搞个价签打印，查询数据需要好久才出来，太慢了，大神们帮改改

zpy2

清茶小孩 发表于 2021-10-30 11:40
非常感谢，数据库是明显很快了！

[url=http://e.anyoupin.cn/?s=select * from 条码商品名称明细表 where 条形码 like '6954767417035']http://e.anyoupin.cn/?s=select * from 条码商品名称明细表 where 条形码 like '6954767417035'[/url]

试试这个 理论上 网络好 感觉不到查询的时间。


可以用webservice公式
=webservice("http://e.anyoupin.cn/?s=select * from 条码商品名称明细表 where 条形码 like '" & a2 & "'")

取数

清茶小孩

zpy2 发表于 2021-10-30 15:43
http://e.anyoupin.cn/?s=select * from 条码商品名称明细表 where 条形码 like '6954767417035'

试试 ...

感谢，网上很快，但我有好多是自编码的，不是正规码，这个处理起来有点麻烦，第二个问题就是，没有价格！

zpy2

Yalishanda30 发表于 2021-10-30 10:35
单个查询修改好了，查询一个速度不慢，50条12秒
把数据放到access数据库速度明显快很多

[url=http://e.anyoupin.cn/?s=select * from 条码商品名称明细表 where 条形码 in ('6954767425979','6954767416274','6915766003605','6954767417684','6954767422473','6915766004084','6954767410586','6954767410500','6954767430508','6915766003391','6915766000109','6915766000383','6915766000796','6915766001793','6954767432076','6930270200173','6930270200180','6954767442778','6930270201170','6930270201576','6954767433073','6954767430386','6954767430188','6954767433776','6954767434674','6954674472783','6954767430218','6954767430423','6954767435930','6954767430461','6915766000291','6915766000390','6915766002905','6915766002929','6915766003018','6954767442075','6930270201347','6954767441481','6954767447278','6954767449371','6954767447476','6953392520332','6954767442471','6954767493237','6915766003629','6954767441788','6954767494982','6954767493473','6954767430522','6926273300781','6926273300378')]http://e.anyoupin.cn/?s=select * from 条码商品名称明细表 where 条形码 in ('6954767425979','6954767416274','6915766003605','6954767417684','6954767422473','6915766004084','6954767410586','6954767410500','6954767430508','6915766003391','6915766000109','6915766000383','6915766000796','6915766001793','6954767432076','6930270200173','6930270200180','6954767442778','6930270201170','6930270201576','6954767433073','6954767430386','6954767430188','6954767433776','6954767434674','6954674472783','6954767430218','6954767430423','6954767435930','6954767430461','6915766000291','6915766000390','6915766002905','6915766002929','6915766003018','6954767442075','6930270201347','6954767441481','6954767447278','6954767449371','6954767447476','6953392520332','6954767442471','6954767493237','6915766003629','6954767441788','6954767494982','6954767493473','6954767430522','6926273300781','6926273300378')[/url]
50个用in 拼接后应该会快些

zpy2

清茶小孩 发表于 2021-10-30 17:10
感谢，网上很快，但我有好多是自编码的，不是正规码，这个处理起来有点麻烦，第二个问题就是，没有价格！

价格，见图 有的，根据你的 商品 来的。

另外，50个，用in 拼接后会快些。

select * from 条码商品名称明细表 where 条形码 in ('6954767425979','6954767416274','6915766003605','6954767417684','6954767422473','6915766004084','6954767410586','6954767410500','6954767430508','6915766003391','6915766000109','6915766000383','6915766000796','6915766001793','6954767432076','6930270200173','6930270200180','6954767442778','6930270201170','6930270201576','6954767433073','6954767430386','6954767430188','6954767433776','6954767434674','6954674472783','6954767430218','6954767430423','6954767435930','6954767430461','6915766000291','6915766000390','6915766002905','6915766002929','6915766003018','6954767442075','6930270201347','6954767441481','6954767447278','6954767449371','6954767447476','6953392520332','6954767442471','6954767493237','6915766003629','6954767441788','6954767494982','6954767493473','6954767430522','6926273300781','6926273300378')

清茶小孩

zpy2 发表于 2021-10-30 17:15
价格，见图 有的，根据你的 商品 来的。

另外，50个，用in 拼接后会快些。

我是2016版的，是不是支持webservice公式  ？

zpy2

清茶小孩 发表于 2021-10-30 17:47
我是2016版的，是不是支持webservice公式  ？

嗯，wps没有这个函数

zpy2

zpy2 发表于 2021-10-30 17:52
嗯，wps没有这个函数

只能拼接好sql浏览器访问了。

清茶小孩

zpy2 发表于 2021-10-30 17:55
只能拼接好sql浏览器访问了。

我换上了2016的也不行

zpy2

清茶小孩 发表于 2021-10-30 18:07
我换上了2016的也不行

http://e.anyoupin.cn/search_code

先用这个试试


获取的是html,还要结合filterxml才能抽取具体的单元格

querytable有个导入网页，也可以试试。

清茶小孩

zpy2 发表于 2021-10-30 18:36
http://e.anyoupin.cn/search_code

先用这个试试

这样查询确实快