此代码中未处理的异常 [英] unhandled exception in this code

问题描述

我正在尝试这样的东西将数据保存到excel表4

Hi,

I am trying something like this for saving the data to excel sheet 4

Excel.Worksheet xlWorkSheet4 = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(4);
           

             i = 1;
             foreach (DataRow row in lstDS[2].Tables[0].Rows)
             {


                 string fieldFromDB = row[1].ToString();
                 string FromDB = row[2].ToString();
             //   // if (FromDB.StartsWith("GW"))
                 foreach (DataRow row1 in lstDS[0].Tables[0].Rows)
                {
                     string fieldFromDB1 = row1[1].ToString();

                    if (fieldFromDB == fieldFromDB1)
                     {

                 foreach (DataRow row2 in lstDS[1].Tables[0].Rows)
                 {
                     string fieldFromDB2 = row2[1].ToString();
                         //xlWorkSheet2.Cells[i, 1] = row[8];
                         //xlWorkSheet2.Cells[i, 2] = row1[8];
                     if (fieldFromDB1 == fieldFromDB2)
                     {

                         xlWorkSheet4.Cells[i, 1] = fieldFromDB;
                         xlWorkSheet4.Cells[i, 2] = fieldFromDB1;
                         xlWorkSheet4.Cells[i, 3] = fieldFromDB2;
                         i++;

                     }



                 }
             }
                     }
             }
           


            xlWorkBook.SaveAs(path1, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlShared, misValue, misValue, misValue, misValue, misValue);
            xlWorkBook.Close(true, misValue, misValue);

我在尝试保存到Excel工作表时没有问题1,2,3



当我尝试保存到excel工作表4时，我得到了未处理的异常



附加信息：索引无效。 （HRESULT异常：0x8002000B（DISP_E_BADINDEX））



任何人都可以帮我解决这个问题???





谢谢

John

I have no problem when trying to save into excel sheets 1,2,3

I am getting unhandled exception when I am trying to save into excel sheet 4

Additional information: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

Can any one help me in solving this???


Thanks
John

推荐答案

在Excel中创建新工作簿时，它默认只有3个工作表。

如果你想要更多，你需要使用以下代码添加它们：

When you create new Workbook in Excel it has by default only 3 worksheets.
If you want to have more you need to add them using code like:

(Excel.Worksheet)xlWorkBook.Worksheets.Add();

这篇关于此代码中未处理的异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！