要求提供编码的答案 [英] request for answer with coding

问题描述

是否可以通过使用浏览按钮将MicrosoftExcel中的数据导入VB.Net表单?

Can we bring data from MicrosoftExcel to a VB.Net form by using a button Browse?

推荐答案

是的，可以.

Google的阅读Excel VB.NET"，您将获得大量结果.

通常的技巧包括通过RCW使用Excel的COM接口，转换为CSV，然后直接进行解析，通过ODBC/OleDB进行连接，甚至使用可以直接读取和解析Excel的第三方API.选择哪种取决于您的要求和方案.

Yeah, you can.

Google for "Reading Excel VB.NET" and you''ll get tons of results.

The usual tricks involve using Excel''s COM interface via RCW, converting to CSV and then parsing that directly, connecting via ODBC/OleDB, and even using 3rd party API that can directly read and parse Excel. What you choose will depend on your requirements and scenario.

简短的回答-是的.只需尝试一下，然后在实施过程中遇到您遇到的问题即可.

Short answer - yes. Just give it a try and come back with problems you face during implementation.

这篇关于要求提供编码的答案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！