asp.net怎麼做excel的導出/導入? asp.net怎麼做excel的導出/導入?要用什麼控件嗎?那有控件? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 倒入: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(); 导出: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(); 倒入: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);先得把文件上传到服務器阿.怎麼上传呢? 在导入后excel文件后自动保存在服务器上,相当于在服务器上建一个excel文件把数据导入到excel中 http://goody9807.611.cn/Announce/Announce.asp?BoardID=2&ID=1602 WPF 编辑GridViewColumn问题 asp.net 返回上一页 如何从一个sql表中读取多行数据插入到另一个表中? gridview 中textbox怎么取TEXT值 UniqueIdentifier的问题,大侠请进,思归,嘿嘿,求救!! ■■■如何从下列的html代码中提取信息 请大家推荐几款比较好的界面模板。如:主菜单界面、查询、增加、修改等 如何用JavaScript取得图片的长和宽?? 在字符串中我如何取出我所需要的字符串?? PB 程序员请进 , 急 ! 使网页无法后退的方法 问一个关于WORD打印处理的问题???
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();
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();
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);
先得把文件上传到服務器阿.怎麼上传呢?