请问如何在asp.net中操作excel

stephenyk 2004-09-17 11:25:01

请问如何在asp.net中操作excel？？？

...全文

127 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

luckweb 2004-09-17

打赏
举报

Excel.Application

需要装office

stephenyk 2004-09-17

打赏
举报

我的目的是新建一个excel文档

stephenyk 2004-09-17

打赏
举报

我添加了，但是还是报错
adoApp = CreateObject("Excel.Application")------无法创建 ActiveX 组件

xiaoluzhu0420 2004-09-17

打赏
举报

当然了要在引用里面添加OWC。DLL了，在COM控件里面，OFFICE9。0

xiaoluzhu0420 2004-09-17

打赏
举报

导出EXCEL:try
{
OWC.SpreadsheetClass xlsheet = new OWC.SpreadsheetClass();
int i = 0 ;
int j = 0 ;

string strtime = DateTime.Now.ToString("yyyyMMddHHmmss");
string filename = "d:\\"+"工作人员登记"+strtime+".xls";

for (i=0;i<rizhiDG.Columns.Count-2; i++)
{
DataGridColumn oitem = rizhiDG.Columns[i];
xlsheet.ActiveSheet.Cells[1, i + 1] = oitem.HeaderText;
}

int numbercols = rizhiDG.Items[0].Cells.Count;

for (j = 0 ;j < rizhiDG.Items.Count; j ++ )
{
for( i = 0 ;i < numbercols; i ++ )
{

//xlsheet.get_Range(xlsheet.Cells[2, 2], xlsheet.Cells[j + 2, i + 1]).Font.Color = "blue";

//'xlsheet.Range("A2:B14").WrapText = True
xlsheet.get_Range(xlsheet.Cells[2, 1], xlsheet.Cells[j + 2, i + 1]).AutoFitColumns();
xlsheet.ActiveSheet.Cells[j + 2, i + 1] = rizhiDG.Items[j].Cells[i].Text.Replace(" ", " ");

}
}

try
{
xlsheet.ActiveSheet.Export( filename , OWC.SheetExportActionEnum.ssExportActionNone);
Response.Write("<script language=javascript>window.alert('提示：导出EXCEL成功.已输出到路径["+filename+"]下.');</script>");
return;

}
catch (System.Runtime.InteropServices.COMException ee)
{
Response.Write("<script language=javascript>window.alert('提示：导出EXCEL失败!请确认已正确配置."+ee.Message+"');</script>");
return;
}
}
catch
{
Response.Write("<script language=javascript>window.alert('没有记录');</script>");
return;
}

xiaoluzhu0420 2004-09-17

打赏
举报

导入excel:
private DataSet CreateDataSource()
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Inetpub\\wwwroot\\contacts.xls;"+
"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet);
return myDataSet;
}private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!IsPostBack)
{
mygrid.DataSource = CreateDataSource();
mygrid.DataBind();
}
}

stephenyk 2004-09-17