/// <summary>
/// Creates a stub Workbook from the supplied records,
/// suitable for use with the {@link HSSFFormulaParser}
/// </summary>
/// <param name="externs">The ExternSheetRecords in your file</param>
/// <param name="bounds">The BoundSheetRecords in your file</param>
/// <param name="sst">TThe SSTRecord in your file.</param>
/// <returns>A stub Workbook suitable for use with HSSFFormulaParser</returns>
public static Workbook CreateStubWorkbook(ExternSheetRecord[] externs,
BoundSheetRecord[] bounds, SSTRecord sst)
{
List <Record> wbRecords = new List <Record>();
// Core Workbook records go first
if (bounds != null)
{
for (int i = 0; i < bounds.Length; i++)
{
wbRecords.Add(bounds[i]);
}
}
if (sst != null)
{
wbRecords.Add(sst);
}
// Now we can have the ExternSheetRecords,
// preceded by a SupBookRecord
if (externs != null)
{
wbRecords.Add(SupBookRecord.CreateInternalReferences(
(short)externs.Length));
for (int i = 0; i < externs.Length; i++)
{
wbRecords.Add(externs[i]);
}
}
// Finally we need an EoF record
wbRecords.Add(EOFRecord.instance);
return(Workbook.CreateWorkbook(wbRecords));
}
public void CreateExistedFileFail()
{
Workbook wb = new Workbook();
wb.CreateWorkbook();
Worksheet ws = wb.CreateWorksheet("SomeSheet");
wb.SaveAs(@"\\192.168.16.50\bazaotd\Давыдов Д.В\CreateTest.xlsx");
wb.Quit();
}
public void CreateFileTest()
{
Workbook wb = new Workbook();
try
{
wb.CreateWorkbook();
Worksheet ws = wb.CreateWorksheet("SomeSheet");
wb.SaveAs(@"\\192.168.16.50\bazaotd\Давыдов Д.В\CreateTest.xlsx");
}
catch (FileExistsException e)
{
}
finally
{
wb.Quit();
}
}