使用Excel的com组件加载一个模板(模板里面有vba脚本),直接SaveAs的话就不会加载vba脚本。
解决方案 »
- .NET 三层架构项目代码实例 日记管理
- 求助:GridView中绑定CheckBoxList
- 怎么在Page_Load中改写母板页上的doctype声明
- 我在调试程序的时候出现这样的问题:
- 请问我下载的asp.net程序看不到.cs文件。用什么工具可以看呢?
- 我的 World Wide Web Publishing 服务由于“错误3:系统找不到指定的路径”而无法启动,IIS就等于没用,怎么办?
- SQL查询某个字段为指定类型(字母字母数字数字数字-数字)的数据
- 修改数据库很慢,以至不成功
- 我要疯狂了!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- Module.vb 中如何写 Response.write ?
- v5mall 后台创建验证验错误 IIS5.1下为什么呢,
- mysq
string strTicks = DateTime.Now.Ticks.ToString();
string strAppPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase;
strAppPath += strTicks + ".xls";
Microsoft.Office.Interop.Excel.Application WKTExcelObj = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks WKTWorkbooks = WKTExcelObj.Workbooks;
Microsoft.Office.Interop.Excel.Workbook WKTWorkbook = WKTWorkbooks.Add(strFilePath);
Microsoft.Office.Interop.Excel.Sheets WKTWorkSheets = WKTWorkbook.Worksheets;
Microsoft.Office.Interop.Excel.Worksheet WKTWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)(WKTWorkSheets.get_Item(1));
string strListValue = "1,2,3";
object ObjOpt = System.Reflection.Missing.Value;
WKTWorkbook.SaveAs(strAppPath, ObjOpt, ObjOpt, ObjOpt,
ObjOpt, ObjOpt, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
ObjOpt, ObjOpt, ObjOpt, ObjOpt, ObjOpt);
WKTWorkbook.Close(false, ObjOpt, ObjOpt);
WKTExcelObj.Quit();
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Excel = Microsoft.Office.Interop.Excel;namespace SaveAsWithVBA
{
class Program
{
static void Main(string[] args)
{
var xlsApp = new Excel.Application();
xlsApp.DisplayAlerts = false;
var xlsBook = xlsApp.Workbooks.Open(@"E:\Programming\1.xls");
xlsBook.SaveAs(@"E:\Programming\2.xls");
xlsBook.Close(false);
xlsApp.DisplayAlerts = true;
xlsApp.Quit();
}
}
}