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();
}
}