/// <summary>
/// 这个方法，用来确定模板。
/// </summary>
/// <param name="wS"></param>
/// <param name="dt"></param>
public static void defineExcelTemplate(Worksheet wS, List <TemplateProperty> templatePropertyList, ProgressBar pb)
{
//以下依据DataTable 来 确定 模板内容
Usual_Excel_Helper uEHelper = new Usual_Excel_Helper(wS);
pb.Visible = true;
pb.Maximum = templatePropertyList.Count;
pb.Value = 0;
//打开该文档.
for (int i = 0; i <= templatePropertyList.Count - 1; i++)
{
string property_name = templatePropertyList[i].Property_name;
decimal visible = templatePropertyList[i].Visible;
bool isVisible = (1 == visible) ? true : false;
if (isVisible)
{
pb.Value++;
continue;
}
//获取该属性对应的行号.
int[] rowIndexArray = uEHelper.getRowIndexArrayWhichContainContent(property_name);
for (int j = 0; j <= rowIndexArray.Length - 1; j++)
{
uEHelper.delTheSpecificRowShiftToUp(rowIndexArray[j] - j);
}
pb.Value++;
}
pb.Visible = false;
pb.Maximum = 0;
pb.Value = 0;
}
/// <summary>
/// 这个方法，用来确定模板。
/// </summary>
/// <param name="wS"></param>
/// <param name="dt"></param>
public static void defineExcelTemplate(Worksheet wS, List <TemplateProperty> templatePropertyList, ProgressBar pb)
{
//以下依据DataTable 来 确定 模板内容
Usual_Excel_Helper uEHelper = new Usual_Excel_Helper(wS);
pb.Visible = true;
pb.Maximum = templatePropertyList.Count;
pb.Value = 0;
//打开该文档.
//每删除一行。Excel 对应的行索引都要减少。
int j = 0;
for (int i = 0; i <= templatePropertyList.Count - 1; i++)
{
string property_name = templatePropertyList[i].Property_name;
string property_chinese_name = templatePropertyList[i].Property_chinese_name;
decimal visible = templatePropertyList[i].Visible;
bool isVisible = (1 == visible) ? true : false;
if (isVisible)
{
pb.Value++;
continue;
}
//若此属性不显示
//获取该属性对应的行号.
HashSet <int> hashSetRownIndex = uEHelper.getRowIndexArrayWhichContainContent(property_chinese_name);
foreach (int rowIndex in hashSetRownIndex)
{
//不显示的属性，进行删除。
uEHelper.delTheSpecificRowShiftToUp(rowIndex - j);
j++;
}
pb.Value++;
}
pb.Visible = false;
pb.Maximum = 0;
pb.Value = 0;
}
