Spread的sheet之间复制数据的问题

收藏

Spread 中的一个sheet中已有数据了，想新建一个sheet 内容就是复制前一个sheet的数据，怎么实现？谢谢！

goodboy · goodboy

两个sheet在同一个spread中.

dexteryao · dexteryao

通过导入导出xml的方式复制

private void button1_Click(object sender, EventArgs e)
{
FarPoint.Win.Spread.SheetView s = new FarPoint.Win.Spread.SheetView();
s.Cells[0, 0].Text = "test";
FarPoint.Win.Spread.DrawingSpace.FourWayArrowShape sh = new FarPoint.Win.Spread.DrawingSpace.FourWayArrowShape();
sh.Name = "Arrow";
s.AddShape(sh);
fpSpread1.Sheets.Add(CopySheet(s));
}
public FarPoint.Win.Spread.SheetView CopySheet(FarPoint.Win.Spread.SheetView sheet)
{
FarPoint.Win.Spread.SheetView newSheet = null;
if (sheet != null)
{
newSheet = (FarPoint.Win.Spread.SheetView)FarPoint.Win.Serializer.LoadObjectXml(typeof(FarPoint.Win.Spread.SheetView), FarPoint.Win.Serializer.GetObjectXml(sheet, "CopySheet"), "CopySheet");
}
return newSheet;
}

复制代码

goodboy · goodboy

谢谢，试一下！

dexteryao · dexteryao

		自动登录	找回密码
密码			立即注册

[已处理] Spread的sheet之间复制数据的问题