打开excel文件时提示“重载open方法未获得1参数”

2736 2003-09-12 11:25:11

object o=System.Reflection.Missing.Value;
Excel.Application excelapp=new Excel.Application();
Excel.Workbook wkbook=excelapp.Workbooks.Open(@"C:\temp\a.xls");
excelapp.Visible=true;
//wkbook.PrintPreview(true);//预览

wkbook.PrintOut(o,o,o,o,o,o,o,o);//打印

...全文

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

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

小伍老师 2004-03-03

打赏
举报

snof(雪狼) 的方法应该是对的

2736 2003-09-12

打赏
举报

wkyjob(流星划過...) 和snof(雪狼) 的方法还是不行。

雪狼1234567 2003-09-12

打赏
举报

object missing=Missing.Value;
excel=new Excel.Application ( );
excel.Application.Workbooks.Open("FileName.XLS",
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing);
excel.Visible = true ;

wkyjob 2003-09-12

打赏
举报

using System.IO;
using Excel;
using System.Reflection;

wkyjob 2003-09-12

打赏
举报

Excel.Application myExcel = (Excel.Application)(new Excel.ApplicationClass());
myExcel.Application.Workbooks.Add(true);
myExcel.Visible = true;
// Title
myExcel.Cells[1,4] = txtTitle.Text;

//
string strField = "";
for(int i=0;i<listView.Items.Count;i++)
{
if(listView.Items[i].Checked)
{
strField = strField+listView.Items[i].Text + ",";
}
}
string strFields = "";
strFields = "," + strField;
int intRow = 3;
bool b = false;
foreach(DataRow dr in _PubDs.Tables[0].Rows)
{
int intCol = 1;
foreach(DataColumn dc in _PubDs.Tables[0].Columns)
{
if(strFields.IndexOf("," + dc.ColumnName + ",")>=0)
{
if(!b)
myExcel.Cells[2,intCol] = dc.ColumnName;
myExcel.Cells[intRow,intCol] = dr[dc.ColumnName].ToString();
intCol++;
}
}
b = true;
intRow++;
}
//myExcel.Save(@txtFile.Text);
}