Using C#, how to write out a new row with a cell containing the value "END OF REPORT" after a RESULT SET exported to Excel?

I believe you just need to create a row and write your message to the first cell.

By the way, no one knows what writes etc you are using. It would be helpful to know a bit more. I believe you are using code from: http://stackoverflow.com/questions/373925/c-sharp-winforms-app-export-dataset-to-excel . Aren't you?

OK, try to insert my code instead your two commented out lines. I didn't test it of course because I have no your setup :). But it should work.

            //basically, we need to know how many cells in a row and use for loop
            // or can do this way:
            DataRow row  =  data.Rows[0]; //just take the first row, e.g.

            writer.WriteStartRow();// start new row
            int loopCounter = 0;
            foreach (object o in row.ItemArray)
            {
                if (loopCounter == 0)
                {
                    writer.WriteExcelAutoStyledCell("END OF REPORT"); // write first cell not blank
                    loopCounter += 1; // increase the counter
                }
                else
                {
                    writer.WriteExcelAutoStyledCell(""); // write a blank cells
                }
            }
            writer.WriteEndRow(); // conclude the row

Select allOpen in new window

Error      1      A local variable named 'row' cannot be declared in this scope because it would give a different meaning to 'row', which is already used in a 'child' scope to denote something else      U:\Visual Studio 2005\Projects\UDLApplication\UDLApplication\Form1.cs      982      33      UDLApplication


public static void ExcelExport(DataTable data, String fileName)
        {
            //export a DataTable to Excel
            DialogResult retry = DialogResult.Retry;

            while (retry == DialogResult.Retry)
            {
                try
                {
                    using (ExcelWriter writer = new ExcelWriter(fileName))
                    {
                        writer.WriteStartDocument();

                        // Write the worksheet contents
                        writer.WriteStartWorksheet("Sheet1");

                        //Write header row
                        writer.WriteStartRow();
                        foreach (DataColumn col in data.Columns)
                            writer.WriteExcelUnstyledCell(col.Caption);
                        writer.WriteEndRow();

                        //write data
                       
                        foreach (DataRow row in data.Rows)
                        {
                            writer.WriteStartRow();
                            foreach (object o in row.ItemArray)
                            {
                                writer.WriteExcelAutoStyledCell(o);
                            }
                            writer.WriteEndRow();
                        }
                       

                        //basically, we need to know how many cells in a row and use for loop
                        // or can do this way:
                        DataRow row = data.Rows[0]; //just take the first row, e.g.  //Error **

                        writer.WriteStartRow();// start new row
                        int loopCounter = 0;
                        foreach (object o in row.ItemArray)
                        {
                            if (loopCounter == 0)
                            {
                                writer.WriteExcelAutoStyledCell("END OF REPORT"); // write first cell not blank
                                loopCounter += 1; // increase the counter
                            }
                            else
                            {
                                writer.WriteExcelAutoStyledCell(""); // write a blank cells
                            }
                        }
                        writer.WriteEndRow(); // conclude the row

                        //write END OF REPORT at the end
                        //writer.WriteExcelAutoStyledCell("END OF REPORT");
                        //writer.WriteEndRow();

                        // Close up the document
                        writer.WriteEndWorksheet();
                        writer.WriteEndDocument();
                        writer.Close();

                        retry = DialogResult.Cancel;
                    }
                }
                catch (Exception myException)
                {
                    //myException.Message;
                    retry = MessageBox.Show(myException.Message, "Excel Export", MessageBoxButtons.RetryCancel, MessageBoxIcon.Asterisk);
                }
            }
        }