Excel / Quickbooks 数据到 C#
我知道如何使用 OleDbConnection 类打开 Excel 文件并从中进行选择,但是有没有一种简单的方法可以从已读入 Stream 的 Excel 文件中读取数据? QuickBooks 是否也有类似的方法?
I know how to use the OleDbConnection class to open an excel file and select from it, but is there a simple method to read the data from an excel file that has been read into a Stream? And is there also a similar method for QuickBooks?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
溪流? 不,Excel 文件非常复杂。 快速手册,是的。 我找到了这个 ODBC 驱动程序,它应该支持 OdbcDataAdapter。
Stream? No, Excel files are a complicated mess. Quickbooks, yeah. I found this ODBC driver, it should support OdbcDataAdapter.
您还可以查看各种 QuickBooks 集成选项,这些选项允许您通过 XML 请求和响应与 QuickBooks 进行通信。 有关 QuickBooks SDK 的更多详细信息,请参见此处:
http://developer.intuit.com/
开发者论坛:
http://idnforums.intuit.com/categories.aspx?catid= 56&entercat=y
VB .NET Framework 此处:
http://idnforums.intuit.com/messageview。 aspx?catid=56&threadid=11040&enterthread=y
You can also look at various QuickBooks integration options, which allow you to communicate with QuickBooks via XML requests and responses. More details on the QuickBooks SDK here:
http://developer.intuit.com/
Developer forums here:
http://idnforums.intuit.com/categories.aspx?catid=56&entercat=y
VB .NET Framework here:
http://idnforums.intuit.com/messageview.aspx?catid=56&threadid=11040&enterthread=y