Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unexpected attribute 'ca' when working with formular in xlsx file. #716

Open
sean1832 opened this issue Sep 28, 2023 · 0 comments
Open

Unexpected attribute 'ca' when working with formular in xlsx file. #716

sean1832 opened this issue Sep 28, 2023 · 0 comments

Comments

@sean1832
Copy link

Hi, I got error "Unexpected attribute 'ca'" when trying to load the excel file. This file can be open with python library.
Following is the .xml file that is failed to load:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<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 xr xr2 xr3" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2" xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3" xr:uid="{00000000-0001-0000-0100-000000000000}"><dimension ref="A1:F28"/><sheetViews><sheetView tabSelected="1" workbookViewId="0"><selection activeCell="A28" sqref="A28"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25"/><cols><col min="1" max="1" width="25.5703125" customWidth="1"/><col min="2" max="2" width="13.85546875" customWidth="1"/><col min="3" max="3" width="8.140625" customWidth="1"/><col min="4" max="4" width="16.7109375" customWidth="1"/><col min="5" max="5" width="17" customWidth="1"/><col min="6" max="6" width="14.7109375" customWidth="1"/></cols><sheetData><row r="1" spans="1:6" ht="23.25" customHeight="1" x14ac:dyDescent="0.35"><c r="A1" s="12" t="s"><v>0</v></c><c r="B1" s="13"/><c r="C1" s="13"/><c r="D1" s="13"/><c r="E1" s="13"/><c r="F1" s="13"/></row><row r="3" spans="1:6" ht="15.75" customHeight="1" x14ac:dyDescent="0.25"><c r="A3" s="4" t="s"><v>1</v></c><c r="B3" s="4" t="s"><v>2</v></c></row><row r="4" spans="1:6" x14ac:dyDescent="0.25"><c r="A4" t="s"><v>9</v></c><c r="B4" t="s"><v>28</v></c></row><row r="5" spans="1:6" x14ac:dyDescent="0.25"><c r="A5" t="s"><v>3</v></c><c r="B5" s="7" t="s"><v>4</v></c></row><row r="6" spans="1:6" x14ac:dyDescent="0.25"><c r="A6" t="s"><v>5</v></c><c r="B6" s="1" t="s"><v>6</v></c></row><row r="7" spans="1:6" x14ac:dyDescent="0.25"><c r="A7" t="s"><v>7</v></c><c r="B7" s="2" t="s"><v>8</v></c></row><row r="10" spans="1:6" ht="15.75" x14ac:dyDescent="0.25"><c r="A10" s="4" t="s"><v>38</v></c><c r="B10" s="4" t="s"><v>29</v></c></row><row r="11" spans="1:6" x14ac:dyDescent="0.25"><c r="A11" t="s"><v>9</v></c><c r="B11" t="s"><v>30</v></c></row><row r="12" spans="1:6" x14ac:dyDescent="0.25"><c r="A12" t="s"><v>10</v></c><c r="B12" s="5" t="s"><v>31</v></c></row><row r="14" spans="1:6" x14ac:dyDescent="0.25"><c r="E14" t="s"><v>11</v></c><c r="F14" t="s"><v>12</v></c></row><row r="15" spans="1:6" x14ac:dyDescent="0.25"><c r="E15" s="8"><f ca="1">Table25[[#This Row],[Invoice Date]]</f><v>45197</v></c><c r="F15" s="9"><f ca="1">TODAY()</f><v>45197</v></c></row><row r="17" spans="1:6" x14ac:dyDescent="0.25"><c r="A17" t="s"><v>13</v></c><c r="B17" t="s"><v>14</v></c><c r="C17" t="s"><v>15</v></c><c r="D17" t="s"><v>16</v></c><c r="E17" t="s"><v>32</v></c><c r="F17" t="s"><v>33</v></c></row><row r="18" spans="1:6" x14ac:dyDescent="0.25"><c r="A18" s="10" t="s"><v>34</v></c><c r="B18" s="6" t="s"><v>35</v></c><c r="C18" s="6" t="s"><v>36</v></c><c r="D18" t="s"><v>17</v></c><c r="E18" s="11" t="s"><v>37</v></c><c r="F18" s="6" t="s"><v>18</v></c></row><row r="19" spans="1:6" x14ac:dyDescent="0.25"><c r="A19" s="10"/><c r="B19" s="6"/><c r="C19" s="6"/><c r="E19" s="11"/><c r="F19" s="6"/></row><row r="20" spans="1:6" ht="18.75" customHeight="1" x14ac:dyDescent="0.25"><c r="A20" s="6"/><c r="B20" s="6"/><c r="C20" s="6"/><c r="E20" s="6"/><c r="F20" s="6"/></row><row r="21" spans="1:6" x14ac:dyDescent="0.25"><c r="A21" s="6"/><c r="B21" s="6"/><c r="C21" s="6"/><c r="E21" s="6"/><c r="F21" s="6"/></row><row r="22" spans="1:6" x14ac:dyDescent="0.25"><c r="A22" s="6"/><c r="B22" s="6"/><c r="C22" s="6"/><c r="E22" s="6"/><c r="F22" s="6"/></row><row r="23" spans="1:6" ht="18.75" customHeight="1" x14ac:dyDescent="0.3"><c r="A23" s="3" t="s"><v>19</v></c><c r="B23" s="6"/><c r="C23" s="6"/><c r="E23" s="3"><f>E18+E19+E20+E21+E22</f><v>160</v></c></row><row r="26" spans="1:6" ht="18.75" x14ac:dyDescent="0.3"><c r="A26" s="3" t="s"><v>20</v></c></row><row r="27" spans="1:6" x14ac:dyDescent="0.25"><c r="A27" t="s"><v>21</v></c><c r="B27" t="s"><v>22</v></c><c r="C27" t="s"><v>23</v></c><c r="D27" t="s"><v>24</v></c></row><row r="28" spans="1:6" x14ac:dyDescent="0.25"><c r="A28" t="s"><v>25</v></c><c r="B28" t="s"><v>2</v></c><c r="C28" s="5" t="s"><v>26</v></c><c r="D28" s="5" t="s"><v>27</v></c></row></sheetData><mergeCells count="1"><mergeCell ref="A1:F1"/></mergeCells><hyperlinks><hyperlink ref="B6" r:id="rId1" xr:uid="{00000000-0004-0000-0100-000000000000}"/></hyperlinks><pageMargins left="1.085" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/><pageSetup scale="92" orientation="portrait" horizontalDpi="1200" verticalDpi="1200" r:id="rId2"/><tableParts count="3"><tablePart r:id="rId3"/><tablePart r:id="rId4"/><tablePart r:id="rId5"/></tableParts></worksheet>

I think it has to do with the part:

<f ca="1">Table25[[#This Row],[Invoice Date]]</f>
<f ca="1">TODAY()</f>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant