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 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 + "'");
}