FormatCodes.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161
  1. <?php
  2. // Excel Format Code Result
  3. return [
  4. [
  5. false,
  6. 'General',
  7. ],
  8. [
  9. false,
  10. '@',
  11. ],
  12. [
  13. false,
  14. '0',
  15. ],
  16. [
  17. false,
  18. '0.00',
  19. ],
  20. [
  21. false,
  22. '#,##0.00',
  23. ],
  24. [
  25. false,
  26. '#,##0.00_-',
  27. ],
  28. [
  29. false,
  30. '0%',
  31. ],
  32. [
  33. false,
  34. '0.00%',
  35. ],
  36. [
  37. true,
  38. 'yyyy-mm-dd',
  39. ],
  40. [
  41. true,
  42. 'yy-mm-dd',
  43. ],
  44. [
  45. true,
  46. 'dd/mm/yy',
  47. ],
  48. [
  49. true,
  50. 'd/m/y',
  51. ],
  52. [
  53. true,
  54. 'd-m-y',
  55. ],
  56. [
  57. true,
  58. 'd-m',
  59. ],
  60. [
  61. true,
  62. 'm-y',
  63. ],
  64. [
  65. true,
  66. 'mm-dd-yy',
  67. ],
  68. [
  69. true,
  70. 'd-mmm-yy',
  71. ],
  72. [
  73. true,
  74. 'd-mmm',
  75. ],
  76. [
  77. true,
  78. 'mmm-yy',
  79. ],
  80. [
  81. true,
  82. 'm/d/yy h:mm',
  83. ],
  84. [
  85. true,
  86. 'd/m/y h:mm',
  87. ],
  88. [
  89. true,
  90. 'h:mm AM/PM',
  91. ],
  92. [
  93. true,
  94. 'h:mm:ss AM/PM',
  95. ],
  96. [
  97. true,
  98. 'h:mm',
  99. ],
  100. [
  101. true,
  102. 'h:mm:ss',
  103. ],
  104. [
  105. true,
  106. 'mm:ss',
  107. ],
  108. [
  109. true,
  110. 'h:mm:ss',
  111. ],
  112. [
  113. true,
  114. 'i:s.S',
  115. ],
  116. [
  117. true,
  118. 'h:mm:ss;@',
  119. ],
  120. [
  121. true,
  122. 'yy/mm/dd;@',
  123. ],
  124. [
  125. false,
  126. '"$" #,##0.00_-',
  127. ],
  128. [
  129. false,
  130. '$#,##0_-',
  131. ],
  132. [
  133. false,
  134. '[$EUR ]#,##0.00_-',
  135. ],
  136. [
  137. false,
  138. '_[$EUR ]#,##0.00_-',
  139. ],
  140. [
  141. false,
  142. '[Green]#,##0.00;[Red]#,##0.00_-',
  143. ],
  144. [
  145. false,
  146. '#,##0.00 "dollars"',
  147. ],
  148. [
  149. true,
  150. '"date " y-m-d',
  151. ],
  152. [
  153. false,
  154. '\C\H\-00000',
  155. ],
  156. [
  157. false,
  158. '\D-00000',
  159. ],
  160. ];