110,538
社区成员
发帖
与我相关
我的任务
分享
for (int row = 0; row <= dataGridView_reportResult.RowCount - 1; row++)
{
try
{
rowNumberString = Convert.ToString(row + headContentCount + 2);
objExcel.Cells[row + headContentCount + 2, 1] = dataGridView_reportResult.Rows[row].Cells[1].Value.ToString().Trim(); //DateOnly
objExcel.Cells[row + headContentCount + 2, 5] = dataGridView_reportResult.Rows[row].Cells[2].Value.ToString().Trim(); //TimeOnly
objExcel.Cells[row + headContentCount + 2, 6] = dataGridView_reportResult.Rows[row].Cells[3].Value.ToString().Trim(); //Location
objExcel.Cells[row + headContentCount + 2, 8] = dataGridView_reportResult.Rows[row].Cells[4].Value.ToString().Trim(); //PPDC
}
}
objWorkSheet.get_Range("A" + Convert.ToString(row + headContentCount + 2), "A" + 1).Interior.Color = 255;
代表第Convert.ToString(row + headContentCount + 2)行第一列的颜色是红色
//write data to EXCEL step by step
for (int row = 0; row <= dataGridView_reportResult.RowCount - 1; row++)
{
progressBar_export.PerformStep();
displayColumnCount = 1;
try
{
rowNumberString = Convert.ToString(row + headContentCount + 2);
objWorkSheet.get_Range("A" + rowNumberString, "D" + rowNumberString).Merge(true);
objWorkSheet.get_Range("F" + rowNumberString, "G" + rowNumberString).Merge(true);
objWorkSheet.get_Range("I" + rowNumberString, "K" + rowNumberString).Merge(true);
objWorkSheet.get_Range("L" + rowNumberString, "N" + rowNumberString).Merge(true);
objWorkSheet.get_Range("R" + rowNumberString, "S" + rowNumberString).Merge(true);
objExcel.Cells[row + headContentCount + 2, 1] = dataGridView_reportResult.Rows[row].Cells[1].Value.ToString().Trim(); //DateOnly
objExcel.Cells[row + headContentCount + 2, 5] = dataGridView_reportResult.Rows[row].Cells[2].Value.ToString().Trim(); //TimeOnly
objExcel.Cells[row + headContentCount + 2, 6] = dataGridView_reportResult.Rows[row].Cells[3].Value.ToString().Trim(); //Location
objExcel.Cells[row + headContentCount + 2, 8] = dataGridView_reportResult.Rows[row].Cells[4].Value.ToString().Trim(); //PPDC
objExcel.Cells[row + headContentCount + 2, 9] = dataGridView_reportResult.Rows[row].Cells[5].Value.ToString().Trim(); //PDUorRDU
objExcel.Cells[row + headContentCount + 2, 12] = dataGridView_reportResult.Rows[row].Cells[6].Value.ToString().Trim(); //RackNo
objExcel.Cells[row + headContentCount + 2, 15] = dataGridView_reportResult.Rows[row].Cells[7].Value.ToString().Trim(); //A_Root
objExcel.Cells[row + headContentCount + 2, 16] = dataGridView_reportResult.Rows[row].Cells[8].Value.ToString().Trim(); //B_Root
objExcel.Cells[row + headContentCount + 2, 17] = dataGridView_reportResult.Rows[row].Cells[9].Value.ToString().Trim(); //Total
objExcel.Cells[row + headContentCount + 2, 18] = dataGridView_reportResult.Rows[row].Cells[10].Value.ToString().Trim(); //Phases1
objExcel.Cells[row + headContentCount + 2, 20] = dataGridView_reportResult.Rows[row].Cells[11].Value.ToString().Trim(); //Phases2
objExcel.Cells[row + headContentCount + 2, 21] = dataGridView_reportResult.Rows[row].Cells[12].Value.ToString().Trim(); //StatusA
objExcel.Cells[row + headContentCount + 2, 22] = dataGridView_reportResult.Rows[row].Cells[13].Value.ToString().Trim(); //StatusB
objExcel.Cells[row + headContentCount + 2, 23] = dataGridView_reportResult.Rows[row].Cells[14].Value.ToString().Trim(); //Latitude
objExcel.Cells[row + headContentCount + 2, 24] = dataGridView_reportResult.Rows[row].Cells[15].Value.ToString().Trim(); //Usage
objExcel.Cells[row + headContentCount + 2, 25] = dataGridView_reportResult.Rows[row].Cells[16].Value.ToString().Trim(); //Agent
objExcel.Cells[row + headContentCount + 2, 26] = dataGridView_reportResult.Rows[row].Cells[17].Value.ToString().Trim(); //Power
objExcel.Cells[row + headContentCount + 2, 27] = dataGridView_reportResult.Rows[row].Cells[18].Value.ToString().Trim(); //Type
objWorkSheet.get_Range("A" + rowNumberString, "AA" + rowNumberString).Borders.LineStyle = 1;
objWorkSheet.get_Range("A" + rowNumberString, "AA" + rowNumberString).Font.Size = 10;
objWorkSheet.get_Range("A" + rowNumberString, "AA" + rowNumberString).RowHeight = 12.75;
}
catch (Exception ex)
{
}
}
if (row % 2 == 1)
{
objExcel.Cells[row + headContentCount + 2, 1] = dataGridView_reportResult.Rows[row].Cells[1].Value.ToString().Trim(); //DateOnly
objWorkSheet.get_Range("A" + Convert.ToString(row + headContentCount + 2), "A" + 1).Interior.Color = 255;
objExcel.Cells[row + headContentCount + 2, 5] = dataGridView_reportResult.Rows[row].Cells[2].Value.ToString().Trim(); //TimeOnly
objWorkSheet.get_Range("F" + Convert.ToString(row + headContentCount + 5), "F" + 5).Interior.Color = 255;
objExcel.Cells[row + headContentCount + 2, 6] = dataGridView_reportResult.Rows[row].Cells[3].Value.ToString().Trim(); //Location
objWorkSheet.get_Range("I" + Convert.ToString(row + headContentCount + 6), "I" + 6).Interior.Color = 255;
objExcel.Cells[row + headContentCount + 2, 8] = dataGridView_reportResult.Rows[row].Cells[4].Value.ToString().Trim(); //PPDC
objWorkSheet.get_Range("L" + Convert.ToString(row + headContentCount + 8), "L" + 8).Interior.Color = 255;
}
else
{
}
objWorkSheet.get_Range("A1", "A1").Interior.Color = 255;
objWorkSheet.get_Range("B1", "B1").Interior.Color = 255;