如何在客户端读取excel文件中的内容

[telstar]

excel文件是多sheet的，且可能未装office

[ilovejolly]

mark

[ggygd]

Mark

[wxqq2001]

try:
' <summary>
' 读取Excel文件
' </summary>
' <param name="dt">要转换为Excel文件的表</param>
' <param name="page">页面Page对象,用法: 将me.Page传递过来即可</param>
' <return>数据集DataSet</return>
Public Function ReadExcelFileToDataSet(ByVal strFileName As String) As DataSet
Try

'建立一个专门存放Excel文件的目录
If Directory.Exists(Page.Server.MapPath("ExcelFolder")) = False Then
Directory.CreateDirectory(Page.Server.MapPath("ExcelFolder"))
End If

Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Page.Server.MapPath(".") & "\ExcelFolder\" & strFileName & ";" & "Extended Properties=Excel 8.0;"
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection(strConn)
Dim strExcel As String = "select * from [sheet1$]"
Dim ds As DataSet = New DataSet
conn.Open()
Dim adapter As OleDbDataAdapter = New OleDbDataAdapter(strExcel, strConn)
adapter.Fill(ds)
Return ds
Catch ex As Exception
Throw ex
End Try
End Function

[wxqq2001]

C#操作Excel（导入导出）- -

///
/// 读取Excel文档
///
/// 文件名称
/// 返回一个数据集
public DataSet ExcelToDS(string Path)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
DataSet ds = null;
strExcel="select * from [sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds,"table1");
return ds;
}

[liujun9601728]

一群白痴,人家明明问的是在客户端怎么读取,你们这些煞笔就是要写一些服务器端的代码,哎!!!!

[fengfangfang]

上传到服务器端读

要非在客户端读,就直接用excel打开,没装就用写字板或记事本

[fengfangfang]

http://blog.csdn.net/fengfangfang/archive/2006/08/07/1033072.aspx

[telstar]

最后还是上传到服务器解决了
算了，结贴