Here’s some basic for automating Excel from C#.<\/p>\n
Make sure you dereference your Excel COM objects<\/strong><\/p>\n Actually I’m going to start with a word of caution. When interacting with Excel you need to ensure that you dereference any Excel objects after use or you’ll find Excel remains in memory when you probably thought it had been closed.<\/em><\/p>\n To correctly deal with Excel’s COM objects the best thing to do is store each object in a variable and when you’ve finished with it, make sure you set that variable to null. Accessing some Excel objects using simply dot notation such as <\/p>\n will result in COM objects being created but without your application having a reference to them they’ll remain referenced long after you expect. <\/p>\n Instead do things like<\/p>\n If in doubt, check via Task Manager to see if your instance of Excel has been closed.<\/p>\n Starting Excel<\/strong><\/p>\n Setting Cell data<\/strong><\/p>\n Grouping a range<\/strong><\/p>\n Change the background colour<\/strong><\/p>\n Change the background colour from a Color object<\/strong><\/p>\n We can use the built-in colour conversion code, which from WPF would mean converting to a System.Drawing.Color, as per this<\/p>\n Now we can use this as follows<\/p>\n or we can do this ourselves using<\/p>\n Changing the foreground colour<\/strong><\/p>\n References<\/strong><\/p>\n https:\/\/msdn.microsoft.com\/en-us\/library\/microsoft.office.interop.excel.aspx<\/p>\n","protected":false},"excerpt":{"rendered":" Here’s some basic for automating Excel from C#. Make sure you dereference your Excel COM objects Actually I’m going to start with a word of caution. When interacting with Excel you need to ensure that you dereference any Excel objects after use or you’ll find Excel remains in memory when you probably thought it had […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,54],"tags":[],"class_list":["post-3758","post","type-post","status-publish","format-standard","hentry","category-c","category-excel"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/3758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/comments?post=3758"}],"version-history":[{"count":11,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/3758\/revisions"}],"predecessor-version":[{"id":4138,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/3758\/revisions\/4138"}],"wp:attachment":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/media?parent=3758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/categories?post=3758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/tags?post=3758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\r\napplication.Workbooks[0].Sheets[1];\r\n<\/pre>\n
\r\nvar workbooks = application.Workbooks[0];\r\nvar workSheet = workbooks.Sheets[1];\r\n<\/pre>\n
\r\nvar application = new Excel.Application();\r\nvar workbook = application.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);\r\nExcel.Worksheet worksheet = workbook.Sheets[1];\r\n\r\napplication.Visible = true;\r\n<\/pre>\n
\r\nworksheet.Cells[row, column++] = \r\n cell.Value != null ? \r\n cell.Value.ToString() : \r\n String.Empty;\r\n<\/pre>\n
\r\nExcel.Range range = worksheet.Rows[String.Format("{0}:{1}", row, row + children)];\r\nrange.OutlineLevel = indent;\r\nrange.Group(Missing.Value, Missing.Value, Missing.Value, Missing.Value);\r\n<\/pre>\n\r\nworksheet.Rows[row].Interior.Color = Excel.XlRgbColor.rgbRed;\r\n<\/pre>\n
\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSystem.Drawing.Color clr = System.Drawing.Color.FromArgb(solid.Color.A, solid.Color.R, solid.Color.G, solid.Color.B);\r\n<\/pre>\n
\r\nworksheet.Rows[row].Interior.Color = ColorTranslator.ToOle(clr);\r\n<\/pre>\n
\r\nint clr = solid.Color.R | solid.Color.G << 8 | solid.Color.B << 16;\t\t\t\t\t\t\t\t\tworksheet.Rows[row].Interior.Color = clr;\r\n<\/pre>\n
\r\nint clr = solid.Color.R | solid.Color.G << 8 | solid.Color.B << 16;\t\t\t\t\t\t\t\t\tworksheet.Rows[row].Font.Color = clr;\r\n<\/pre>\n