public void LoadXLS()
{
Excel.Range rngVal;
int nCount = 0;
CTextData[] data = new CTextData[MH4Global.colList.Length * (rowCnt + 1) / MH4Global.THREAD_MAX];
for (int i = 0; i < data.Length; ++i)
{
data[i] = new CTextData();
}
StringBuilder sbText = new StringBuilder();
sbText.Capacity = 1024;
StringBuilder sbPreFix = new StringBuilder();
StringBuilder sbID = new StringBuilder();
for (int i = rowStart; i < rowCnt; i += rowInc)
{
sbPreFix.Remove(0, sbPreFix.Length);
MH4Global.pgbXLS.Value = Math.Min(MH4Global.pgbXLS.Maximum, MH4Global.pgbXLS.Value + 1);
rngVal = (Excel.Range)rng.Cells[i, 2]; // ID의 Prefix
if (rngVal.Value2 == null)
{
continue;
}
sbPreFix.Append(rngVal.Value2.ToString());
for (int j = 1; j < MH4Global.colList.Length; ++j)
{
sbID.Remove(0, sbID.Length);
sbText.Remove(0, sbText.Length);
sbID.Append(sbPreFix.ToString());
sbID.Append(j >= 10 ? j.ToString() : "0" + j.ToString());
rngVal = (Excel.Range)rng.Cells[i, MH4Global.colList[j]];
if (rngVal.Value2 == null) // 문자열이 없으면 @
{
sbText.Append("@");
}
else // 스페이스만 있는 경우도 있다. 이 경우도 @처리
{
sbText.Append(rngVal.Value2.ToString().TrimStart(' '));
if (sbText.Length > 0)
{
sbText.Insert(0, GetMetaTag(i, MH4Global.colList[j]));
}
else
{
sbText.Append("@");
}
}
data[nCount].Id = sbID.ToString();
data[nCount].Text = sbText.ToString();
lock (thisLock)
{
dataBase.AddData(data[nCount]);
}
++nCount;
}
Thread.Sleep(0);
}
}
public void AddData(CTextData data)
{
listText.Add(data);
}
// Special Quest 용 XLS를 로딩한다. (일반 퀘스트 문서와 형식이 다르다)
public void LoadXLSSpecial()
{
Excel.Range rngVal1, rngVal2;
int nCount = 0;
CTextData[] data = new CTextData[MH4Global.colList.Length * (rowCnt + 1) / MH4Global.THREAD_MAX];
for (int i = 0; i < data.Length; ++i)
{
data[i] = new CTextData();
}
StringBuilder sbText = new StringBuilder();
sbText.Capacity = 1024;
StringBuilder sbID = new StringBuilder();
for (int i = rowStart; i < rowCnt; i += rowInc)
{
sbID.Remove(0, sbID.Length);
sbText.Remove(0, sbText.Length);
MH4Global.pgbXLS.Value = Math.Min(MH4Global.pgbXLS.Maximum, MH4Global.pgbXLS.Value + 1);
// ID
rngVal1 = (Excel.Range)rng.Cells[i, 2];
if (rngVal1.Value2 == null)
{
continue;
}
sbID.Append(rngVal1.Value2.ToString());
// 텍스트 문자열 ( C 열 + H 열)
rngVal1 = rng.get_Range("C" + i.ToString(), Missing.Value);
rngVal2 = rng.get_Range("H" + i.ToString(), Missing.Value);
if (rngVal1.Value2 != null)
{
sbText.Append(rngVal1.Value2.ToString());
}
if (rngVal2.Value2 != null)
{
sbText.Append(rngVal2.Value2.ToString());
}
if (sbText.Length == 0)
{
sbText.Append("@");
}
data[nCount].Id = sbID.ToString();
data[nCount].Text = sbText.ToString();
lock (thisLock)
{
dataBase.AddData(data[nCount]);
}
++nCount;
Thread.Sleep(0);
}
}
