FarPoint.Win.Serializer.LoadObjectXml复制SheetView副本时，提示调用的目标时发异常

收藏

复制SheetView,按照：http://blog.gcpowertools.com.cn/post/如何复制SheetView对象-.aspx：public FarPoint.Win.Spread.SheetView CopySheet(FarPoint.Win.Spread.SheetView sheet) { FarPoint.Win.Spread.SheetView newSheet = null; if (sheet != null) { newSheet = FarPoint.Win.Serializer.LoadObjectXml(typeof(SheetView), FarPoint.Win.Serializer.GetObjectXml(sheet, "CopySheet"), "CopySheet") as SheetView; newSheet.SheetName = "NewSheet"; } return newSheet; }-------------------------------------------------当其中某个单元格有背景时复制出错（出错提示在上传图片中）：TextCellType cellType = new TextCellType();cellType.BackgroundImage = new Picture(Image.FromFile(@"c:\xx.jpg"), FarPoint.Win.RenderStyle.Stretch, System.Drawing.Color.Empty, 0, FarPoint.Win.HorizontalAlignment.Left, FarPoint.Win.VerticalAlignment.Top);
this.fpSpread_Sheet1.Cells[0,0].CellType = cellType;

burns · burns

单元格设置背景：http://gcdn.gcpowertools.com.cn/ ... =%B1%B3%BE%B0%CD%BC

burns · burns

且导出Excel表时出现GDI+错误。

dexteryao · dexteryao

您好，我测试您的代码没有出现异常，可否提供一个Demo；

var sheet = fpSpread1.ActiveSheet;
TextCellType cellType = new TextCellType();
cellType.BackgroundImage = new FarPoint.Win.Picture(Image.FromFile(@"googlelogo_color_120x44dp.png"),
FarPoint.Win.RenderStyle.Stretch, System.Drawing.Color.Empty, 0, FarPoint.Win.HorizontalAlignment.Left, FarPoint.Win.VerticalAlignment.Top);
sheet.Cells[0, 0].CellType = cellType;
FarPoint.Win.Spread.SheetView newSheet = null;
newSheet = FarPoint.Win.Serializer.LoadObjectXml(typeof(SheetView), FarPoint.Win.Serializer.GetObjectXml(sheet, "CopySheet"), "CopySheet") as SheetView;
newSheet.SheetName = "NewSheet";
fpSpread1.Sheets.Add(newSheet);

复制代码

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

[已处理] FarPoint.Win.Serializer.LoadObjectXml复制SheetView副本时，提示调用的目标时发异常

3 个回复

活字格认证

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章