作成日: 2018/05/23 最終更新日: 2018/05/23
文書種別
使用方法
詳細
罫線を含めて行をコピーするには、セル単位でValueやStyleを取得して、コピー先のセルに設定する必要がございます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Dim wb As C1XLBook = New C1XLBook
wb.Load(・・・)
Dim xb As C1XLBook = New C1XLBook
Dim source As XLSheet = wb.Sheets(0)
Dim dest As XLSheet = xb.Sheets(0)
Dim row As Integer, col As Integer
For row = 0 To source.Rows.Count - 1
For col = 0 To source.Columns.Count - 1
dest(row, col).Value = source(row, col).Value
dest(row, col).Style = source(row, col).Style
Next col
Next row
xb.Save(・・・)
wb.Load(・・・)
Dim xb As C1XLBook = New C1XLBook
Dim source As XLSheet = wb.Sheets(0)
Dim dest As XLSheet = xb.Sheets(0)
Dim row As Integer, col As Integer
For row = 0 To source.Rows.Count - 1
For col = 0 To source.Columns.Count - 1
dest(row, col).Value = source(row, col).Value
dest(row, col).Style = source(row, col).Style
Next col
Next row
xb.Save(・・・)
◎サンプルコード(C#)
C1XLBook wb = new C1XLBook();
wb.Load(・・・);
C1XLBook xb = new C1XLBook();
XLSheet source = wb.Sheets[0];
XLSheet dest = xb.Sheets[0];
for (int row = 0; row <= source.Rows.Count - 1; row++)
{
for (int col = 0; col <= source.Columns.Count - 1; col++)
{
dest[row, col].Value = source[row, col].Value;
dest[row, col].Style = source[row, col].Style;
}
}
xb.Save(・・・);
wb.Load(・・・);
C1XLBook xb = new C1XLBook();
XLSheet source = wb.Sheets[0];
XLSheet dest = xb.Sheets[0];
for (int row = 0; row <= source.Rows.Count - 1; row++)
{
for (int col = 0; col <= source.Columns.Count - 1; col++)
{
dest[row, col].Value = source[row, col].Value;
dest[row, col].Style = source[row, col].Style;
}
}
xb.Save(・・・);
旧文書番号
82729