D
D
Dmitry Skogorev2017-02-23 15:43:09
excel
Dmitry Skogorev, 2017-02-23 15:43:09

How to turn XML into XLS?

Good day everyone.
I got a file from one .net program (it has an internal extension .report)
In theory, this is XML and on its basis a document template with markup is generated, the
approximate form is as follows

<object i="33" type="Blocks.Block">
                        <int tag="id" value="152" />
                        <double tag="x" value="72.1999893188477" />
                        <double tag="y" value="163.899993896484" />
                        <double tag="width" value="11" />
                        <double tag="height" value="3.90000152587891" />
                        <string tag="text">(месяц)</string>
                        <string tag="fontName">Times New Roman</string>
                        <double tag="fontSize" value="9" />
                        <int tag="textColor" value="-16777216" />
                        <bool tag="fontBold" value="false" />
                        <bool tag="fontItalic" value="false" />
                        <bool tag="fontUnderline" value="false" />
                    </object>
                    <object i="34" type="Blocks.Block">
                        <int tag="id" value="153" />
                        <double tag="x" value="91.6999969482422" />
                        <double tag="y" value="163.899993896484" />
                        <double tag="width" value="7.5" />
                        <double tag="height" value="3.90000152587891" />
                        <string tag="text">(год)</string>
                        <string tag="fontName">Times New Roman</string>
                        <double tag="fontSize" value="9" />
                        <int tag="textColor" value="-16777216" />
                        <bool tag="fontBold" value="false" />
                        <bool tag="fontItalic" value="false" />
                        <bool tag="fontUnderline" value="false" />
                    </object>

I understand that this is XML The
question is how to get a finished document based on this - or in Excel itself, and ideally how to feed it to PHPExcel, if it can do this
Also please correct if this is not XML, but some format of the same crystal reports
Thank you in advance for your help

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question