|
using Excel = Microsoft.Office.Interop.Excel;//需要引用命名空间
private void PrintViewExcel
{
Excel.Application m_objExcel = null;
Excel._Workbook m_objBook = null;
Excel.Sheets m_objSheets = null;
Excel._Worksheet m_objSheet = null;
Excel.Range m_objRange = null;
object m_objOpt = System.Reflection.Missing.Value;
try
{
m_objExcel = new Excel.Application();
m_objBook = m_objExcel.Workbooks.Open("C:\\Test.xlsx", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
m_objSheet.Cells[1, 1] = "Excel读取模板简单测试(对单元格操作)";
m_objRange = m_objSheet.get_Range("A2:A3", m_objOpt);
m_objRange.Value2 = "Excel读取模板简单测试(对单元格区域操作)";
//m_objRange.Value = "Excel读取模板简单测试(对单元格区域操作)";
m_objRange = m_objSheet.get_Range("F1:U4", m_objOpt);
m_objRange.Borders.LineStyle = BorderStyle.FixedSingle;
m_objRange.Font.Bold = true;
m_objSheet.PageSetup.PrintArea = "A1:U40";
m_objExcel.DisplayAlerts = false;
//m_objBook.Save();
m_objBook.SaveAs("C:\\CostAnalysis" + txtFGNo.Text + txtCustCode.Text + txtRevision.Text +
".xlsX", m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt,
Excel.XlSaveAsAccessMode.xlNoChange, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objExcel.Visible = true;
m_objSheet.PrintPreview(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
m_objBook.Close(m_objOpt, m_objOpt, m_objOpt);
m_objExcel.Workbooks.Close();
m_objExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheets);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objRange);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);
m_objBook = null;
m_objExcel = null;
GC.Collect();
}
}
| 
转播
