1
if(!System.IO.File.Exists(Server.MapPath("aa.xls")))
2
{
3
// Excel object references.
4
Excel.Application m_objExcel = null;
5
Excel.Workbooks m_objBooks = null;
6
Excel._Workbook m_objBook = null;
7
Excel.Sheets m_objSheets = null;
8
Excel._Worksheet m_objSheet = null;
9
Excel.Range m_objRange = null;
10
Excel.Font m_objFont = null;
11![](/Images/OutliningIndicators/InBlock.gif)
12
// Frequenty-used variable for optional arguments.
13
object m_objOpt = System.Reflection.Missing.Value;
14![](/Images/OutliningIndicators/InBlock.gif)
15
// Start a new workbook in Excel.
16
m_objExcel = new Excel.Application();
17
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
18
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
19![](/Images/OutliningIndicators/InBlock.gif)
20
// Add data to cells of the first worksheet in the new workbook.
21
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
22
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
23![](/Images/OutliningIndicators/InBlock.gif)
24
m_objRange = m_objSheet.get_Range("A1", m_objOpt);
25
m_objRange.set_Value(m_objOpt,"FirstName");
26
m_objRange = m_objSheet.get_Range("B1", m_objOpt);
27
m_objRange.set_Value(m_objOpt,"Last Name");
28
29
// Apply bold to cells A1:B1.
30
m_objRange = m_objSheet.get_Range("A1", "G1");
31
m_objFont = m_objRange.Font;
32
m_objFont.Bold=true;
33![](/Images/OutliningIndicators/InBlock.gif)
34
// Paths used by the sample code for accessing and storing data.
35
object m_strSampleFolder = Server.MapPath("TempFile")+"\\";
36![](/Images/OutliningIndicators/InBlock.gif)
37
// Save the workbook and quit Excel.
38
39
m_objBook.SaveAs(m_strSampleFolder + "aa.xls", m_objOpt, m_objOpt,
40
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
41
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
42
m_objBook.Close(false, m_objOpt, m_objOpt);
43
m_objExcel.Quit();
44
}
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/InBlock.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/InBlock.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
1 .当然,在进行上述操作之前要添加对Excel的引用。
2.要在decom中对Excel的权限进行设置