public static void Run()
{
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
//Output directory
string outputDir = RunExamples.Get_OutputDirectory();
// Create a workbook and opening a template spreadsheet
Workbook workbook = new Workbook(sourceDir + "sampleErrorCheckingOptions.xlsx");
// Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
// Instantiate the error checking options
ErrorCheckOptionCollection opts = sheet.ErrorCheckOptions;
int index = opts.Add();
ErrorCheckOption opt = opts[index];
// Disable the numbers stored as text option
opt.SetErrorCheck(ErrorCheckType.TextNumber, false);
// Set the range
CellArea ca = CellArea.CreateCellArea("A1", "E20");
opt.AddRange(ca);
// Save the Excel file
workbook.Save(outputDir + "outputErrorCheckingOptions.xlsx");
Console.WriteLine("ErrorCheckingOptions executed successfully.\r\n");
}
public static void Main()
{
//ExStart:1
// The path to the documents directory.
string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
//Create a workbook and opening a template spreadsheet
Workbook workbook = new Workbook(dataDir + "Book1.xlsx");
//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Instantiate the error checking options
ErrorCheckOptionCollection opts = sheet.ErrorCheckOptions;
int index = opts.Add();
ErrorCheckOption opt = opts[index];
//Disable the numbers stored as text option
opt.SetErrorCheck(ErrorCheckType.TextNumber, false);
//Set the range
opt.AddRange(CellArea.CreateCellArea(0, 0, 1000, 50));
//Save the Excel file
workbook.Save(dataDir + "out_test.out.xlsx");
//ExEnd:1
}
private static void RemoveSuperfluousErrorWarnings(Worksheet sheet)
{
ErrorCheckOptionCollection opts = sheet.ErrorCheckOptions;
int index = opts.Add();
ErrorCheckOption opt = opts[index];
opt.SetErrorCheck(ErrorCheckType.TextDate, false);
opt.SetErrorCheck(ErrorCheckType.TextNumber, false);
opt.AddRange(CellArea.CreateCellArea(0, 0, sheet.Cells.MaxRow + 1, sheet.Cells.MaxColumn + 1));
}
public static void Main()
{
// The path to the documents directory.
string dataDir = Path.GetFullPath("../../../Data/");
//Create a workbook and opening a template spreadsheet
Workbook workbook = new Workbook(dataDir + "Book1.xlsx");
//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Instantiate the error checking options
ErrorCheckOptionCollection opts = sheet.ErrorCheckOptions;
int index = opts.Add();
ErrorCheckOption opt = opts[index];
//Disable the numbers stored as text option
opt.SetErrorCheck(ErrorCheckType.TextNumber, false);
//Set the range
opt.AddRange(CellArea.CreateCellArea(0, 0, 1000, 50));
//Save the Excel file
workbook.Save(dataDir + "out_test.xlsx");
}
