Skip to content

Query Support Sheet Xml c without r #2

@shps951023

Description

@shps951023

Normal data like :

<?xml version="1.0" encoding="utf-8"?>
<worksheet xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
    xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
    <dimension ref="A1:B2" />
    <sheetViews>
        <sheetView workbookViewId="0" />
    </sheetViews>
    <sheetFormatPr defaultRowHeight="15" />
    <sheetData>
        <row r="1">
            <c r="A1" s="0" t="s">
                <v>0</v>
            </c>
            <c r="B1" s="0">
                <v>44257.384891898146</v>
            </c>
        </row>
        <row r="2">
            <c r="A2" s="0">
                <f>=MID(A1, 7, 5)</f>
            </c>
            <c r="B2" s="0">
                <v>123</v>
            </c>
        </row>
    </sheetData>
    <headerFooter />
</worksheet>

But simple data will like :

<?xml version="1.0" encoding="utf-8"?>
<x:worksheet xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
    <x:sheetData>
        <x:row>
            <x:c t="n">
                <x:v>1</x:v>
            </x:c>
            <x:c t="str">
                <x:v>"&lt;&gt;+}{\nHello World</x:v>
            </x:c>
            <x:c t="b">
                <x:v>1</x:v>
            </x:c>
            <x:c t="d">
                <x:v>2021-03-02T08:47:12</x:v>
            </x:c>
        </x:row>
        <x:row>
            <x:c t="n">
                <x:v>1</x:v>
            </x:c>
            <x:c t="str">
                <x:v>"&lt;&gt;+}{\nHello World</x:v>
            </x:c>
            <x:c t="b">
                <x:v>1</x:v>
            </x:c>
            <x:c t="d">
                <x:v>2021-03-02T08:47:12</x:v>
            </x:c>
        </x:row>
    </x:sheetData>
</x:worksheet>

image

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requesthelp wantedExtra attention is neededquestionFurther information is requestedtodo

    Type

    No type

    Projects

    Status

    Done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions