本文整理汇总了C#中Excel.Application类的典型用法代码示例。如果您正苦于以下问题:C# Excel.Application类的具体用法?C# Excel.Application怎么用?C# Excel.Application使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
Excel.Application类属于命名空间,在下文中一共展示了Excel.Application类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetExcelSheetName
///
/// 读取Excel文件
///
///
///
private string GetExcelSheetName(string pPath)
{
//打开一个Excel应用
_excelApp = new Excel.Application();
if (_excelApp == null)
{
throw new Exception("打开Excel应用时发生错误!");
}
_books = _excelApp.Workbooks;
//打开一个现有的工作薄
_book = _books.Add(pPath);
_sheets = _book.Sheets;
//选择第一个Sheet页
_sheet = (Excel._Worksheet)_sheets.get_Item(1);
string sheetName = _sheet.Name;
ReleaseCOM(_sheet);
ReleaseCOM(_sheets);
ReleaseCOM(_book);
ReleaseCOM(_books);
_excelApp.Quit();
ReleaseCOM(_excelApp);
return sheetName;
}开发者ID:uwitec,项目名称:gloryview-rfid,代码行数:31,代码来源:ExcelHelper.cs
示例2: CreateStudentBaseSimpleTable
public void CreateStudentBaseSimpleTable()
{
KillProcess();
try
{
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Open( //打开该文件
[email protected]"\report\ImportBaseTableForStudent(simple).xls",Type.Missing,Type.Missing,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing,
Type.Missing));
m_objExcel.Visible = true;
}
catch(Exception e)
{
Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE);
}
finally
{
m_objSheet = null;
m_objSheets = null;
m_objBook = null;
m_objBooks = null;
m_objExcel = null;
GC.Collect();
}
}开发者ID:zesus19,项目名称:c4.v2.T,代码行数:32,代码来源:OptionRules.cs
示例3: StartupApp
// 启动Excel 程序
public bool StartupApp(bool visible)
{
// 检查是否有Excel正在运行
bool flag = false;
foreach (var item in Process.GetProcesses())
{
if (item.ProcessName == "EXCEL")
{
flag = true;
break;
}
}
if (!flag)
{
ExcelApp = new Excel.Application();
}
else
{
object obj = Marshal.GetActiveObject("Excel.Application"); // 引用已在执行的Excel
ExcelApp = obj as Excel.Application;
}
ExcelApp.Visible = visible; // Excel程序不可见
return true;
}开发者ID:WangXiang10,项目名称:xinli,代码行数:27,代码来源:ExcelStream.cs
示例4: Button1_Click
private void Button1_Click(object sender, EventArgs e)
{
Excel.Application xl = new Excel.Application();
xl.Visible = true;
xl.Workbooks.Add("c:\\Pasta1.xlt");
xl.Cells[3, 4] = TextBox1.Text;
}开发者ID:tca85,项目名称:ASP.NET,代码行数:10,代码来源:Form1.cs
示例5: ExcelController
///
/// エクセルデータの操作を行う
///
/// xlsファイルパス
public ExcelController(string path)
{
exPath = path;
oXls = new Excel.Application();
//Excel画面を表示しない
oXls.Visible = false;
//Excelファイルをオープンする
oWBook = (Excel.Workbook)(oXls.Workbooks.Open(exPath));
}开发者ID:nallpo,项目名称:CSharpUtility,代码行数:16,代码来源:ExcelController.cs
示例6: ExportExcel
public void ExportExcel()
{
try
{
//if (e.KeyCode != Keys.F12) return;
if (_autoExcel == false) return;
BindingSource bsTemp = this.PrimaryGrid.DataSource as BindingSource;
if (bsTemp == null) return;
DataTable tempDATA = bsTemp.DataSource as DataTable;
if (tempDATA == null) return;
DataTable DATA = tempDATA;
DATA.RejectChanges();
Excel.Application objExcel;
try
{
//Tìm instance Excel đang chạy.
objExcel = (Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");
}
catch
{
//Không có instance nào của Excel đang chạy.
objExcel = new Excel.Application();
}
try
{
objExcel.Interactive = false;
objExcel.Interactive = true;
}
catch
{
//CrossShow2 msg = new CrossShow2(clsMx.Show);
//this.Invoke(msg, Qk.Settings.ctrmsgPrintError, eAlertType.CanhBao);
return;
}
objExcel.Visible = false;
string tmpFileXSL = Path.Combine(st.TEMP_DIR, Guid.NewGuid().ToString() + ".xls");
clsAll.ExtractXLS("AutoExcel.xls", tmpFileXSL);
objExcel.Workbooks.Open(tmpFileXSL);
object[,] objData = clsAll.DataTable2ArrayObjects(DATA);
string strRange = string.Format("A{0}:{1}{2}", 1, clsAll.GetExcelColumnLabel(DATA.Columns.Count), DATA.Rows.Count);
objExcel.Range[strRange].Value = objData;
objExcel.Visible = true;
objExcel.ActiveWorkbook.Save();
//objExcel.Worksheets.PrintPreview();
}
catch (Exception ex)
{
clsMx.Show(ex, this.Name);
}
}开发者ID:huamanhtuyen,项目名称:VNACCS,代码行数:53,代码来源:tGrid.cs
示例7: LoadDataExcel
private void LoadDataExcel()
{
try
{
if (tbUploadFile.Text == "")
{
MessageBox.Show("Vui lòng load file để cập nhật!");
}
string status_name = "", status_code = "", result = "";
string resultT = "" , MSG = "";
conTTTSOA SOA = new conTTTSOA();
status_name = cbTrangthai.Text.ToString();
status_code = cbTrangthai.SelectedValue.ToString();
// string file = @"C:\Users\thongnt.NAMABANK0\Pictures\CẬP NHẬT TRẠNG THÁI ĐỒNG LOẠT FILE MẪU.xls";
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(tbUploadFile.Text);
//Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(file);
Excel._Worksheet xlWorksheet = (Excel._Worksheet)xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
string contract_number = "";
int n_true = 0;
for (int i = 1; i |