public void Output(RowMessage message)
{
foreach (CellMessage each in message.GetMessages())
{
int row = _reader.AbsoluteIndex;
byte column = 0;
if (_columns.ContainsKey(each.Column))
{
column = _columns[each.Column].AbsoluteIndex;
}
int index = _sheet.Comments.Add(row, column);
Comment objComment = _sheet.Comments[index];
objComment.Note = each.Message;
objComment.WidthCM = 5;
objComment.HeightCM = 3;
switch (each.MessageType)
{
case MessageType.Correct:
_sheet.Cells[row, column].Style = _styles.Correct;
break;
case MessageType.Warning:
_sheet.Cells[row, column].Style = _styles.Warning;
break;
case MessageType.Error:
_sheet.Cells[row, column].Style = _styles.Error;
break;
}
}
}
public void Output(RowMessage message)
{
foreach (ValidateColumn each in _columns.Values)
{
Cell cell = _target_sheet.Cells[_new_index, each.Index];
cell.PutValue(_reader.GetValue(each.Name));
// 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入？ 更改為新版 Aspose.Cells_201402 寫法 ，SetStyle()
//cell.Style = _styles.Normal;
cell.SetStyle(_styles.Normal);
_reader.GetCell(each.Name).Formula = "=" + _target_sheet.Name + "!" + cell.Name;
}
List <CellMessage> messages = message.GetMessages();
foreach (CellMessage each in messages)
{
int row = _new_index;
byte column = _columns[each.Column].Index;
int index = _target_sheet.Comments.Add(row, column);
Comment objComment = _target_sheet.Comments[index];
objComment.Note = each.Message;
objComment.WidthCM = 5;
objComment.HeightCM = 3;
switch (each.MessageType)
{
case MessageType.Correct:
// 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入？ 更改為新版 Aspose.Cells_201402 寫法 ，SetStyle()
//_target_sheet.Cells[row, column].Style = _styles.Correct;
_target_sheet.Cells[row, column].SetStyle(_styles.Correct);
break;
case MessageType.Warning:
// 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入？ 更改為新版 Aspose.Cells_201402 寫法 ，SetStyle()
//_target_sheet.Cells[row, column].Style = _styles.Warning;
_target_sheet.Cells[row, column].SetStyle(_styles.Warning);
break;
case MessageType.Error:
// 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入？ 更改為新版 Aspose.Cells_201402 寫法 ，SetStyle()
//_target_sheet.Cells[row, column].Style = _styles.Error;
_target_sheet.Cells[row, column].SetStyle(_styles.Error);
break;
}
}
_new_index++;
}
public void Output(RowMessage message)
{
foreach (CellMessage each in message.GetMessages())
{
int row = _reader.AbsoluteIndex;
// 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入？ 更改為新版 Aspose.Cells_201402 寫法 ，從使用 byte 改為 int
//byte column = 0;
int column = 0;
if (_columns.ContainsKey(each.Column))
{
column = _columns[each.Column].AbsoluteIndex;
}
int index = _sheet.Comments.Add(row, column);
Comment objComment = _sheet.Comments[index];
objComment.Note = each.Message;
objComment.WidthCM = 5;
objComment.HeightCM = 3;
switch (each.MessageType)
{
case MessageType.Correct:
// 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入？ 更改為新版 Aspose.Cells_201402 寫法 ，SetStyle()
//_sheet.Cells[row, column].Style = _styles.Correct;
_sheet.Cells[row, column].SetStyle(_styles.Correct);
break;
case MessageType.Warning:
// 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入？ 更改為新版 Aspose.Cells_201402 寫法 ，SetStyle()
//_sheet.Cells[row, column].Style = _styles.Warning;
_sheet.Cells[row, column].SetStyle(_styles.Warning);
break;
case MessageType.Error:
// 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入？ 更改為新版 Aspose.Cells_201402 寫法 ，SetStyle()
_sheet.Cells[row, column].SetStyle(_styles.Error);
break;
}
}
}
public void Output(RowMessage message)
{
foreach (ValidateColumn each in _columns.Values)
{
Cell cell = _target_sheet.Cells[_new_index, each.Index];
cell.PutValue(_reader.GetValue(each.Name));
cell.Style = _styles.Normal;
_reader.GetCell(each.Name).Formula = "=" + _target_sheet.Name + "!" + cell.Name;
}
List <CellMessage> messages = message.GetMessages();
foreach (CellMessage each in messages)
{
int row = _new_index;
byte column = _columns[each.Column].Index;
int index = _target_sheet.Comments.Add(row, column);
Comment objComment = _target_sheet.Comments[index];
objComment.Note = each.Message;
objComment.WidthCM = 5;
objComment.HeightCM = 3;
switch (each.MessageType)
{
case MessageType.Correct:
_target_sheet.Cells[row, column].Style = _styles.Correct;
break;
case MessageType.Warning:
_target_sheet.Cells[row, column].Style = _styles.Warning;
break;
case MessageType.Error:
_target_sheet.Cells[row, column].Style = _styles.Error;
break;
}
}
_new_index++;
}