如何在ASP中上传Excel文件

本文介绍了如何在ASP中上传Excel文件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在使用visul Studio 2008和后端sql server2005.如何上传Excel文件-sheet1，以及如何在gridview中显示数据.

i am using visul studio 2008 and back end sql server 2005.How to upoload excel file-sheet1 and how to show the data in gridview.

推荐答案

ASP和ASP.NET是两个不同的东西. 通过让人们使用文件选择控件选择文件，您可以使人们上载文件.然后，您可以在后端访问数据.最好的选择是使用Microsoft Office工具从Excel文件中提取数据，为gridview创建可行的数据源.当然，您假设文件中只有一张纸. ASP and ASP.NET are two different things. You get people to upload a file by getting them to select it with a file selection control. Then you can access the data on the back end. Your best bet is to use Microsoft tools for office to extract the data from the Excel file, to create a viable data source for a gridview. Of course, you''re assuming there is only one sheet in the file.