XMLファイルのImport

VB

■XDocumentを使う

以下は、xml内の指定のNodeの値をListで取得する例

xDoc as XDocument = new XDocument.Load(importFilePath)

xDoc.Elements("mappings").Elements("mapping").

   Select(Function(x) x.Attribute("ColumnName").Value).ToList

 

<以下のようなXMLを想定>

 ----------------------------------------------------------------------------------------

<?xml version="1.0" encoding="utf-8" ?>
<mappings>
<mapping ColumnNo="1" ColumnName="AreaCode" />
<mapping ColumnNo="2" ColumnName="OldZipNo" />
<mapping ColumnNo="3" ColumnName="ZipNo" />
<mapping ColumnNo="4" ColumnName="KenNameKana" />
<mapping ColumnNo="5" ColumnName="ShikuChoNameKana" />
<mapping ColumnNo="6" ColumnName="ChoikiNameKana" />
<mapping ColumnNo="7" ColumnName="KenName" />
<mapping ColumnNo="8" ColumnName="ShikuChoName" />
<mapping ColumnNo="9" ColumnName="ChoikiName" />
<mapping ColumnNo="10" ColumnName="1" />
<mapping ColumnNo="11" ColumnName="2" />
<mapping ColumnNo="12" ColumnName="3" />
<mapping ColumnNo="13" ColumnName="4" />
<mapping ColumnNo="14" ColumnName="5" />
<mapping ColumnNo="15" ColumnName="6" />
</mappings>