using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
namespace ExcelApp
{
public partial class Form1 : Form
{
String filePath;
Microsoft.Office.Interop.Excel.Application ExcelApp;//Excel应用
Microsoft.Office.Interop.Excel.Workbooks ExcelWorkbooks;//Excel工作簿管理器
Microsoft.Office.Interop.Excel.Workbook ExcelWorkbook;//Excel工作簿
Microsoft.Office.Interop.Excel.Sheets ExcelWorksheets;//Excel工作表管理器
Microsoft.Office.Interop.Excel._Worksheet ExcelWorksheet;//Excel工作表
public Form1()
{
InitializeComponent();
//
filePath = "E:/Datas.xls";
ExcelApp = new Microsoft.Office.Interop.Excel.Application();//创建Excel应用
ExcelWorkbooks = ExcelApp.Workbooks;
if (System.IO.File.Exists(filePath) == false)//若文件不存在
{
ExcelWorkbook = ExcelWorkbooks.Add(true);//新建Excel文档
}
else
{
ExcelWorkbook = ExcelWorkbooks.Add(filePath);//打开现有Excel文档
}
ExcelWorksheets = ExcelWorkbook.Worksheets;
int count = ExcelWorksheets.Count;
if (count > 0)
{
ExcelWorksheet = (Microsoft.Office.Interop.Excel._Worksheet)ExcelWorksheets.get_Item(count);//获取当前WorkBook中最后一个WorkSheet
}
else
{
ExcelWorksheet = (Microsoft.Office.Interop.Excel._Worksheet)ExcelWorksheets.Add(Type.Missing, Type.Missing, 1, Microsoft.Office.Interop.Excel.XlSheetType.xlWorksheet);//新建WorkSheet
}
ExcelWorksheet.Cells[1, 1] = System.DateTime.Now;//操作Cells
ExcelApp.AlertBeforeOverwriting = false;//数据覆盖时不提示告警
ExcelApp.DisplayAlerts = false;//不提示告警
//保存工作簿
ExcelWorkbook.SaveAs(filePath,//FileName
Type.Missing,//FileFormat
Type.Missing,//Password
Type.Missing,//WriteResPassword
false,//ReadOnlyRecommended
false,//CreateBackup
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,//AccessMode
Microsoft.Office.Interop.Excel.XlSaveConflictResolution.xlLocalSessionChanges,
Type.Missing,//AddToMru
Type.Missing,//TextCodepage
Type.Missing,//TextVisualLayout
Type.Missing//Local
);
ExcelWorkbook.Close(true, Type.Missing, Type.Missing);//关闭工作簿
ExcelApp.Quit();//关闭应用
//
ExcelWorksheet = null;
ExcelWorksheets = null;
ExcelWorkbook = null;
ExcelWorkbooks = null;
ExcelApp = null;
}
}
}