如何在ASP中上传Excel文件 [英] How to upload excel file in asp

问题描述

我正在使用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.

这篇关于如何在ASP中上传Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！