|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40 |
using
Excel = Microsoft.Office.Interop.Excel;using
System;using
System.Diagnostics;using
System.Threading;namespace
RefreshExcel{ public
class RExcel { private
static Excel.Application excel = null; //引擎 private
static Excel.Workbook theWorkbook = null; public
void RExce(string
excelPath) { try { var
txtLocation = excelPath; object
_missingValue = System.Reflection.Missing.Value; if
(excel == null) excel = new
Excel.Application(); excel.DisplayAlerts = false; if
(theWorkbook == null) theWorkbook = excel.Workbooks.Open(txtLocation, _missingValue, false, _missingValue, _missingValue, _missingValue, _missingValue, _missingValue, _missingValue, _missingValue, _missingValue, _missingValue, _missingValue); lock
(theWorkbook) { theWorkbook.RefreshAll(); } System.Threading.Thread.Sleep(10);// Make sure that save theWorkbook.Save(); excel.Quit(); GC.Collect(); GC.WaitForPendingFinalizers(); } catch
(Exception ex) { throw
ex; } } }} |
Refresh Excel (C#),布布扣,bubuko.com
原文：http://www.cnblogs.com/2zhyi/p/3640973.html