C# com操作excel 急！！！！

来源：百度知道 编辑：UC知道 时间：2024/05/19 04:12:37
我想用excel把数据库里的数据导出来，写了个测试代码，可是总是出错，请高手帮帮我， 代码如下：
using Excel;
Excel.Application ep = new Excel.Application();
if (ep != null)
{
ep.Visible = false;
ep.UserControl = true;
Workbooks workbooks = ep.Workbooks;
_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATExcel4IntlMacroSheet);
Sheets sheets = ep.Worksheets;
_Worksheet sheet = (_Worksheet)sheets.get_Item(1);
sheet.Cells[1, 1] = "门店";
object oMissing = System.Reflection.Missing.Value;
string filename=Guid.NewGuid().ToString()+".xls";
workbook.SaveAs(Server.MapPath(filename), Excel.XlFileFormat.xlExcel9795, oMissing, oMissing, oMissing, oMissing, Excel.XlSaveAsAccessMode.xlExclusive,
oMissing, oMissing, oMissi

workbook.SaveAs(Server.MapPath(filename), Excel.XlFileFormat.xlExcel9795, oMissing, oMissing, oMissing, oMissing, Excel.XlSaveAsAccessMode.xlExclusive,
oMissing, oMissing, oMissing, oMissing, oMissing);

编译器错误信息: CS1501: “SaveAs”方法没有采用“12”个参数的重载

不说没有12个么。你去掉一个oMissing就行了么。

public bool SaveFP2toExcel(string Path)
{
try
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
System.Data.OleDb.OleDbCommand cmd=new OleDbCommand ();
cmd.Connection =conn;
//cmd.CommandText ="UPDATE [sheet1$] SET 姓名='2005-01-01' WHERE 工号='日期'";
//cmd.ExecuteNonQuery ();
for(int i=0;i<fp2.Sheets [0].RowCount -1;i++)
{
if(fp2.Sheets [0].Cells[i,0].Text!="")
{
cmd.CommandText ="INSERT INTO [s