Geek asks and answers

Excel program document update

First, for context, I’m a student in the automation team of a software development company, so I help develop automated test programs for our daily builds.

My line manager prepared an excel document that will be used to present the results from our test environments. Our tests are performed on a virtual PC on a hyper-V server.

I want to be able to update this excel document with test results from each test environment, but I'm not sure how I should do this.

Each of the virtual PCs launches an automation program (C # .NET 4.0) and currently copies test logs and results files to a shared folder on our build machine, accessible to everyone.

Therefore, I want the automation program to run its tests, and then when it is finished, I want it to write to the table in the excel document with the test results. Does anyone have experience translating Excel documents programmatically? It should also be noted that the excel document will be stored in a shared folder on the remote virtual PC (accessible from the test environment).

The table will show the name / build date, environment information, type of test and test result, etc.

I already collect this information and present it in HTML files, but there is a separate HTML file for each test environment. The purpose of this is to have all the results in one place (an Excel document will focus on presenting data in tables in the form of graphs and charts).

, , , excel .NET-. , ( , ), stackoverflow, , , ).

+3
4

. OLEDB, interop ( get_Range() ListObjects["table_name"].DataBodyRange).

Excel , XML- - . , xsd , xml, Excel . ( , , .)

mj82. Excel - . ( "" 2003 ) . , .

UPDATE: xml- Excel, .

xml- (xsd ). :

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="BILLSTRINGS" targetNamespace="http://tempuri.org/BILLSTRINGS.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/BILLSTRINGS.xsd" xmlns:mstns="http://tempuri.org/BILLSTRINGS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="BILLSTRINGS">
        <xs:complexType>
            <xs:sequence>
                <xs:element name="STRINGS" maxOccurs="unbounded">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="ID_GOOD" type="xs:string" />
                            <xs:element name="NAME_GOOD" type="xs:string" />
                            <xs:element name="Quantity" type="xs:string" />
                            <xs:element name="Price" type="xs:string" />
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
            </xs:sequence>
        </xs:complexType>
    </xs:element>
</xs:schema>

, xsd , ms help.

: xml. ( DataSets, GetXml.) Excel:

using OExcel = Microsoft.Office.Interop.Excel;
//...
OExcel.Application app = new OExcel.ApplicationClass(); 
OExcel.Workbook wb = app.Workbooks.Open(filepath, false, false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
wb.XmlMaps["MAPNAME"].ImportXml(string_with_xml);

. , .

+2

.

.

+1

OfficeWriter - XLS/XLSX ( Word). , 8.0.

http://www.officewriter.com

0

More articles:


All Articles