public static void Main(string[] args)
{
WriteJavaDoc();
HSSFWorkbook wb = new HSSFWorkbook();
SheetWriter sw = new SheetWriter(wb);
NumberToTextConversionExamples.ExampleConversion[] exampleValues = NumberToTextConversionExamples.GetExampleConversions();
for (int i = 0; i < exampleValues.Length; i++)
{
TestCases.SS.Util.NumberToTextConversionExamples.ExampleConversion example = exampleValues[i];
sw.AddTestRow(example.RawDoubleBits, example.ExcelRendering);
}
MemoryStream baos = new MemoryStream();
wb.Write(baos);
byte[] fileContent = baos.ToArray();
ReplaceNaNs(fileContent, sw.GetReplacementNaNs());
FileInfo outputFile = new FileInfo("ExcelNumberRendering.xls");
FileStream os = File.OpenWrite(outputFile.FullName);
os.Write(fileContent, 0, fileContent.Length);
os.Close();
Console.WriteLine("Finished writing '" + outputFile.FullName + "'");
}
public static void Main(String[] args)
{
WriteJavaDoc();
HSSFWorkbook wb = new HSSFWorkbook();
SheetWriter sw = new SheetWriter(wb);
NumberToTextConversionExamples.ExampleConversion[] exampleValues = NumberToTextConversionExamples.GetExampleConversions();
for (int i = 0; i < exampleValues.Length; i++)
{
TestCases.SS.Util.NumberToTextConversionExamples.ExampleConversion example = exampleValues[i];
sw.AddTestRow(example.RawDoubleBits, example.ExcelRendering);
}
MemoryStream baos = new MemoryStream();
wb.Write(baos);
byte[] fileContent = baos.ToArray();
ReplaceNaNs(fileContent, sw.GetReplacementNaNs());
FileInfo outputFile = new FileInfo("ExcelNumberRendering.xls");
FileStream os = File.OpenWrite(outputFile.FullName);
os.Write(fileContent, 0, fileContent.Length);
os.Close();
Console.WriteLine("Finished writing '" + outputFile.FullName + "'");
}
public void Evaluate(TextReader input, TextWriter output)
{
var reader = new SheetReader(input);
var sheet = Sheet.GenerateSheet(reader);
var evaluator = new SheetEvaluator(sheet);
evaluator.EvaluateSheet();
var writer = new SheetWriter(output);
writer.WriteSheet(sheet);
}
public static void Main(String[] args)
{
IWorkbook wb = new HSSFWorkbook();
SheetWriter sw = new SheetWriter(wb);
ComparisonExample[] ces = NumberComparisonExamples.GetComparisonExamples();
for (int i = 0; i < ces.Length; i++)
{
ComparisonExample ce = ces[i];
sw.AddTestRow(ce.GetA(), ce.GetB(), ce.GetExpectedResult());
}
FileInfo outputFile = new FileInfo("ExcelNumberCompare.xls");
FileStream os = File.OpenWrite(outputFile.FullName);
wb.Write(os);
os.Close();
Console.WriteLine("Finished writing '" + outputFile.FullName + "'");
}
public static void Main(String[] args)
{
IWorkbook wb = new HSSFWorkbook();
SheetWriter sw = new SheetWriter(wb);
ComparisonExample[] ces = NumberComparisonExamples.GetComparisonExamples();
for (int i = 0; i < ces.Length; i++)
{
ComparisonExample ce = ces[i];
sw.AddTestRow(ce.GetA(), ce.GetB(), ce.GetExpectedResult());
}
FileInfo outputFile = new FileInfo("ExcelNumberCompare.xls");
FileStream os = File.OpenWrite(outputFile.FullName);
wb.Write(os);
os.Close();
Console.WriteLine("Finished writing '" + outputFile.FullName + "'");
}
