public ExcelSingleKeyData getExcelSingleKeyData()
{
ExcelSingleKeyData rtn = new ExcelSingleKeyData();
rtn._pmKey = _pmKey;
rtn.dataHeaders = new List <string>();
rtn._datas = new Dictionary <string, List <object> >();
string[] headerNames = m_header.Data;
for (int i = 0; i < headerNames.Length; i++)
{
if (headerNames[i] != _pmKey)
{
rtn.dataHeaders.Add(headerNames[i]);
}
}
foreach (KeyValuePair <string, List <object> > pair in _data)
{
rtn._datas[pair.Key] = new List <object>();
for (int i = 0; i < headerNames.Length; i++)
{
if (headerNames[i] != _pmKey)
{
rtn._datas[pair.Key].Add(pair.Value[i]);
}
}
}
return(rtn);
}
public void initByFile(string v_excelPath)
{
Excel.Workbook book = new Excel.Workbook(v_excelPath);
Excel.Worksheet sheet = book.Worksheets["CString"];
ExcelSheetObject eso = new ExcelSheetObject(sheet, "CString");
eso.init_header();
eso.init_data("Key");
ExcelSingleKeyData eskd = eso.getExcelSingleKeyData();
string[] headerNames = eskd.dataHeaders.ToArray();
foreach (string key in eskd._datas.Keys)
{
if (!_data.ContainsKey(key))
{
_data[key] = new Dictionary <string, string>();
_words.Add(key);
for (int i = 0; i < eskd.dataHeaders.Count; i++)
{
_data[key][eskd.dataHeaders[i]] = Convert.ToString(eskd._datas[key][i]);
}
}
}
}
