Excel 可以根据网站上的变量填写某些字段吗？
我们的电子商务平台目前不会创建发票。我有一个目前在 Excel 中使用的发票模板，因此我基本上只是将大约 8 个点的数据从电子商务平台复制并粘贴到电子表格中，然后将其打印出来。
尽管电子商务平台不创建发票，但该数据可以发送到我想要的任何地方，包括网站或电子邮件，因此我使用它通过电子邮件自动通知我某些购买。
我想知道的是，由于变量（例如 user_address）始终与从平台发送的变量相同，因此该信息是否可以以某种方式发送到 Excel 电子表格（我的模板），然后由适当的变量填充，所以剩下要做的就是打印出来吗？
我并不是真正的程序员，因此您可以提供任何代码片段或关于这是否需要程序员的一些想法将不胜感激。
Our ecommerce platform will does not currently create invoices. I have an invoice template that I currently use in excel, so I essentially just copy and paste about 8 points of data from the ecommerce platform to the spreadsheet, then print it out.
Even though the ecommerce platform does not create invoices, that data can be sent anywhere I would like, including a website or email, so I've used it to automatically notify me of certain purchases via email.
What I am wondering is since the variables (eg. user_address) are always the same that are sent from the platform, can that information somehow be sent to an excel spreadsheet (my template), which will then be populated by the appropriate variables, so all that's left to do is print it out?
I'm not really a programmer, so any code snippets you can provide or some idea of whether or not this will take a programmer would be appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
是的，查看 Apache POI，这可以让你用 Java 创建一些东西，也许是一个 servlet，它可以捕获来自电子商务应用程序的数据并制作电子表格。
或者，您可以制作一个 Google 电子表格和关联的表单，并用您喜欢的任何语言编写一些中间脚本，以便将正确的帖子变量从电子商务应用程序发送到 Google 表单。我希望这个解决方案的参与度会少得多。
Yes, check out Apache POI, this would let you create something in Java, perhaps a servlet, that would catch the data from your ecommerce app and make a spreadsheet.
Alternatively you could make a Google Spreadsheet and an associated form and write some intermediary script in whatever language you like that will send the right post variables to the Google form from the ecommerce app. I would expect this solution to be much less involved.
我建议查看 JExcel 等 API，它允许您使用 Java 读取/写入 Excel 文件的单元格。如果您将数据发送到 Excel 文件，然后使用此包将其取出，您可以获得所需的结果。尽管不会涉及很多工作，但您可能仍然需要程序员来执行此方法。
I would suggest taking a look at APIs like JExcel, which lets you read/write cells of an Excel file using Java. If you send your data to an Excel file, and then pull it out using this package, you could get the desired results. You may still need a programmer for this method, although there would not be a lot of work involved.