| public CloneSheet ( int sheetNum ) : ISheet | ||
| sheetNum | int | |
| Результат | ISheet | |
public void Test57165()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("57171_57163_57165.xlsx");
try
{
RemoveAllSheetsBut(3, wb);
wb.CloneSheet(0); // Throws exception here
wb.SetSheetName(1, "New Sheet");
//saveWorkbook(wb, fileName);
XSSFWorkbook wbBack = XSSFTestDataSamples.WriteOutAndReadBack(wb) as XSSFWorkbook;
try
{
}
finally
{
wbBack.Close();
}
}
finally
{
wb.Close();
}
}
static void Main(string[] args)
{
IWorkbook wb = new XSSFWorkbook();
wb.CreateSheet("new sheet");
wb.CreateSheet("second sheet");
ISheet cloneSheet = wb.CloneSheet(0);
FileStream sw = File.Create("newWorksheet.xls");
wb.Write(sw);
sw.Close();
}
public void TestClone()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("WithDrawing.xlsx");
XSSFSheet sheet1 = wb.GetSheetAt(0) as XSSFSheet;
XSSFSheet sheet2 = wb.CloneSheet(0) as XSSFSheet;
//the source sheet has one relationship and it is XSSFDrawing
List <POIXMLDocumentPart> rels1 = sheet1.GetRelations();
Assert.AreEqual(1, rels1.Count);
Assert.IsTrue(rels1[(0)] is XSSFDrawing);
List <POIXMLDocumentPart> rels2 = sheet2.GetRelations();
Assert.AreEqual(1, rels2.Count);
Assert.IsTrue(rels2[(0)] is XSSFDrawing);
XSSFDrawing drawing1 = (XSSFDrawing)rels1[0];
XSSFDrawing drawing2 = (XSSFDrawing)rels2[0];
Assert.AreNotSame(drawing1, drawing2); // Drawing2 is a clone of Drawing1
List <XSSFShape> shapes1 = drawing1.GetShapes();
List <XSSFShape> shapes2 = drawing2.GetShapes();
Assert.AreEqual(shapes1.Count, shapes2.Count);
for (int i = 0; i < shapes1.Count; i++)
{
XSSFShape sh1 = (XSSFShape)shapes1[(i)];
XSSFShape sh2 = (XSSFShape)shapes2[i];
Assert.IsTrue(sh1.GetType() == sh2.GetType());
Assert.AreEqual(sh1.GetShapeProperties().ToString(), sh2.GetShapeProperties().ToString());
}
checkRewrite(wb);
wb.Close();
}
