asp.net怎麼做excel的導出/導入?

musicsoul 2005-09-19 10:46:10

asp.net怎麼做excel的導出/導入?
要用什麼控件嗎?那有控件?

...全文

206 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

musicsoul 2005-09-19

打赏
举报

xiaowangtian1117 2005-09-19

打赏
举报

导出：
string strPath=MapPath("ImportData");
string FileName=strPath+"\\"+"PIWS.xls";

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+FileName+";Extended Properties=Excel 8.0;";
// string sql = "Select Part,cast(SO as nvarchar(50)),Date,Prod,Qty from [PIWS$]";
// string sql = "delete from [PIWS$]";
string sql = "update [PIWS$] set Line='a' where SO='76085'";
System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection( connectionString );
System.Data.OleDb.OleDbCommand ad = new System.Data.OleDb.OleDbCommand(sql, connection );
// System.Data.OleDb.OleDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter( sql, connection );
// System.Data.DataSet dataSet = new DataSet();
connection.Open();
ad.ExecuteNonQuery();
connection.Close();

xiaowangtian1117 2005-09-19

打赏
举报

倒入：
int intV;
Random rd=new Random();
intV = rd.Next();
string strFileName=DateTime.Now.Second.ToString()+DateTime.Now.Millisecond.ToString()+intV+".xls";
string strPath=Page.MapPath("../uploading/"+strFileName);
FileStream f=new FileStream(strPath,FileMode.CreateNew, FileAccess.ReadWrite);
StreamWriter fw = new StreamWriter(f, System.Text.Encoding.GetEncoding("GB2312"));
string OutputString="";
int iRow;
int iCol;
for(iCol=0;iCol<tb.Columns.Count;iCol++)
{
OutputString=OutputString+"\t"+tb.Columns[iCol].Caption;
}
OutputString = OutputString.Trim();
fw.WriteLine(OutputString.Trim());
fw.WriteLine();
for(iRow=0;iRow<tb.Rows.Count;iRow++)
{
OutputString="";
for(iCol=0;iCol<tb.Columns.Count;iCol++)
{
OutputString=OutputString+"\t"+tb.Rows[iRow][iCol].ToString();
}
fw.WriteLine(OutputString.Trim());
}
fw.Close();
f.Close();