public CorrectSheetOutput(Workbook outputBook, SheetReader reader, TipStyle styles, ValidateColumnCollection columns) { outputBook.CalculateFormula(); _output_book = outputBook; _reader = reader; _reader.ConvertFormulaToValue(); _styles = styles; _new_index = 1; try { _target_sheet = outputBook.Worksheets[SheetName]; _target_sheet.Cells.ClearContents(0, 0, _target_sheet.Cells.MaxDataRow, _target_sheet.Cells.MaxDataColumn); Range rng = _target_sheet.Cells.CreateRange(0, 0, _target_sheet.Cells.MaxRow + 1, _target_sheet.Cells.MaxColumn + 1); rng.Style = _styles.Normal; } catch (Exception) { int index = outputBook.Worksheets.Add(); _target_sheet = outputBook.Worksheets[index]; _target_sheet.Name = SheetName; } _columns = columns; foreach (ValidateColumn each in columns.Values) { _target_sheet.Cells[0, each.Index].PutValue(each.Name); _target_sheet.Cells[0, each.Index].Style = _styles.Normal; } _target_sheet.ClearComments(); }
public CommentOutput(SheetReader reader, TipStyle styles) { _reader = reader; _sheet = reader.Sheet; _columns = reader.Columns; _styles = styles; _sheet.ClearComments(); //清除所有註解。 ResetSheetStyle(); }
public CorrectSheetOutput(Workbook outputBook, SheetReader reader, TipStyle styles, ValidateColumnCollection columns) { outputBook.CalculateFormula(); _output_book = outputBook; _reader = reader; _reader.ConvertFormulaToValue(); _styles = styles; _new_index = 1; try { _target_sheet = outputBook.Worksheets[SheetName]; _target_sheet.Cells.ClearContents(0, 0, _target_sheet.Cells.MaxDataRow, _target_sheet.Cells.MaxDataColumn); Range rng = _target_sheet.Cells.CreateRange(0, 0, _target_sheet.Cells.MaxRow + 1, _target_sheet.Cells.MaxColumn + 1); // 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入? 更改為新版 Aspose.Cells_201402 寫法 ,SetStyle() //rng.Style = _styles.Normal; rng.SetStyle(_styles.Normal); } catch (Exception) { int index = outputBook.Worksheets.Add(); _target_sheet = outputBook.Worksheets[index]; _target_sheet.Name = SheetName; } _columns = columns; foreach (ValidateColumn each in columns.Values) { _target_sheet.Cells[0, each.Index].PutValue(each.Name); // 2017/8/22 穎驊依據高雄小組專案 [03-05][04+] EXCEL匯入格式可否修正為xlsx也可匯入? 更改為新版 Aspose.Cells_201402 寫法 ,SetStyle() //_target_sheet.Cells[0, each.Index].Style = _styles.Normal; _target_sheet.Cells[0, each.Index].SetStyle(_styles.Normal); } _target_sheet.ClearComments(); }