writerow

来源：互联网发布：淘宝男鞋店铺名称大全编辑：程序博客网时间：2024/06/05 11:06

if (Convert.ToInt32(range.Interior.ColorIndex) == 46)
                {
                    range.Interior.Color = System.Drawing.Color.White.ToArgb();
                }

public void ExportReport(string templateFileName, string targetFileName)
        {
            //生成文件
            int currentRowNumber = 12;
            int v = 0;
            int fpSpreadrowCount=0;
            //int progressBar1count = 0;
            using (ExcelExporter exporter = ExcelExporter.CreateFrom(templateFileName, targetFileName))
            {



                foreach (FarPoint.Win.Spread.Row row in fpSpread1.Sheets[0].Rows)
                {
                    if (fpSpread1.Sheets[0].Cells[fpSpreadrowCount, 0].Value != null)
                    {
                        fpSpreadrowCount++;
                    }
                }

                progressBar1.Visible = true;
                progressBar1.Minimum = 0;
                progressBar1.Maximum = fpSpreadrowCount*2;
                progressBar1.BackColor = Color.Green;

                foreach (FarPoint.Win.Spread.Row row in fpSpread1.Sheets[0].Rows)
                {
                    int rowIndex = row.Index; //取得row行号
                    if (fpSpread1.Sheets[0].Cells[rowIndex, 0].Value == null)
                    {
                        break;
                    }   //如果循环到第n行时，没有值，则跳出foreach循环
                    string rowCellString = "";
                    for (int n = 1; n < 96; n++)
                    {
                        rowCellString = rowCellString + CellsValue(fpSpread1.Sheets[0].Cells[rowIndex, n].Value) + "我$";
                        //此处不应用逗号（常用的标点符号）来作为分隔符号，因为在cell里的值可能存在逗号，这样分隔后数据将出现多余，出现错误
                    }

                    string[] rowStringArray = System.Text.RegularExpressions.Regex.Split(rowCellString, "我[$]");
                    exporter.WriteRow(1, currentRowNumber, 3, rowStringArray);
                    progressBar1.Value++;
                    for (int columnNumber = 20; columnNumber <= 95; columnNumber++)//有亮绿色单元格的列（从第22列开始有亮绿色的单元格）
                    {
                        //exporter.WriteColor(1, currentRowNumber, columnNumber);
                        if (fpSpread1.Sheets[0].Cells[rowIndex, columnNumber].BackColor.Name == "LightGreen")
                        {
                            exporter.WriteColor(1, currentRowNumber, columnNumber + 2);

                        }
                    }
                    currentRowNumber++;
                    progressBar1.Value++;
                }
                fpSpreadrowCount = 0;
                progressBar1.Value = 0;
                exporter.SelectCell(1, 1, 1);
                exporter.Save();
                exporter.Close();
            }
        }