我试图使用asp.net c#将数据写入excel模板文件。但是我得到了以下例外。
ExceptionType:“ System.Runtime.InteropServices.COMException”
消息:“ RPC服务器不可用。(HRESULT异常:0x800706BA)”
有时它适用于少量的行。我找不到问题所在。
try
{
int rowNumber = 5;
DataSet ds = ClsSystem.getReviewResponse();
Excel.Application myExcelApplication = null;
Excel.Workbook myExcelWorkbook = null ;
Excel.Worksheet myExcelWorkSheet = null;
//copy template
System.IO.File.Copy(excelFilePath, NewExcelFilePath);
myExcelApplication = new Excel.Application();
myExcelApplication.DisplayAlerts = false;
myExcelWorkbook = (Excel.Workbook(myExcelApplication.Workbooks._Open(NewExcelFilePath, System.Reflection.Missing.Value,
System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value,
System.Re