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

Unable to read XLSX generated by third party program #466

Open
LizardLad opened this issue Sep 17, 2024 · 3 comments
Open

Unable to read XLSX generated by third party program #466

LizardLad opened this issue Sep 17, 2024 · 3 comments

Comments

@LizardLad
Copy link

I have been trying to use the library but I come across a CellTAttribute error. It states that it does not know of the inlineStr t attribute.

The offending part of the document seems to be this inlineStr from my very limited knowledge of spreadsheet formats.

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<x:worksheet xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" 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-0000-000000000000}" mc:Ignorable="x14ac xr xr2 xr3" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <x:dimension ref="A1" />
  <x:sheetViews>
    <x:sheetView tabSelected="1" workbookViewId="0" xr3:uid="{AEA406A1-0E4B-5B11-9CD5-51D6E497D94C}">
      <x:selection activeCell="B1" sqref="B1" />
    </x:sheetView>
  </x:sheetViews>
  <x:sheetFormatPr defaultRowHeight="15" />
  <x:sheetData>
    <x:row r="1" spans="1:1">
      <x:c r="A1" t="inlineStr">
        <x:v>0</x:v>
        <x:is><x:t>ID</x:t></x:is>
      </x:c>

Is this not supported by the package? If not would someone be able to point me in the right direction to start?

@F8RZD
Copy link

F8RZD commented Sep 23, 2024

provided snippet shows that your file is a xml file. xml is supported by excel but it's not theirs. so... talking about excel readers xml support is not a must have.

there are plenty great xml reader crates I recently used roxmltree and it was pretty much all I needed.

@LizardLad
Copy link
Author

Sorry, I probably should have clarified this is xl/worksheets/sheet1.xml in the generated xlsx document.

@tafia
Copy link
Owner

tafia commented Oct 10, 2024

Do you have a full excel file to test on ( and that we could add as a test to the project?)
Thanks

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

3 participants