API tools faq
paste
Advertisement
voodooKobra

Troubleshooting PHPExcel

voodooKobra
Feb 20th, 2014
201
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 16.70 KB | None | 0 0
raw download clone embed print report
  1. sarciszewski@sarciszewski-VirtualBox ~/code $ ls -lah test3/docProps test4/docProps
  2. test3/docProps:
  3. total 16K
  4. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  5. drwxr-xr-x 5 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  6. -rw-r--r-- 1 sarciszewski sarciszewski  785 Jan  1  1980 app.xml
  7. -rw-r--r-- 1 sarciszewski sarciszewski  603 Jan  1  1980 core.xml
  8.  
  9. test4/docProps:
  10. total 16K
  11. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  12. drwxr-xr-x 5 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  13. -rw-r--r-- 1 sarciszewski sarciszewski  267 Feb 20  2014 app.xml
  14. -rw-r--r-- 1 sarciszewski sarciszewski  511 Feb 20  2014 core.xml
  15.  
  16. sarciszewski@sarciszewski-VirtualBox ~/code $ ls -lah test3/xl test4/xl
  17. test3/xl:
  18. total 40K
  19. drwxr-xr-x 6 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  20. drwxr-xr-x 5 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  21. -rw-r--r-- 1 sarciszewski sarciszewski  169 Jan  1  1980 calcChain.xml
  22. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 printerSettings
  23. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 _rels
  24. -rw-r--r-- 1 sarciszewski sarciszewski  424 Jan  1  1980 sharedStrings.xml
  25. -rw-r--r-- 1 sarciszewski sarciszewski 1.7K Jan  1  1980 styles.xml
  26. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 theme
  27. -rw-r--r-- 1 sarciszewski sarciszewski 1.2K Jan  1  1980 workbook.xml
  28. drwxr-xr-x 3 sarciszewski sarciszewski 4.0K Feb 20 12:02 worksheets
  29.  
  30. test4/xl:
  31. total 32K
  32. drwxr-xr-x 4 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  33. drwxr-xr-x 5 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  34. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 _rels
  35. -rw-r--r-- 1 sarciszewski sarciszewski  371 Feb 20  2014 sharedStrings.xml
  36. -rw-r--r-- 1 sarciszewski sarciszewski 6.4K Feb 20  2014 styles.xml
  37. -rw-r--r-- 1 sarciszewski sarciszewski  716 Feb 20  2014 workbook.xml
  38. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 worksheets
  39.  
  40. sarciszewski@sarciszewski-VirtualBox ~/code $ ls -lah test3/xl/_rels test4/xl/_rels
  41. test3/xl/_rels:
  42. total 12K
  43. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  44. drwxr-xr-x 6 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  45. -rw-r--r-- 1 sarciszewski sarciszewski  831 Jan  1  1980 workbook.xml.rels
  46.  
  47. test4/xl/_rels:
  48. total 12K
  49. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  50. drwxr-xr-x 4 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  51. -rw-r--r-- 1 sarciszewski sarciszewski  549 Feb 20  2014 workbook.xml.rels
  52.  
  53. sarciszewski@sarciszewski-VirtualBox ~/code $ ls -lah test3/xl/worksheets/ test4/xl/worksheets/
  54. test3/xl/worksheets/:
  55. total 16K
  56. drwxr-xr-x 3 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  57. drwxr-xr-x 6 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  58. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 _rels
  59. -rw-r--r-- 1 sarciszewski sarciszewski 1.9K Jan  1  1980 sheet1.xml
  60.  
  61. test4/xl/worksheets/:
  62. total 12K
  63. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  64. drwxr-xr-x 4 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  65. -rw-r--r-- 1 sarciszewski sarciszewski 3.1K Feb 20  2014 sheet1.xml
  66.  
  67. sarciszewski@sarciszewski-VirtualBox ~/code $ ls -lah test3/xl/worksheets/_rels/
  68. total 12K
  69. drwxr-xr-x 2 sarciszewski sarciszewski 4.0K Feb 20 12:02 .
  70. drwxr-xr-x 3 sarciszewski sarciszewski 4.0K Feb 20 12:02 ..
  71. -rw-r--r-- 1 sarciszewski sarciszewski  322 Jan  1  1980 sheet1.xml.rels
  72.  
  73. sarciszewski@sarciszewski-VirtualBox ~/code $ diff test3/docProps/app.xml test4/docProps/app.xml
  74. 1,2c1,2
  75. < <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  76. < <Properties xmlns="http://schemas.openxmlformats.org/officeDocument/2006/extended-properties" xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"><Application>Microsoft Excel</Application><DocSecurity>0</DocSecurity><ScaleCrop>false</ScaleCrop><HeadingPairs><vt:vector size="2" baseType="variant"><vt:variant><vt:lpstr>Worksheets</vt:lpstr></vt:variant><vt:variant><vt:i4>1</vt:i4></vt:variant></vt:vector></HeadingPairs><TitlesOfParts><vt:vector size="1" baseType="lpstr"><vt:lpstr>Sheet1</vt:lpstr></vt:vector></TitlesOfParts><Company></Company><LinksUpToDate>false</LinksUpToDate><SharedDoc>false</SharedDoc><HyperlinksChanged>false</HyperlinksChanged><AppVersion>15.0300</AppVersion></Properties>
  77. \ No newline at end of file
  78. ---
  79. > <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  80. > <Properties xmlns="http://schemas.openxmlformats.org/officeDocument/2006/extended-properties" xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"><TotalTime>0</TotalTime></Properties>
  81. \ No newline at end of file
  82. sarciszewski@sarciszewski-VirtualBox ~/code $ diff test3/docProps/core.xml test4/docProps/core.xml
  83. 1,2c1,2
  84. < <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  85. < <cp:coreProperties xmlns:cp="http://schemas.openxmlformats.org/package/2006/metadata/core-properties" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dcmitype="http://purl.org/dc/dcmitype/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><dc:creator>Scott</dc:creator><cp:lastModifiedBy>Scott</cp:lastModifiedBy><dcterms:created xsi:type="dcterms:W3CDTF">2014-02-20T16:42:26Z</dcterms:created><dcterms:modified xsi:type="dcterms:W3CDTF">2014-02-20T16:45:29Z</dcterms:modified></cp:coreProperties>
  86. \ No newline at end of file
  87. ---
  88. > <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  89. > <cp:coreProperties xmlns:cp="http://schemas.openxmlformats.org/package/2006/metadata/core-properties" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dcmitype="http://purl.org/dc/dcmitype/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><dcterms:created xsi:type="dcterms:W3CDTF">2014-02-20T11:58:00Z</dcterms:created><dc:creator>sarciszewski </dc:creator><cp:revision>0</cp:revision></cp:coreProperties>
  90. < <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  91. < <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><dimension ref="A1:G5"/><sheetViews><sheetView tabSelected="1" workbookViewId="0"><selection activeCell="G11" sqref="G11"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25"/><sheetData><row r="1" spans="1:7" x14ac:dyDescent="0.25"><c r="A1" s="1" t="s"><v>0</v></c><c r="B1" s="1" t="s"><v>9</v></c><c r="C1" s="1" t="s"><v>10</v></c><c r="D1" s="1"/><c r="E1" s="1" t="s"><v>11</v></c><c r="F1" s="1" t="s"><v>11</v></c><c r="G1" s="1" t="s"><v>2</v></c></row><row r="2" spans="1:7" x14ac:dyDescent="0.25"><c r="A2" t="s"><v>1</v></c><c r="D2" t="s"><v>11</v></c><c r="G2" t="s"><v>3</v></c></row><row r="3" spans="1:7" x14ac:dyDescent="0.25"><c r="A3" t="s"><v>4</v></c><c r="B3" t="s"><v>6</v></c><c r="C3" t="s"><v>5</v></c><c r="D3" t="s"><v>7</v></c><c r="E3" t="s"><v>5</v></c><c r="F3" t="s"><v>6</v></c><c r="G3" t="s"><v>4</v></c></row><row r="4" spans="1:7" x14ac:dyDescent="0.25"><c r="A4" t="s"><v>8</v></c><c r="B4" t="s"><v>8</v></c><c r="C4" t="s"><v>8</v></c><c r="D4" t="s"><v>8</v></c><c r="F4" t="s"><v>8</v></c><c r="G4" t="str"><f>CONCATENATE(A1, A2)</f><v>abrakadabra</v></c></row><row r="5" spans="1:7" x14ac:dyDescent="0.25"><c r="A5" t="s"><v>12</v></c><c r="B5" t="s"><v>13</v></c><c r="C5"><v>653214</v></c><c r="E5" t="s"><v>10</v></c><c r="G5" t="s"><v>3</v></c></row></sheetData><pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/><pageSetup orientation="portrait" verticalDpi="300" r:id="rId1"/></worksheet>
  92. \ No newline at end of file
  93. ---
  94. > <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  95. > <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><sheetPr filterMode="false"><pageSetUpPr fitToPage="false"/></sheetPr><dimension ref="A1:G5"/><sheetViews><sheetView colorId="64" defaultGridColor="true" rightToLeft="false" showFormulas="false" showGridLines="true" showOutlineSymbols="true" showRowColHeaders="true" showZeros="true" tabSelected="true" topLeftCell="A1" view="normal" windowProtection="false" workbookViewId="0" zoomScale="100" zoomScaleNormal="100" zoomScalePageLayoutView="100"><selection activeCell="G5" activeCellId="0" pane="topLeft" sqref="G5"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="12.8"></sheetFormatPr><cols><col collapsed="false" hidden="false" max="1025" min="1" style="0" width="11.5204081632653"/></cols><sheetData><row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.65" outlineLevel="0" r="1"><c r="A1" s="1" t="s"><v>0</v></c><c r="B1" s="1" t="s"><v>1</v></c><c r="C1" s="1" t="s"><v>2</v></c><c r="D1" s="1"/><c r="E1" s="1" t="s"><v>3</v></c><c r="F1" s="1" t="s"><v>3</v></c><c r="G1" s="1" t="s"><v>4</v></c></row><row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.65" outlineLevel="0" r="2"><c r="A2" s="0" t="s"><v>5</v></c><c r="G2" s="0" t="s"><v>6</v></c></row><row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.8" outlineLevel="0" r="3"><c r="A3" s="0" t="s"><v>7</v></c><c r="G3" s="0" t="s"><v>7</v></c></row><row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.1" outlineLevel="0" r="4"><c r="A4" s="0" t="s"><v>8</v></c><c r="B4" s="0" t="s"><v>8</v></c><c r="C4" s="0" t="s"><v>8</v></c><c r="D4" s="0" t="s"><v>8</v></c><c r="F4" s="0" t="s"><v>8</v></c><c r="G4" s="0" t="str"><f aca="false">CONCATENATE(A1,A2)</f><v>abrakadabra</v></c></row><row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.65" outlineLevel="0" r="5"><c r="A5" s="0" t="s"><v>9</v></c><c r="B5" s="0" t="s"><v>10</v></c><c r="C5" s="0" t="n"><v>653214</v></c><c r="E5" s="0" t="s"><v>2</v></c><c r="G5" s="0" t="s"><v>6</v></c></row></sheetData><printOptions headings="false" gridLines="false" gridLinesSet="true" horizontalCentered="false" verticalCentered="false"/><pageMargins left="0.7875" right="0.7875" top="1.05277777777778" bottom="1.05277777777778" header="0.7875" footer="0.7875"/><pageSetup blackAndWhite="false" cellComments="none" copies="1" draft="false" firstPageNumber="1" fitToHeight="1" fitToWidth="1" horizontalDpi="300" orientation="portrait" pageOrder="downThenOver" paperSize="1" scale="100" useFirstPageNumber="true" usePrinterDefaults="false" verticalDpi="300"/><headerFooter differentFirst="false" differentOddEven="false"><oddHeader>&amp;C&amp;&quot;Times New Roman,Regular&quot;&amp;12&amp;A</oddHeader><oddFooter>&amp;C&amp;&quot;Times New Roman,Regular&quot;&amp;12Page &amp;P</oddFooter></headerFooter></worksheet>
  96. \ No newline at end of file
  97.  
  98. # I decided to run the XML blobs through a beautifier then diff them again:
  99. sarciszewski@sarciszewski-VirtualBox ~/code $ diff sheet1_a.xml sheet1_b.xml
  100. 2c2,5
  101. < <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">
  102. ---
  103. > <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
  104. >     <sheetPr filterMode="false">
  105. >         <pageSetUpPr fitToPage="false" />
  106. >     </sheetPr>
  107. 5,6c8,9
  108. <         <sheetView tabSelected="1" workbookViewId="0">
  109. <             <selection activeCell="G11" sqref="G11" />
  110. ---
  111. >         <sheetView colorId="64" defaultGridColor="true" rightToLeft="false" showFormulas="false" showGridLines="true" showOutlineSymbols="true" showRowColHeaders="true" showZeros="true" tabSelected="true" topLeftCell="A1" view="normal" windowProtection="false" workbookViewId="0" zoomScale="100" zoomScaleNormal="100" zoomScalePageLayoutView="100">
  112. >             <selection activeCell="G5" activeCellId="0" pane="topLeft" sqref="G5" />
  113. 9c12,15
  114. <     <sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25" />
  115. ---
  116. >     <sheetFormatPr defaultRowHeight="12.8"></sheetFormatPr>
  117. >     <cols>
  118. >         <col collapsed="false" hidden="false" max="1025" min="1" style="0" width="11.5204081632653" />
  119. >     </cols>
  120. 11c17
  121. <         <row r="1" spans="1:7" x14ac:dyDescent="0.25">
  122. ---
  123. >         <row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.65" outlineLevel="0" r="1">
  124. 16c22
  125. <                 <v>9</v>
  126. ---
  127. >                 <v>1</v>
  128. 19c25
  129. <                 <v>10</v>
  130. ---
  131. >                 <v>2</v>
  132. 23c29
  133. <                 <v>11</v>
  134. ---
  135. >                 <v>3</v>
  136. 26c32
  137. <                 <v>11</v>
  138. ---
  139. >                 <v>3</v>
  140. 29,40c35
  141. <                 <v>2</v>
  142. <             </c>
  143. <         </row>
  144. <         <row r="2" spans="1:7" x14ac:dyDescent="0.25">
  145. <             <c r="A2" t="s">
  146. <                 <v>1</v>
  147. <             </c>
  148. <             <c r="D2" t="s">
  149. <                 <v>11</v>
  150. <             </c>
  151. <             <c r="G2" t="s">
  152. <                 <v>3</v>
  153. ---
  154. >                 <v>4</v>
  155. 43,45c38,40
  156. <         <row r="3" spans="1:7" x14ac:dyDescent="0.25">
  157. <             <c r="A3" t="s">
  158. <                 <v>4</v>
  159. ---
  160. >         <row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.65" outlineLevel="0" r="2">
  161. >             <c r="A2" s="0" t="s">
  162. >                 <v>5</v>
  163. 47c42
  164. <             <c r="B3" t="s">
  165. ---
  166. >             <c r="G2" s="0" t="s">
  167. 50,53c45,47
  168. <             <c r="C3" t="s">
  169. <                 <v>5</v>
  170. <             </c>
  171. <             <c r="D3" t="s">
  172. ---
  173. >         </row>
  174. >         <row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.8" outlineLevel="0" r="3">
  175. >             <c r="A3" s="0" t="s">
  176. 56,63c50,51
  177. <             <c r="E3" t="s">
  178. <                 <v>5</v>
  179. <             </c>
  180. <             <c r="F3" t="s">
  181. <                 <v>6</v>
  182. <             </c>
  183. <             <c r="G3" t="s">
  184. <                 <v>4</v>
  185. ---
  186. >             <c r="G3" s="0" t="s">
  187. >                 <v>7</v>
  188. 66,67c54,55
  189. <         <row r="4" spans="1:7" x14ac:dyDescent="0.25">
  190. <             <c r="A4" t="s">
  191. ---
  192. >         <row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.1" outlineLevel="0" r="4">
  193. >             <c r="A4" s="0" t="s">
  194. 70c58
  195. <             <c r="B4" t="s">
  196. ---
  197. >             <c r="B4" s="0" t="s">
  198. 73c61
  199. <             <c r="C4" t="s">
  200. ---
  201. >             <c r="C4" s="0" t="s">
  202. 76c64
  203. <             <c r="D4" t="s">
  204. ---
  205. >             <c r="D4" s="0" t="s">
  206. 79c67
  207. <             <c r="F4" t="s">
  208. ---
  209. >             <c r="F4" s="0" t="s">
  210. 82,83c70,71
  211. <             <c r="G4" t="str">
  212. <                 <f>CONCATENATE(A1, A2)</f>
  213. ---
  214. >             <c r="G4" s="0" t="str">
  215. >                 <f aca="false">CONCATENATE(A1,A2)</f>
  216. 87,89c75,77
  217. <         <row r="5" spans="1:7" x14ac:dyDescent="0.25">
  218. <             <c r="A5" t="s">
  219. <                 <v>12</v>
  220. ---
  221. >         <row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.65" outlineLevel="0" r="5">
  222. >             <c r="A5" s="0" t="s">
  223. >                 <v>9</v>
  224. 91,92c79,80
  225. <             <c r="B5" t="s">
  226. <                 <v>13</v>
  227. ---
  228. >             <c r="B5" s="0" t="s">
  229. >                 <v>10</v>
  230. 94c82
  231. <             <c r="C5">
  232. ---
  233. >             <c r="C5" s="0" t="n">
  234. 97,98c85,86
  235. <             <c r="E5" t="s">
  236. <                 <v>10</v>
  237. ---
  238. >             <c r="E5" s="0" t="s">
  239. >                 <v>2</v>
  240. 100,101c88,89
  241. <             <c r="G5" t="s">
  242. <                 <v>3</v>
  243. ---
  244. >             <c r="G5" s="0" t="s">
  245. >                 <v>6</v>
  246. 105,106c93,99
  247. <     <pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3" />
  248. <     <pageSetup orientation="portrait" verticalDpi="300" r:id="rId1" />
  249. ---
  250. >     <printOptions headings="false" gridLines="false" gridLinesSet="true" horizontalCentered="false" verticalCentered="false" />
  251. >     <pageMargins left="0.7875" right="0.7875" top="1.05277777777778" bottom="1.05277777777778" header="0.7875" footer="0.7875" />
  252. >     <pageSetup blackAndWhite="false" cellComments="none" copies="1" draft="false" firstPageNumber="1" fitToHeight="1" fitToWidth="1" horizontalDpi="300" orientation="portrait" pageOrder="downThenOver" paperSize="1" scale="100" useFirstPageNumber="true" usePrinterDefaults="false" verticalDpi="300" />
  253. >     <headerFooter differentFirst="false" differentOddEven="false">
  254. >         <oddHeader>&amp;C&amp;"Times New Roman,Regular"&amp;12&amp;A</oddHeader>
  255. >         <oddFooter>&amp;C&amp;"Times New Roman,Regular"&amp;12Page &amp;P</oddFooter>
  256. >     </headerFooter>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!