1金币
本帖最后由 bingdaoice 于 2019-9-17 10:28 编辑
fpSpread1.Open(AppDomain.CurrentDomain.BaseDirectory + "129.xml");
FarPoint.Win.Spread.FpSpread Spread_Excel = new FarPoint.Win.Spread.FpSpread();
Spread_Excel.Open(AppDomain.CurrentDomain.BaseDirectory + "128.xml");
Spread_Excel.ActiveSheet.Save("temp.xml", false);
var newSheet = new FarPoint.Win.Spread.SheetView();
newSheet.Open("temp.xml");
newSheet.SheetName = "NewSheet";
fpSpread1.Sheets.Add(newSheet);
fpSpread1.Sheets[1].AddSelection(0, 0, newSheet.RowCount, newSheet.ColumnCount);//在表单中添加一个选择
fpSpread1.Sheets[1].ClipboardCopy(fpSpread1.Sheets[1].GetSelection(0));//复制选择的项目到剪贴板
fpSpread1.Sheets[0].AddRows(fpSpread1.Sheets[0].RowCount, fpSpread1.Sheets[1].RowCount);//添加一行或多行到表单的数据模型
fpSpread1.Sheets[0].SetActiveCell(fpSpread1.Sheets[0].RowCount - fpSpread1.Sheets[1].RowCount, 0);
fpSpread1.ActiveSheet.ClipboardPaste(FarPoint.Win.Spread.ClipboardPasteOptions.All);
int j = 0;
for (int i = fpSpread1.Sheets[0].RowCount - fpSpread1.Sheets[1].RowCount; i < fpSpread1.Sheets[0].RowCount; i++)
{
fpSpread1.ActiveSheet.Rows.Height = newSheet.Rows[j].Height;
j++;
}
fpSpread1.Sheets.Remove(newSheet);
Spread_Excel.Sheets[0].SetRowPageBreak(fpSpread1.Sheets[0].RowCount + 1, true);//插入分页符
这是以前写的合并方式(不知道现在有没有新的合并方式)
错误问题1:合并时提示,所请求的剪贴板操作失败。
错误问题2:无错误提示,也合并失败。下面没有东西。(在NewSheet里面有内容)
|
|