//
//private func
//
private bool TableFillIn(int[] rValidColArr, TableRowWriteFunc rOperatorFunc, Worksheet rWs)
{
bool bResult = true;
for (int nRowNum = 2; nRowNum <= rWs.UsedRange.Rows.Count; ++nRowNum)
{
string[] rValidStrArr = getRowValidData(rValidColArr, nRowNum, rWs);
bResult = rOperatorFunc(ref rValidStrArr) && bResult;
setRowValidData(rValidColArr, nRowNum, rWs, ref rValidStrArr);
}
return(bResult);
}
//brief
//继承自ExcelOperator
//提供主题配置需求初版excel表格的填写支持逻辑
//
public void excelFillIn(string szPath, TableRowWriteFunc rOperatorFunc, ref string szError)
{
//打开excel
openExcel(szPath);
Workbook rWorkbook = getWorkbook();
Sheets rWorkSheets = rWorkbook.Worksheets;
bool rNoError = true;
try
{//每个工作表都查 索引从1开始
for (int index = 1; index <= rWorkSheets.Count; ++index)
{
Worksheet rWs = (Worksheet)rWorkSheets[index];
if (rWs.Name == "系列套装配置")
{//系列套装配置表
int[] rValidColArr = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15 };
rNoError = TableFillIn(rValidColArr, rOperatorFunc, rWs) && rNoError;
}
else if (rWs.Name == "系列套装部件产出途径文本预设及系列碎片产出文本")
{//表
int[] rValidColArr = { 1, 2, 4, 5 };
rNoError = TableFillIn(rValidColArr, rOperatorFunc, rWs) && rNoError;
}
// else if (rWs.Name == "额外奖励配置")
// {//额外奖励配置表
// int[] rValidColArr = { 1, 2, 3, 4, 5, 6};
// rNoError = TableFillIn(rValidColArr, rOperatorFunc, rWs) && rNoError;
// }
}
//xmlFunc
}
catch (Exception ex)
{
szError = ex.ToString() + "\n";
}
finally
{
//关闭excel
}
}