private void WriteCellXml(ExcelValueObject val, int cellIndex, string extraAttributes) { string[] DefaultStyles = { "", "s21", "s22", "s23", "s24", "s25" }; string[] DefaultFormats = { "String", "Number", "DateTime" }; StringBuilder sb = new StringBuilder(); sb.Append("<Cell"); sb.Append(extraAttributes); if (cellIndex > 0) { sb.Append(" ss:Index=\"" + cellIndex.ToString() + "\""); } if (val.MergeAcrossCount > 0) { sb.Append(" ss:MergeAcross=\"" + val.MergeAcrossCount.ToString() + "\""); } if (val.MergeDownCount > 0) { sb.Append(" ss:MergeDown=\"" + val.MergeDownCount.ToString() + "\""); } string style; if (val.Style == ExcelCellStyle.Custom) { style = val.CustomStyle; } else { style = DefaultStyles[(int)val.Style]; } if (!String.IsNullOrEmpty(style)) { sb.Append(" ss:StyleID=\"" + style + "\""); } sb.Append("><Data ss:Type=\""); sb.Append(DefaultFormats[(int)val.Format]); sb.Append("\">"); sb.Append(EscapeXmlString(val.Text)); sb.Append("</Data>"); if (_title) { sb.Append("<NamedCell ss:Name=\"Print_Titles\"/>"); } sb.Append("</Cell>"); _streamWriter.WriteLine(sb.ToString()); }
public void WriteRow(int rowNumber, ExcelValueObject[] values) { OpenRow(rowNumber); foreach (ExcelValueObject val in values) { WriteCell(val); } CloseRow(); }
public void WriteCell(ExcelValueObject val, int cellIndex) { WriteCellXml(val, cellIndex, String.Empty); }
public void WriteCellWithFormula(ExcelValueObject val, string Formula) { WriteCellXml(val, -1, " ss:Formula=\"" + Formula + "\""); }
public void WriteCell(ExcelValueObject val) { WriteCell(val, -1); }