ExcelConfig.cs 3.2 KB

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