且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从SQL Server表加载Excel文件并读取单元格

更新时间:2023-02-13 17:15:39

首先,您需要提取Excel数据并将其写入Excel文件(.xls或.xlsx,具体取决于在原始文件上).以下链接有一个示例:

First, you will need to extract the Excel data and write it to an Excel file (.xls or .xlsx depending upon the original file). The below link has an example:

http://*** .com/questions/17613214/how-to-to-retrieve-varbinary-values-from-sql-server-2008-using-vb-net

保存文件后,您可以使用Excel Automation或数据访问(OLEDB)提取数据.知道您需要提取哪些数据可能会有所帮助.

After the file has been saved you can extract the data using either Excel Automation or data access (OLEDB). It would probably help to know what data you need to extract.