ExcelConfig.cs 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Drawing;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace Lottomat.Util.Offices
  8. {
  9. /// <summary>
  10. ///版 本 V1.0
  11. ///创建人:赵轶
  12. ///日 期:2015/11/25
  13. ///描 述:Excel导入导出设置
  14. /// </summary>
  15. public class ExcelConfig
  16. {
  17. /// <summary>
  18. /// 文件名
  19. /// </summary>
  20. public string FileName { get; set; }
  21. /// <summary>
  22. /// 标题
  23. /// </summary>
  24. public string Title { get; set; }
  25. /// <summary>
  26. /// 前景色
  27. /// </summary>
  28. public Color ForeColor { get; set; }
  29. /// <summary>
  30. /// 背景色
  31. /// </summary>
  32. public Color Background { get; set; }
  33. private short _titlepoint;
  34. /// <summary>
  35. /// 标题字号
  36. /// </summary>
  37. public short TitlePoint
  38. {
  39. get
  40. {
  41. if (_titlepoint == 0)
  42. {
  43. return 20;
  44. }
  45. else
  46. {
  47. return _titlepoint;
  48. }
  49. }
  50. set { _titlepoint = value; }
  51. }
  52. private short _headpoint;
  53. /// <summary>
  54. /// 列头字号
  55. /// </summary>
  56. public short HeadPoint
  57. {
  58. get
  59. {
  60. if (_headpoint == 0)
  61. {
  62. return 10;
  63. }
  64. else
  65. {
  66. return _headpoint;
  67. }
  68. }
  69. set { _headpoint = value; }
  70. }
  71. /// <summary>
  72. /// 标题高度
  73. /// </summary>
  74. public short TitleHeight { get; set; }
  75. /// <summary>
  76. /// 列标题高度
  77. /// </summary>
  78. public short HeadHeight { get; set; }
  79. private string _titlefont;
  80. /// <summary>
  81. /// 标题字体
  82. /// </summary>
  83. public string TitleFont
  84. {
  85. get
  86. {
  87. if (_titlefont == null)
  88. {
  89. return "微软雅黑";
  90. }
  91. else
  92. {
  93. return _titlefont;
  94. }
  95. }
  96. set { _titlefont = value; }
  97. }
  98. private string _headfont;
  99. /// <summary>
  100. /// 列头字体
  101. /// </summary>
  102. public string HeadFont
  103. {
  104. get
  105. {
  106. if (_headfont == null)
  107. {
  108. return "微软雅黑";
  109. }
  110. else
  111. {
  112. return _headfont;
  113. }
  114. }
  115. set { _headfont = value; }
  116. }
  117. /// <summary>
  118. /// 是否按内容长度来适应表格宽度
  119. /// </summary>
  120. public bool IsAllSizeColumn { get; set; }
  121. /// <summary>
  122. /// 列设置
  123. /// </summary>
  124. public List<ColumnEntity> ColumnEntity { get; set; }
  125. }
  126. }