How to Insert datatable in multisheet excel file

See more:

C#

C#4.0

Hi,

I am having an excel (multisheet) file and for each sheets there is one separate datatable and I want to write it in to the excel sheets.

For that I have written the following code and but its not working.

Workbook doc;

doc = excelApp.Workbooks.Open(strExcelFilePath);
                        SnapShot_ReporTgenerator_BackGroundWorker.ReportProgress(70); //"Creating file..."

                        Microsoft.Office.Interop.Excel.Sheets workSheets = doc.Worksheets;
                        int listCount = 1;
                        for (int i = 1; i <= list.Count; i++)
                        {
                              //code to create diffrent excel sheets
                            var xlsNewSheet = (Microsoft.Office.Interop.Excel.Worksheet)workSheets.Add(Missing.Value, workSheets[i], Missing.Value, Missing.Value);
                            
                            xlsNewSheet.Name = i + "of" + list.Count;
                            foreach (var sublist in list)
                            {
                                if (listCount == i)
                                {
                                    
                                    System.Data.DataTable table = TODataTable<string>(sublist);
                                    
                                    doc.Worksheets.Add(table, xlsNewSheet.Name); //code to add datatable to worksheets
                                    
                                }
                                listCount++;
                            }
                        }

                        doc.SaveAs(strExcelFilePath);

                        ForMat_SnapShotReport(doc);
                        excelApp.Visible = true;

I want to know what is wrong in my code.?
How to do it?