您好,有两个方案一种是新建一个sheet,然后复制内容过去。参考下面代码,还有个方案是save导出这个sheet的xml,然后新sheet用open导入
- Random r = new Random();
- int i, j;
- DialogResult dlg;
- for (i = 0; i <= 3; i++)
- {
- for (j = 0; j <= 3; j++)
- {
- fpSpread1.ActiveSheet.SetValue(i, j, r.Next() -100000);
- }
- }
- dlg = MessageBox.Show("Do you want to copy the data to the clipboard?", "ClipboardCopy", MessageBoxButtons.YesNo);
- if (dlg == DialogResult.Yes)
- {
- fpSpread1.ActiveSheet.AddSelection(0, 0, 3, 3);
- fpSpread1.ActiveSheet.ClipboardCopy();
- }
- dlg = MessageBox.Show("Do you want to paste the data from the clipboard? If yes, let's clear the data first.", "Clear", MessageBoxButtons.YesNo);
- if (dlg == DialogResult.Yes)
- {
- fpSpread1.ActiveSheet.Cells[0, 0, 5, 5].Text = "";
- }
- dlg = MessageBox.Show("Now we're ready to paste!!", "ClipboardPaste", MessageBoxButtons.YesNo);
- if (dlg == DialogResult.Yes)
- {
- fpSpread1.ActiveSheet.ClipboardPaste();
- }
复制代码 |