本文整理汇总了C#中Excel.Application.Close方法的典型用法代码示例。如果您正苦于以下问题:C# Excel.Application.Close方法的具体用法?C# Excel.Application.Close怎么用?C# Excel.Application.Close使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Excel.Application
的用法示例。
在下文中一共展示了Excel.Application.Close方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Upload
public void Upload()
{
string strPathnew = Server.MapPath("~/") + "UploadFile\\AcrTestfinalresult.xls";
try
{
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
xlWorkBook = new Excel.Application().Workbooks.Add(Missing.Value);
xlWorkBook.Application.Visible = true;
xlWorkSheet = (Excel.Worksheet)xlWorkBook.ActiveSheet;
string strPath = Server.MapPath("~/") + "UploadFile\\AcrTestfinal.xls";
StreamReader sr = new StreamReader(strPath); //Read the Excel Stream
string strTest = "";
int i = 1;
while (!sr.EndOfStream)
{
strTest = sr.ReadLine();
string[] strData = strTest.Split('\t');
int count = strData.Length;
for (int k = 1; k <= count; k++)
{
string str = strData[k - 1].Replace("\"", "");
if (k == 4) //1 based index of Column required to be changed
{
str = str.Insert(0, "'");
}
xlWorkSheet.Cells[i, k] = str;
}
i++;
}
sr.Close();
sr.Dispose();
xlWorkSheet.Columns.AutoFit();
xlWorkBook.SaveAs(strPathnew , Excel.XlFileFormat.xlExcel4, Missing.Value, Missing.Value, false, false, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlWorkBook.Close(Missing.Value, strPathnew, Missing.Value);
}
catch
{ }
}