本文整理汇总了C#中Worksheet.ValidateNewWorksheet方法的典型用法代码示例。如果您正苦于以下问题：C# Worksheet.ValidateNewWorksheet方法的具体用法？C# Worksheet.ValidateNewWorksheet怎么用？C# Worksheet.ValidateNewWorksheet使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Worksheet的用法示例。
在下文中一共展示了Worksheet.ValidateNewWorksheet方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Add
private void Add(Worksheet worksheet, int? insertAfterSheetNumber = null, string insertAfterSheetName = null)
{
CheckFiles();
PrepareArchive(true);
worksheet.ValidateNewWorksheet(this, insertAfterSheetNumber, insertAfterSheetName);
if (this.AddWorksheets == null)
{
this.AddWorksheets = new List<WorksheetAddSettings>();
}
this.AddWorksheets.Add(worksheet.AddSettings);
if (!this.ReadOnly)
{
throw new Exception("FastExcel is in ReadOnly mode so cannot perform a write");
}
// Check if ExistingHeadingRows will be overridden by the dataset
if (worksheet.ExistingHeadingRows != 0 && worksheet.Rows.Where(r => r.RowNumber <= worksheet.ExistingHeadingRows).Any())
{
throw new Exception("Existing Heading Rows was specified but some or all will be overridden by data rows. Check DataSet.Row.RowNumber against ExistingHeadingRows");
}
using (StreamWriter streamWriter = null)//new StreamWriter(this.Archive.CreateEntry(worksheet.FileName).Open()))
{
streamWriter.Write(worksheet.Headers);
if (!worksheet.Template)
{
worksheet.Headers = null;
}
this.SharedStrings.ReadWriteMode = true;
// Add Rows
foreach (Row row in worksheet.Rows)
{
streamWriter.Write(row.ToXmlString(this.SharedStrings));
}
this.SharedStrings.ReadWriteMode = false;
//Add Footers
streamWriter.Write(worksheet.Footers);
if (!worksheet.Template)
{
worksheet.Footers = null;
}
streamWriter.Flush();
}
}