[Office] Office Web Note

Office Web Note


http://blog.darkthread.net/post-2014-12-13-office-wildcard-replacement.aspx

◎ CodeProject Adam Tibi -- Using C# .NET User Defined Functions (UDF) in Excel 2013-6-13
http://www.codeproject.com/Articles/606446/UsingplusC-23plus-NETplusUserplusDefinedplusFuncti

EXCEL开发——Interior.ColorIndex 色彩列表收藏
无色 0   19   38
  1   20   39
白色 2   21   40
  3   22   41
  4   23   42
  5   24   43
  6   25   44
  7   26   45
  8   27   46
  9   28   47
  10   29   48
  11   30   49
  12   31   50
  13   32   51
  14   33   52
  15   34   53
  16   35   54
  17   36   55
  18   37   56
Range r = (Range)work_sheet.Cells[1, 1];
r.Interior.ColorIndex = 38;