我找了一段程序运行如下:
Excel.Application app=new Excel.Application();
//定义参数已存在1.xls文件
string filename=="c:/1.xls"; object template_p=filename;
object newTemplate_p=false;
object documentType_p=0;
object visible_p=true;
object p1=Missing.Value;
object p2=Missing.Value;
object p3=Missing.Value;
object p4=Missing.Value;
object updateLink_p=Missing.Value;
object ReadOnly_p=false;
object Format_p=Missing.Value;
object password="";
object Writepassword="";
object Recommended_p=Missing.Value;
object Origin_p=2;
object Delimitit_p=Missing.Value;
object Editable_p=true;
object Notify_p=Missing.Value;
object Converter_p=Missing.Value;
object AddToMru_p=Missing.Value;
object local_p=Missing.Value;
object corruptload_p=Missing.Value;
Excel._Workbook wb=app.Workbooks.Open(filename,updateLink_p,ReadOnly_p,Format_p,password,Writepassword,Recommended_p,Origin_p,Delimitit_p,Editable_p,Notify_p,Converter_p,AddToMru_p,local_p,corruptload_p);
//定位sheet
Excel._Worksheet oSheet = (Excel._Worksheet)wb.Worksheets["sheet1"];
oSheet.Cells[1,1]="vvflower";
//保存
object fileName_p="c:\\2.xls";
object fileFormat_p=Missing.Value;
object lockComments_p=Missing.Value;
object password_p=Missing.Value;
object addToRecentFiles_p=Missing.Value;
object writePassword_p=Missing.Value;
Excel.XlSaveAsAccessMode readOnlyRecommended_p=new Excel.XlSaveAsAccessMode();
object embedTrueTypeFonts_p=Missing.Value;
object saveNativePictureFormat_p=Missing.Value;
object saveFormsData_p=Missing.Value;
object saveAsAOCELetter_p=Missing.Value;
wb.SaveAs(fileName_p,fileFormat_p,lockComments_p,password_p,addToRecentFiles_p,writePassword_p,readOnlyRecommended_p,embedTrueTypeFonts_p,saveNativePictureFormat_p,saveFormsData_p,saveAsAOCELetter_p,local_p);
object saveChanges_p=Missing.Value;
object originalFormat_p=Missing.Value;
object routeDocument_p=Missing.Value;
wb.Close(saveChanges_p,originalFormat_p,routeDocument_p);
app.Quit( );
app=null;运行结果报错误1:重载open方法未获取15参数
2:重载saved方法未获取12参数
为什么?,再请问如何取得excel中指定具体格的值?
Excel.Application app=new Excel.Application();
//定义参数已存在1.xls文件
string filename=="c:/1.xls"; object template_p=filename;
object newTemplate_p=false;
object documentType_p=0;
object visible_p=true;
object p1=Missing.Value;
object p2=Missing.Value;
object p3=Missing.Value;
object p4=Missing.Value;
object updateLink_p=Missing.Value;
object ReadOnly_p=false;
object Format_p=Missing.Value;
object password="";
object Writepassword="";
object Recommended_p=Missing.Value;
object Origin_p=2;
object Delimitit_p=Missing.Value;
object Editable_p=true;
object Notify_p=Missing.Value;
object Converter_p=Missing.Value;
object AddToMru_p=Missing.Value;
object local_p=Missing.Value;
object corruptload_p=Missing.Value;
Excel._Workbook wb=app.Workbooks.Open(filename,updateLink_p,ReadOnly_p,Format_p,password,Writepassword,Recommended_p,Origin_p,Delimitit_p,Editable_p,Notify_p,Converter_p,AddToMru_p,local_p,corruptload_p);
//定位sheet
Excel._Worksheet oSheet = (Excel._Worksheet)wb.Worksheets["sheet1"];
oSheet.Cells[1,1]="vvflower";
//保存
object fileName_p="c:\\2.xls";
object fileFormat_p=Missing.Value;
object lockComments_p=Missing.Value;
object password_p=Missing.Value;
object addToRecentFiles_p=Missing.Value;
object writePassword_p=Missing.Value;
Excel.XlSaveAsAccessMode readOnlyRecommended_p=new Excel.XlSaveAsAccessMode();
object embedTrueTypeFonts_p=Missing.Value;
object saveNativePictureFormat_p=Missing.Value;
object saveFormsData_p=Missing.Value;
object saveAsAOCELetter_p=Missing.Value;
wb.SaveAs(fileName_p,fileFormat_p,lockComments_p,password_p,addToRecentFiles_p,writePassword_p,readOnlyRecommended_p,embedTrueTypeFonts_p,saveNativePictureFormat_p,saveFormsData_p,saveAsAOCELetter_p,local_p);
object saveChanges_p=Missing.Value;
object originalFormat_p=Missing.Value;
object routeDocument_p=Missing.Value;
wb.Close(saveChanges_p,originalFormat_p,routeDocument_p);
app.Quit( );
app=null;运行结果报错误1:重载open方法未获取15参数
2:重载saved方法未获取12参数
为什么?,再请问如何取得excel中指定具体格的值?
解决方案 »
- 把VB.net的一段小程序转换成C#.net 谢谢!
- HTTP 404 急!
- vs环境下如何避免出现调试页面?
- 来看看session 每个账号第二次登陆时,session消失了,为什么
- 装不了.net,系统是XP sp3的
- 有关 windows脚本和批处理之间的区别的问题
- 【求助】如何给DetailView控件的Delete事件加上一个确认对话框?
- 急!请教如何利用DataGrid显示图片??
- 应用ASP。NET的网站太少了,是支持不够吧
- 又是FRAMEWORK问题,在线等待,
- 客户端控件事件如何调用服务器端函数,我都问了好几次了,一直没有解决.高手请帮忙
- 我的系统是windows 2003 server,该怎样安装asp.net?请多多指教!
改为
bool corruptload_p=false;
Workbooks.Open(fileName,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,false);最后一个参数如果为 True 则将该工作簿添加到最近使用文件列表中。默认值为 False。