/**
* @return the list of Single Xml Cells that provide a map rule to this mapping.
*/
public List <XSSFSingleXmlCell> GetRelatedSingleXMLCell()
{
List <XSSFSingleXmlCell> relatedSimpleXmlCells = new List <XSSFSingleXmlCell>();
int sheetNumber = mapInfo.Workbook.NumberOfSheets;
for (int i = 0; i < sheetNumber; i++)
{
XSSFSheet sheet = (XSSFSheet)mapInfo.Workbook.GetSheetAt(i);
foreach (POIXMLDocumentPart p in sheet.GetRelations())
{
if (p is SingleXmlCells)
{
SingleXmlCells SingleXMLCells = (SingleXmlCells)p;
foreach (XSSFSingleXmlCell cell in SingleXMLCells.GetAllSimpleXmlCell())
{
if (cell.GetMapId() == ctMap.ID)
{
relatedSimpleXmlCells.Add(cell);
}
}
}
}
}
return(relatedSimpleXmlCells);
}
public void TestMapInfoExists()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("CustomXMLMappings.xlsx");
MapInfo mapInfo = null;
SingleXmlCells SingleXMLCells = null;
foreach (POIXMLDocumentPart p in wb.GetRelations())
{
if (p is MapInfo)
{
mapInfo = (MapInfo)p;
CT_MapInfo ctMapInfo = mapInfo.GetCTMapInfo();
Assert.IsNotNull(ctMapInfo);
Assert.AreEqual(1, ctMapInfo.Schema.Count);
foreach (XSSFMap map in mapInfo.GetAllXSSFMaps())
{
string xmlSchema = map.GetSchema();
Assert.IsNotNull(xmlSchema);
}
}
}
XSSFSheet sheet1 = (XSSFSheet)wb.GetSheetAt(0);
foreach (POIXMLDocumentPart p in sheet1.GetRelations())
{
if (p is SingleXmlCells)
{
SingleXMLCells = (SingleXmlCells)p;
}
}
Assert.IsNotNull(mapInfo);
Assert.IsNotNull(SingleXMLCells);
}
public XSSFSingleXmlCell(CT_SingleXmlCell SingleXmlCell, SingleXmlCells parent)
{
this.SingleXmlCell = SingleXmlCell;
this.parent = parent;
}
