目前我有能打印一个ListView到Excel中的代码:
Excel.Application Ex = new Excel.Application();
Ex.Application.Workbooks.Add(true);
Ex.Visible = true;
ListView Lv1 = Form_Main_ListView1;
for (int i = 1; i <= Lv.Columns.Count; i++)
{
Ex.Rows.Cells[1, i] = Lv.Columns[i - 1].Text;
}
for (int i = 2; i <= Lv.Items.Count + 1; i++)
{
for (int j = 1; j <= Lv.Columns.Count; j++)
{
Ex.Rows.Cells[i, j] = "" + Lv.Items[i - 2].SubItems[j - 1].Text;
}
}
for (int i = 1; i <= Lv.Columns.Count; i++)
{
Ex.Rows.Cells[1, i] = Lv.Columns[i - 1].Text;
}
for (int i = 2; i <= Lv.Items.Count + 1; i++)
{
for (int j = 1; j <= Lv.Columns.Count; j++)
{
Ex.Rows.Cells[i, j] = "" + Lv.Items[i - 2].SubItems[j - 1].Text;
}
}现在我想在同一个Excel的WorkBook下新建一个Sheet2,把Form_Main_ListView2的内容写进去,我该怎么写?
Excel.Application Ex = new Excel.Application();
Ex.Application.Workbooks.Add(true);
Ex.Visible = true;
ListView Lv1 = Form_Main_ListView1;
for (int i = 1; i <= Lv.Columns.Count; i++)
{
Ex.Rows.Cells[1, i] = Lv.Columns[i - 1].Text;
}
for (int i = 2; i <= Lv.Items.Count + 1; i++)
{
for (int j = 1; j <= Lv.Columns.Count; j++)
{
Ex.Rows.Cells[i, j] = "" + Lv.Items[i - 2].SubItems[j - 1].Text;
}
}
for (int i = 1; i <= Lv.Columns.Count; i++)
{
Ex.Rows.Cells[1, i] = Lv.Columns[i - 1].Text;
}
for (int i = 2; i <= Lv.Items.Count + 1; i++)
{
for (int j = 1; j <= Lv.Columns.Count; j++)
{
Ex.Rows.Cells[i, j] = "" + Lv.Items[i - 2].SubItems[j - 1].Text;
}
}现在我想在同一个Excel的WorkBook下新建一个Sheet2,把Form_Main_ListView2的内容写进去,我该怎么写?
就是想求关于Excel.Steel相关的操作方法,把2个表导入同一个Excel并且分别为Steel1和Steel2
应该和我现在这个代码差不多,只不过多了几个Excel.Steel.XXXX的操作而已
{
workbook.Sheets.Add(obj, (Excel.Worksheet)workbook.Sheets[workbook.Sheets.Count], obj, obj);
((Excel.Worksheet)workbook.Sheets[workbook.Sheets.Count]).Name = Name;
}