寻求有关使用 php 将 excel 导入 mysql 的建议
好吧，看看我能不能从你们身上汲取智慧。
我目前正在做一个项目，所有信息都来自不同的客户，唯一的共同点是接收到的数据都是用excel完成的。他们提供的 Excel 电子表格只是一堆参考文献和代码，我面临的问题是我需要以某种格式输入参考文献和代码才能使网站正常工作。
完美的情况是去拜访每个客户并教导我如何需要数据，但由于客户数量众多，我无法这样做，更重要的是我会打断他们的工作流程。每个客户都有自己的代码和参考模型，他们不愿意改变他们的流程。
好消息是代码有一个标准模式，但我说的是接近 20 万个代码和一堆组合。
我们目前解决问题的方式是，我们派专人检查收到的每个 Excel 工作表，运行一些宏，并手动修复宏无法修复的代码。
做这件事的人已经精疲力尽和沮丧，我想用 php 自动化这个过程。
建议？
Alright, see if I can pick your brains from you all.
I'm currently working on a project where all the information comes from different clients, the only thing in common is that the received data is done with excel. The excel spread sheet that they present is just a bunch of references and codes, and the problem than I'm facing is that I need the references and codes to be entered in certain format in order for the website to work.
The perfect situation will be to go to each client and teach how I would need the data, but I can't do that because of the large number of clients, and more importantly I will be interrupting their work flow. Each client has its own codes and reference model and they are not willing to change their process
The good news is that there is a standard pattern for the codes, but I'm talking close to 200 thousand codes with a bunch of combination.
They way that we are currently solving the problem is that we have a person who checks each excel sheet received, runs a few macros, and manually fixes those codes in which the macro was not able to fix.
The person that is doing this, is already burn out and frustrated and I would like to automatize this process with php.
Suggestions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
有一个名为 PHPExcel 的好类，它允许您编写和读取各种文档类型：
http://www. codeplex.com/PHPExcel
您需要为 Excel 2007 文档启用 php_zip 扩展
There's a nice class called PHPExcel that allows you to write and read from a variety of document types:
http://www.codeplex.com/PHPExcel
You need to enable the php_zip extension for Excel 2007 documents
您可以使用 dbTube.org 来解决您的问题。您可以配置映射
在图形编辑器中。导入定义可以保存并重复使用。这是
无需更改 Excel 工作表。
问候安德烈亚斯
you can use dbTube.org to solve your problem. You can configure the mapping
in graphical editor. The import definition can be saved and reused. It is
not neccessary to change the excel sheet.
Greetings Andreas