C#

required: using GRFExample;    

    var gevalues = Example.GetByType<GroupEntity>(Example.Test1().ToArray()).Cast<GroupEntity>();
            
    var cevalues = Example.GetByType<ConfigEntity>(Example.Test1().ToArray()).Cast<ConfigEntity>();
    
    var devalues = Example.GetByType<DefinitionEntity>(Example.Test1().ToArray()).Cast<DefinitionEntity>();

using System.Collections.Generic;

namespace GRFExample
{
    public static class Example
    {
        private static int id = 0;

        public static IEnumerable<GroupEntity> Test1()
        {
            for (var i = 0; i < 5; i++)
            {
                var ge = new GroupEntity();

                for (var j = 0; j < 4; j++)
                {
                    var ce = new ConfigEntity();
                    ce.dee = new DefinitionEntity(id++);
                    ge.cees.Add(ce);
                }

                yield return ge;
            }
        }

        public static IEnumerable<TheBase> GetByType<T>(params GroupEntity[] bees)
        {
            var pType = typeof(T).Name;

            foreach (var b in bees)
            {
                switch (pType)
                {
                    case "B":
                        yield return b;
                        break;

                    case "C":
                        foreach (var c in b.cees) yield return c;
                        break;

                    case "D":
                        foreach (var c in b.cees) yield return c.dee;
                        break;
                }
            }
        }
    }

    public class TheBase
    {
    }

    public class GroupEntity : TheBase
    {
        public List<ConfigEntity> cees = new List<ConfigEntity>();
    }

    public class ConfigEntity : TheBase
    {
        public DefinitionEntity dee;
    }

    public class DefinitionEntity : TheBase
    {
        public int id;

        public DefinitionEntity(int id)
        {
            this.id = id;
        }
    }
}

bool Draw_Mirror_Image = checkBox_mirror_image.Checked;

            bool Flip_horz_or_vert = radioButton_mirr_img_FV.Checked;
            //Flip_horz_or_vert     =   false for flip horizontal 
            //                  and =   true for flip vertical


            StringFormat stringFormat = new StringFormat();
            stringFormat.Alignment = StringAlignment.Center;
            stringFormat.LineAlignment = StringAlignment.Center;

            stringFormat.FormatFlags = StringFormatFlags.LineLimit;
            stringFormat.Trimming = StringTrimming.Word;


            RectangleF rect2 = panel2.ClientRectangle;
            float image_draw_wd = 200;
            float image_draw_ht = 100;

            int X = 0;
            int Y = 0;

            Brush myBrush = new SolidBrush(Color.FromArgb(128, Color.Blue));
            
            int ROW=3;
            int COL=3;
            Pen pen = new Pen(Color.Red, 4);

            float Zoom_Value = 100;

            float X_SF = 1;
            float Y_SF = 1;

            string draw_text = "35";

            Font draw_text_Font = new Font("Microsoft Sans Serif", 18, FontStyle.Bold);

            for (int r = 1; r <= ROW; r++)
            {
                X = 0;

                for (int cl = 1; cl <= COL; cl++)
                {

                    draw_text = "ROW : " + r.ToString() + "\nCOL : " + cl.ToString();

                    Rectangle dr_rect = new Rectangle(new Point(X, Y), new Size((int)image_draw_wd, ((int)image_draw_ht)));


                    if (Draw_Mirror_Image)
                    {
                        if (Flip_horz_or_vert == false)
                        {
                           //flip horz

                            pe.ScaleTransform(-X_SF, Y_SF);
                            //pe.TranslateTransform(-((X + image_draw_wd) * (float)(Zoom_Value / 100f)), 0);
                            pe.TranslateTransform(-((image_draw_wd) * (float)(Zoom_Value / 100f)), 0);
                        }
                        else
                        { 
                            //flip vert

                            pe.ScaleTransform(X_SF, -Y_SF);
                            //pe.TranslateTransform(0, -((Y + image_draw_ht) * (float)(Zoom_Value / 100f)));
                            pe.TranslateTransform(0, -((image_draw_ht) * (float)(Zoom_Value / 100f)));
                        }
                    }

                    pe.DrawString(draw_text, draw_text_Font, myBrush, dr_rect, stringFormat);

                    pe.DrawRectangle(pen, dr_rect);

                    X = X + (int)image_draw_wd;
                }


                Y = Y + (int)image_draw_ht;
                
            }

Considerations for server-side Automation of Office[^]

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

// Load the data from your stored procedure:
DataTable dt = LoadDataFromStoredProcedure();

// Export the data to an Excel file:
var pck = new ExcelPackage();
var wsDt = pck.Workbook.Worksheets.Add("FromDataTable");
wsDt.Cells["A1"].LoadFromDataTable(dt, /* PrintHeaders: */ true, TableStyles.Medium9);

// Send the Excel file back to the user:
Response.Clear();
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
pck.SaveAs(Response.OutputStream);
Response.Flush();

// If you're running this code from a page (.aspx) instead of a generic handler (.ashx):
Response.SuppressContent = true;
Context.ApplicationInstance.CompleteRequest();

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

Lupu5R3x wrote:

the strip comments and rename part (for me that is).