private List <DesignItem> GetDesignItems(IExcelFileReader reader)
{
reader.SetActiveSheet("DesignData");
var designs = new List <DesignItem>();
while (reader.ReadRow())
{
if (reader.GetColumnCount() < 7)
{
continue;
}
int design_id = 0;
string blname = "";
int size_x = 0;
int size_z = 0;
string transform = "";
decimal offset_x = 0;
decimal offset_z = 0;
if (!reader.ReadColumnAsInt(0, out design_id))
{
continue;
}
if (!reader.ReadColumnAsText(1, out blname))
{
continue;
}
if (!reader.ReadColumnAsInt(2, out size_x))
{
continue;
}
if (!reader.ReadColumnAsInt(3, out size_z))
{
continue;
}
if (!reader.ReadColumnAsText(4, out transform))
{
continue;
}
if (!reader.ReadColumnAsDecimal(5, out offset_x))
{
continue;
}
if (!reader.ReadColumnAsDecimal(6, out offset_z))
{
continue;
}
designs.Add(new DesignItem()
{
DesignID = design_id,
BricklinkName = blname,
SizeX = size_x,
SizeZ = size_z,
Transform = transform,
OffsetX = (float)offset_x,
OffsetZ = (float)offset_z,
});
if (reader.GetColumnCount() >= 10)
{
if (!reader.ReadColumnAsText(7, out transform))
{
continue;
}
if (!reader.ReadColumnAsDecimal(8, out offset_x))
{
continue;
}
if (!reader.ReadColumnAsDecimal(9, out offset_z))
{
continue;
}
designs.Add(new DesignItem()
{
DesignID = design_id,
BricklinkName = blname,
SizeX = size_z,
SizeZ = size_x, // Flipped 90 degree
Transform = transform,
OffsetX = (float)offset_x,
OffsetZ = (float)offset_z,
});
}
}
return(designs);
}
