C#

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).

- Read all lines as strings
- look for leading "//", "/", "", "*/", etc.
- LastIndex of "//" for trailing comments.
- Write clean / accepted lines.