MARKUS

using GemBox.Spreadsheet;

using System.IO;

        [Obsolete]

                        SpreadsheetInfo.SetLicense(Properties.Settings.Default.GemBoxLicense);// "EXK0-W4HZ-N518-IMEW");                    

                        ExcelFile workbook = null;

                        ExcelWorksheet worksheet = null;

                            // Excel 첫번째 워크시트 가져오기             

                            workbook = ExcelFile.Load(dialog.FileName);

                            worksheet = workbook.Worksheets[0];

                            int h = 8;

                            int w = 1;

                            worksheet.Cells[1, w + 8].Value = project_no;

                            worksheet.Cells[2, w + 8].Value = project_name;

                            worksheet.Cells[3, w + 8].Value = (mainWindow as MainWindow).dzMainMenu._DocItem.DOCUMENT_NO;

                            worksheet.Cells[4, w + 8].Value = (mainWindow as MainWindow).dzMainMenu.userData.NAME + " (" + App.ViewInfo.UserID + ")";

                            worksheet.Cells[5, w + 8].Value = DateTime.Now.ToString("yyyy.MM.dd");

                            ExcelCell Range_I = worksheet.Cells["K9"];                           

                            worksheet.Cells.GetSubrangeAbsolute(8, 11, 8, 11 + rev_cnt - 1).Merged = true;                       

                            CellRange iRange = worksheet.Cells.GetSubrange("B10:" + Ran + "10");

                            CellRange Filter_Range = worksheet.Cells.GetSubrange("B9:" + Ran + "9");

                            Filter_Range.Filter(true);

                            ExcelCell Range_b = worksheet.Cells["B10"];

                                // Get the range.

                                CellRange oRange = worksheet.Cells.GetSubrange("B" + (h + 1) + ":" + Ran + (h + 1));

                                foreach (var cell in oRange)

                                {

                                    cell.Style.Borders.SetBorders(MultipleBorders.Outside, SpreadsheetColor.FromName(ColorName.Black), LineStyle.Thin);

                                }

                                    ExcelCell ImageRange = worksheet.Cells[h, w + 2];        

                                    ImageRange.Row.Height = Range_b.Row.Height;

                                    //ImageRange.Style.Font.Size = 10;

                                    ImageRange.Style.HorizontalAlignment = HorizontalAlignmentStyle.Left;

                                    ImageRange.Style.VerticalAlignment = VerticalAlignmentStyle.Top;                                      

                                    byte[] imageData = data.IMAGE_PATH;

                                    MemoryStream memoryStream = new MemoryStream();

                                    o_Image.Save(memoryStream, System.Drawing.Imaging.ImageFormat.Jpeg);                                    

                                    int column = 2; // 이미지를 삽입할 열

                                    int row = h;    // 이미지를 삽입할 행

                                    // 이미지를 워크시트에 추가

                                    ExcelPicture picture = worksheet.Pictures.Add(memoryStream, PositioningMode.FreeFloating, new AnchorCell(ImageRange.Column, ImageRange.Row, 0, 0), ExcelPictureFormat.Jpeg);

                                    //foreach (Microsoft.Office.Interop.Excel.Shape shp in worksheet.Shapes)

                                    //{

                                    //    if (shp.TopLeftCell.Address != ImageRange.Address)

                                    //        continue;

                                    //    double Left = shp.TopLeftCell.Left + (shp.TopLeftCell.Width - shp.Width) / 2;

                                    //    double Top = shp.TopLeftCell.Top + (shp.TopLeftCell.Height - shp.Height) / 2;

                                    //    shp.Left = float.Parse(Left.ToString());

                                    //    shp.Top = float.Parse(Top.ToString());

                                    //    break;

                                    //}

                                worksheet.Cells[h, w].Value = data.REVISION;

                                worksheet.Cells[h, w + 1].Value = data.PAGENUMBER;

                                worksheet.Cells[h, w + 3].Value = data.TODOLIST;

                                worksheet.Cells[h, w + 4].Value = data.STATUS.ToUpper() == "TRUE" ? "closed" : "open";

                                worksheet.Cells[h, w + 5].Value = data.STATUS_DESC;

                                worksheet.Cells[h, w + 6].Value = data.VENDOR;

                                worksheet.Cells[h, w + 7].Value = data.REMARK;

                                worksheet.Cells[h, w + 8].Value = data.REPLY;

                                worksheet.Cells[h, w + 9].Value = data.REV_0 == null ? "" : data.REV_0.Replace("", " / ");

                                worksheet.Cells[h, w + 10].Value = data.REV_1 == null ? "" : data.REV_1.Replace("", " / ");

                                worksheet.Cells[h, w + 11].Value = data.REV_2 == null ? "" : data.REV_2.Replace("", " / ");

                                worksheet.Cells[h, w + 12].Value = data.REV_3 == null ? "" : data.REV_3.Replace("", " / ");

                                worksheet.Cells[h, w + 13].Value = data.REV_4 == null ? "" : data.REV_4.Replace("", " / ");

                                worksheet.Cells[h, w + 14].Value = data.REV_5 == null ? "" : data.REV_5.Replace("", " / ");

                                worksheet.Cells[h, w + 15].Value = data.REV_6 == null ? "" : data.REV_6.Replace("", " / ");

                                worksheet.Cells[h, w + 16].Value = data.REV_7 == null ? "" : data.REV_7.Replace("", " / ");

                                worksheet.Cells[h, w + 17].Value = data.REV_8 == null ? "" : data.REV_8.Replace("", " / ");

                                worksheet.Cells[h, w + 18].Value = data.REV_9 == null ? "" : data.REV_9.Replace("", " / ");

                                worksheet.Cells[h, w + 19].Value = data.REV_10 == null ? "" : data.REV_10.Replace("", " / ");

                                worksheet.Cells[h, w + 20].Value = data.REV_11 == null ? "" : data.REV_11.Replace("", " / ");

                                worksheet.Cells[h, w + 21].Value = data.REV_12 == null ? "" : data.REV_12.Replace("", " / ");

                                worksheet.Cells[h, w + 22].Value = data.REV_13 == null ? "" : data.REV_13.Replace("", " / ");

                                worksheet.Cells[h, w + 23].Value = data.REV_14 == null ? "" : data.REV_14.Replace("", " / ");

                                worksheet.Cells[h, w + 24].Value = data.REV_15 == null ? "" : data.REV_15.Replace("", " / ");

                                worksheet.Cells[h, w + 25].Value = data.REV_16 == null ? "" : data.REV_16.Replace("", " / ");

                                worksheet.Cells[h, w + 26].Value = data.REV_17 == null ? "" : data.REV_17.Replace("", " / ");

                                worksheet.Cells[h, w + 27].Value = data.REV_18 == null ? "" : data.REV_18.Replace("", " / ");

                                worksheet.Cells[h, w + 28].Value = data.REV_19 == null ? "" : data.REV_19.Replace("", " / ");

                            for (int columnIndex = 1; columnIndex < 11; ++columnIndex)

                            {    

                                worksheet.Columns[columnIndex].AutoFit();

                            }

                            worksheet.Columns["G"].Width = Convert.ToInt32(worksheet.Columns["G"].Width * 1.1);

                            workbook.Save(dialog.FileName);

                        {                        

        private static void SetWidth(ExcelColumn column, double width)

        {

            column.SetWidth(

                Math.Truncate((width * 7 + 5) / 7 * 256) / 256,

                LengthUnit.ZeroCharacterWidth);

        }

    <Reference Include="GemBox.Spreadsheet, Version=39.3.30.1215, Culture=neutral, PublicKeyToken=b1b72c69714d4847, processorArchitecture=MSIL">

      <HintPath>..\packages\GemBox.Spreadsheet.39.3.30.1215\lib\net30\GemBox.Spreadsheet.dll</HintPath>

    </Reference>

    <Reference Include="log4net, Version=2.0.8.0, Culture=neutral, PublicKeyToken=669e0ddf0bb1aa2a, processorArchitecture=MSIL">

      <HintPath>..\packages\log4net.2.0.8\lib\net45-full\log4net.dll</HintPath>

        [global::System.Configuration.UserScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("EXK0-W4HZ-N518-IMEW")]

        public string GemBoxLicense {

            get {

                return ((string)(this["GemBoxLicense"]));

            }

            set {

                this["GemBoxLicense"] = value;

            }

        }

    <Setting Name="GemBoxLicense" Type="System.String" Scope="User">

      <Value Profile="(Default)">EXK0-W4HZ-N518-IMEW</Value>

    </Setting>

      <setting name="GemBoxLicense" serializeAs="String">

        <value>EXK0-W4HZ-N518-IMEW</value>

      </setting>

  <package id="GemBox.Spreadsheet" version="39.3.30.1215" targetFramework="net461" />

  <package id="log4net" version="2.0.8" targetFramework="net45" />