private void newNToolStripMenuItem_Click(object sender, EventArgs e) { //test create xls file string file = "C:\\newdoc.xls"; Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("First Sheet"); worksheet.Cells[0, 1] = new Cell((short)1); worksheet.Cells[2, 0] = new Cell(2.8); worksheet.Cells[3, 3] = new Cell((decimal)3.45); worksheet.Cells[2, 2] = new Cell("Text string"); worksheet.Cells[2, 4] = new Cell("Second string"); worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00"); worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD"); worksheet.Cells.ColumnWidth[0, 1] = 3000; //Picture pic = new Picture(); //pic.Image = Excel.Image.FromFile("C:\\DelBreakpoint.png"); //pic.TopLeftCorner = new CellAnchor(5, 1, 0, 0); //pic.BottomRightCorner = new CellAnchor(12, 5, 592, 243); //worksheet.AddPicture(pic); workbook.Worksheets.Add(worksheet); workbook.Save(file); //open created file doc = CompoundDocument.Open(file); IsOpened = true; PopulateTreeview(file); }
public void WriteLongTextTest() { int longTextLength = 50000; StringBuilder builder = new StringBuilder(longTextLength); for (int i = 0; i < longTextLength; i++) builder.Append('A'); string longText = builder.ToString(); string tempFilePath = Path.GetTempFileName(); { Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Test"); worksheet.Cells[0, 0] = new Cell(longText); workbook.Worksheets.Add(worksheet); workbook.Save(tempFilePath); } { Workbook workbook = Workbook.Load(tempFilePath); Assert.AreEqual(longText, workbook.Worksheets[0].Cells[0, 0].Value); } }
public static void ExportToExcel(DataSet dataSet, string outputPath) { Workbook workbook = new Workbook(); foreach (DataTable dt in dataSet.Tables) { Worksheet worksheet = new Worksheet(dt.TableName); for (int i = 0; i < dt.Columns.Count; i++) { // Add column header worksheet.Cells[0, i] = new Cell(dt.Columns[i].ColumnName); // Populate row data for (int j = 0; j < dt.Rows.Count; j++) { if (dt.Rows[j][i] == DBNull.Value) worksheet.Cells[j + 1, i] = new Cell(string.Empty); else if (dt.Columns[i].DataType == typeof(DateTime)) { worksheet.Cells[j + 1, i] = new Cell(dt.Rows[j][i], new CellFormat(CellFormatType.Date, "DD.MM.YYYY")); } else worksheet.Cells[j + 1, i] = new Cell(dt.Rows[j][i]); } } workbook.Worksheets.Add(worksheet); } workbook.Save(outputPath); }
public Worksheet EnteteSRFLigne2(Worksheet worksheet,string NomSoc,string Date1,string Date2,string CodeSoc,bool PeNormal,bool Bonus,string DatePe) { worksheet.Cells[1, 0] = new Cell("D0"); worksheet.Cells[1, 1] = new Cell("UTF8"); worksheet.Cells[1, 2] = new Cell((DateTime.Now.ToString().Substring(0,10))); string HeureMin = ExtraireHeure(DateTime.Now.Hour.ToString(),DateTime.Now.Minute.ToString(),DateTime.Now.Second.ToString()); worksheet.Cells[1, 3] = new Cell(HeureMin); worksheet.Cells[1, 4] = new Cell("SRF"); worksheet.Cells[1, 5] = new Cell("M2.0.2.0"); worksheet.Cells[1, 6] = new Cell("F1.0.0"); worksheet.Cells[1, 7] = new Cell("ABC"); worksheet.Cells[1, 8] = new Cell("TN"); worksheet.Cells[1, 9] = new Cell(CodeSoc); worksheet.Cells[1, 10] = new Cell(NomSoc); worksheet.Cells[1, 11] = new Cell("TN"); worksheet.Cells[1, 12] = new Cell("TND"); worksheet.Cells[1, 13] = new Cell(DatePe); worksheet.Cells[1, 14] = new Cell(Date1); worksheet.Cells[1, 15] = new Cell(Date2); worksheet.Cells[1, 16] = new Cell(1); int leMois = int.Parse(Date1.Substring(3, 2)); string MoisC = service.NomDuMoisEnglish(leMois); string Year = Date1.Substring(6,4); worksheet.Cells[1, 17] = new Cell("payroll "+MoisC+" "+Year); string TypePay = TypedePayroll(PeNormal, Bonus); worksheet.Cells[1, 18] = new Cell(TypePay); worksheet.Cells[1, 19] = new Cell(0); return worksheet; }
//private DocumentService documentService =new DocumentService(); public static string FileGen(string fileName,List<List<string>> sheet ) { if (!Directory.Exists(Constants.ImportTempFolder)) Directory.CreateDirectory(Constants.ImportTempFolder); string file = Constants.ImportTempFolder+fileName; if (File.Exists(file)) { try { File.Delete(file); } catch (Exception) { return null; } } Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("First Sheet"); for (int row=0; row<sheet.Count;row++) { for (var col = 0; col < sheet[row].Count;col++ ) { worksheet.Cells[row, col] = new Cell(sheet[row][col]); } } workbook.Worksheets.Add(worksheet); workbook.Save(file); return file; }
public Worksheet EnteteOPR8Ligne1(Worksheet worksheet,string NomSoc) { worksheet.Cells[0, 0] = new Cell("Client"); worksheet.Cells[0, 1] = new Cell(NomSoc); return worksheet; }
public Worksheet EnteteOPR8Ligne2(Worksheet worksheet) { worksheet.Cells[1, 0] = new Cell("OPR 08"); worksheet.Cells[1, 1] = new Cell("Comparatif Payement par Virement"); return worksheet; }
public static void excel_batch_template(WSProject p) { string file = @"C:\Users\WindSim\Desktop\Francesco\WindSim_Projects\MoninObukhov\batch.xls"; Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Batch Data"); // this cycle add some null cells because when on Windows 7 Office need at least 6000byte files. //---------------------------------------------- for (var k = 0; k < 200; k++) worksheet.Cells[k, 0] = new Cell(null); // --------------------------------------------- XmlReader reader = XmlReader.Create(p.file.FullName); int i = 0; while (reader.Read()) { if (reader.NodeType == XmlNodeType.EndElement) { worksheet.Cells[i, 0] = new Cell(reader.Name); if (reader.Read()) { worksheet.Cells[i, 1] = new Cell(reader.Value.Trim()); } i++; } } workbook.Worksheets.Add(worksheet); workbook.Save(file); }
public Worksheet EnteteOPR17Ligne2(Worksheet worksheet) { worksheet.Cells[1, 0] = new Cell("OPR 17"); worksheet.Cells[1, 1] = new Cell("Payroll summary"); return worksheet; }
public Worksheet EnteteOPR11Ligne2(Worksheet worksheet) { worksheet.Cells[1, 0] = new Cell("OPR 11"); worksheet.Cells[1, 1] = new Cell("OT Report"); return worksheet; }
public void EcritureC(int idSoc, Worksheet worksheet, int MoisPe, int AnneePe) { // if (idSoc == 2) // { worksheet = entete.EnteteSVRLigne14(worksheet, idSoc, MoisPe, AnneePe); // } }
public static void WriteDataTable(Worksheet ws, int row, int col, DataTable table, bool writeHeaders) { int curCol = col; if (writeHeaders) { foreach (DataColumn column in table.Columns) { WriteCell(ws, row, curCol, column.Caption, TableHeader); curCol++; } row++; } foreach (DataRow curRow in table.Rows) { curCol = col; foreach (DataColumn column in table.Columns) { WriteCell(ws, row, curCol, curRow[column], TableCell); curCol++; } row++; } }
public Worksheet EnteteOPR15Ligne2(Worksheet worksheet) { worksheet.Cells[1, 0] = new Cell("OPR 15"); worksheet.Cells[1, 1] = new Cell("FINANCIAL REPORT"); return worksheet; }
public static void WriteCell(Worksheet ws, int row, int col, object value, CellStyle style) { object temp = null; if (value is MySqlDateTime) { temp = ((MySqlDateTime)value).GetDateTime(); } else { temp = value; } if (temp != null && temp != DBNull.Value) { if (temp is DateTime) { ws.Cells[row, col] = new Cell(temp); ws.Cells[row, col].Format = DateCellFormat; } else { ws.Cells[row, col] = new Cell(temp); } } else { ws.Cells[row, col] = new Cell(String.Empty); } if (style != null) { ws.Cells[row, col].Style = style; } }
public static void SetColumnsWidth(Worksheet ws, params ushort[] widths) { for (ushort i = 0; i < widths.Length; i++) { ws.Cells.ColumnWidth[i] = widths[i]; } }
public void SimpleMultipleSheetTest() { int worksheetToCreate = 10; string tempFilePath = Path.GetTempFileName(); { Workbook workbook = new Workbook(); for (int i = 0; i < worksheetToCreate; i++) { Worksheet worksheetWrite2 = new Worksheet(String.Format("Sheet {0}", i)); workbook.Worksheets.Add(worksheetWrite2); } workbook.Save(tempFilePath); } { Workbook workbook = Workbook.Load(tempFilePath); Assert.AreEqual(worksheetToCreate, workbook.Worksheets.Count); for (int i = 0; i < worksheetToCreate; i++) { Assert.AreEqual(String.Format("Sheet {0}", i), workbook.Worksheets[i].Name); } } }
private void writeHeader(string filename) { Workbook workbook; if (File.Exists(filename)) workbook = Workbook.Load(filename); else workbook = new Workbook(); Worksheet akWorksheet = null; foreach (Worksheet worksheet in workbook.Worksheets) { if (worksheet.Name == TableName) akWorksheet = worksheet; } if (akWorksheet == null) { akWorksheet = new Worksheet(TableName); workbook.Worksheets.Add(akWorksheet); } int n = 0; foreach (DatasetConfigRow myFeld in datasetConfig.DatasetConfigRows) { akWorksheet.Cells[0, n] = new Cell(myFeld.DatabaseField); n++; } workbook.Save(filename); }
public ExcelAngleData() { worksheet = new Worksheet("angles"); PhoneAngletimer = new DispatcherTimer(); //samplerate for saving phone angles can changed here. PhoneAngletimer.Interval = TimeSpan.FromMilliseconds(200); PhoneAngletimer.Tick += PhoneAngletimer_Tick; }
public CursorExcel2003(byte[] data) { var wb = Workbook.Load(new MemoryStream(data)); if (wb == null || wb.Worksheets.Count <= 0) throw new ReportFormatException("Data was not recognized as Excel2003"); _worksheet = wb.Worksheets[0]; }
public Worksheet EnteteSVRLigne8(Worksheet worksheet,string Date1,string Date2) { string DT1 = form.LA_DATE_ADP(Date1); string DT2 = form.LA_DATE_ADP(Date2); worksheet.Cells[7, 0] = new Cell("Pay Cycle"); worksheet.Cells[7, 1] = new Cell(DT1+"-"+DT2); return worksheet; }
public static void AddParticipantToWorksheet(Worksheet ws, int row, IParticipant p) { string participantData = GetParticipantData(p, null); string[] participantValues = participantData.Split(';'); for (int i = 0; i < participantValues.Length; i++) { ws.Cells[row, i] = new Cell(participantValues[i]); } }
public static void Create(string filename) { Filename = filename; workbook = new Workbook(); worksheet = new Worksheet("Output"); for (int i = 0; i < 100; i++) worksheet.Cells[i, 0] = new Cell(""); }
public static Worksheet Decode(Workbook book, Stream stream, SharedResource sharedResource) { Worksheet sheet = new Worksheet(); sheet.Book = book; List<Record> records = ReadRecords(stream, out sheet.Drawing); sheet.Cells = PopulateCells(records, sharedResource); sheet.Book.Records.AddRange(records); return sheet; }
public static void ExportXLSX(List<IParticipant> participants, List<string> formFields) { string eventName = (participants.Count > 0) ? ((participants[0] != null && participants[0].EventPage != null && participants[0].EventPage != PageReference.EmptyReference) ? EPiServer.DataFactory.Instance.Get<PageData>(participants[0].EventPage).URLSegment : "NA" ) : "NA"; string fileName = EPiServer.Framework.Localization.LocalizationService.Current.GetString("/attend/edit/participants") + " - " + eventName; HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls"); HttpContext.Current.Response.Charset = Encoding.UTF8.WebName; HttpContext.Current.Response.ContentEncoding = Encoding.UTF8; HttpContext.Current.Response.BinaryWrite(Encoding.UTF8.GetPreamble()); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.Clear(); HttpContext.Current.Response.BufferOutput = true; Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Participants"); if(formFields != null) for(int i = 0; i < formFields.Count; i++) worksheet.Cells[0, i]= new Cell(formFields[i]); else if(participants.Count > 0) { string[] headers = AttendRegistrationEngine.GetFormData(participants[0]).AllKeys; worksheet.Cells[0, 0] = new Cell("Status"); worksheet.Cells[0, 1] = new Cell("E-mail"); worksheet.Cells[0, 2] = new Cell("Code"); for (int i = 0; i < headers.Length; i++) { worksheet.Cells[0, i+3] = new Cell(headers[i]); } } for (int i = 0; i < participants.Count; i++) { AddParticipantToWorksheet(worksheet, i+1, participants[i]); } // Some Excel versions requires more than 100 rows - adding empty ones for (int i = participants.Count; i < 150; i++) worksheet.Cells[i, 0] = new Cell(string.Empty); workbook.Worksheets.Add(worksheet); MemoryStream ms = new MemoryStream(); workbook.SaveToStream(ms); ms.WriteTo(HttpContext.Current.Response.OutputStream); HttpContext.Current.Response.End(); }
public void RelatedTest() { Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Test"); workbook.Worksheets.Add(worksheet); DateTime date = new DateTime(2009, 2, 13, 11, 30, 45); worksheet.Cells[0, 0] = new Cell(date); Assert.IsNotNull(worksheet.Cells[0, 0].Format); }
public void Test() { Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Test"); workbook.Worksheets.Add(worksheet); DateTime date = new DateTime(2009, 2, 13, 11, 30, 45); worksheet.Cells[0, 0] = new Cell(date); worksheet.Cells[0, 0].DateTimeValue = date; Assert.AreEqual(date, worksheet.Cells[0, 0].DateTimeValue); }
private static void AddWhitespace(int index, Worksheet worksheet) { var row = index + 50; for (int i = 0; i < 150; i++) { var col = 1; for (int j = 0; j < 10; j++) { worksheet.Cells[row, col] = new Cell(" "); col++; } row++; } }
private static void AddStudentDataToSheet(Worksheet sheet, int row, XcelStudent student) { sheet.Cells[row, 0] = new Cell(student.ID); sheet.Cells[row, 1] = new Cell(student.FirstName); sheet.Cells[row, 2] = new Cell(student.LastName); sheet.Cells[row, 3] = new Cell(student.Email); sheet.Cells[row, 4] = new Cell(student.Gender.ToString()); sheet.Cells[row, 5] = new Cell(student.StudentType.ToString()); sheet.Cells[row, 6] = new Cell(student.ExamResult); sheet.Cells[row, 7] = new Cell(student.HomeworksSent); sheet.Cells[row, 8] = new Cell(student.HomeworksEvaluated); sheet.Cells[row, 9] = new Cell(student.Teamwork); sheet.Cells[row, 10] = new Cell(student.Attendance); sheet.Cells[row, 11] = new Cell(student.Bonus); sheet.Cells[row, 12] = new Cell(student.CalculateResult()); }
static void Main() { helper.ConsoleMio.Setup(); helper.ConsoleMio.PrintHeading("LINQ to Excel "); var studentsExtractor = new TextDocumentParser(); IList<XcelStudent> students = studentsExtractor.Genereate(1000).Cast<XcelStudent>().ToList(); var sheet = new Worksheet("Online Students"); string[] sheetHeader = studentsExtractor.HeaderLine; for (int i = 0; i < sheetHeader.Length; i++) { sheet.Cells[0, i] = new Cell(sheetHeader[i]); } // Add the result filed in the end sheet.Cells[0, sheetHeader.Length] = new Cell("Result"); helper.ConsoleMio.PrintColorText("Proccessing information...\n\n", ConsoleColor.DarkCyan); var onlineStudents = students .Where(student => student.StudentType == StudentType.Online) .OrderByDescending(student => student.CalculateResult()) .ToArray(); for (int i = 0; i < onlineStudents.Length; i++) { XcelStudent student = onlineStudents[i]; AddStudentDataToSheet(sheet, i + 1, student); } var workbook = new Workbook(); workbook.Worksheets.Add(sheet); helper.ConsoleMio.PrintColorText( "Query Completed\n", ConsoleColor.Green); string saveLocation = helper.SelectSaveLocation("Xcel Files|*.xls"); workbook.Save(saveLocation); helper.ConsoleMio.PrintColorText("Done", ConsoleColor.Green); helper.ConsoleMio.Restart(Main); }
/// <summary> /// test excel library /// </summary> public static void ExcelLibraryTest() { //create new xls file string file = "C:\\temp\\newdoc.xls"; ExcelLibrary.SpreadSheet.Workbook workbook = new ExcelLibrary.SpreadSheet.Workbook(); ExcelLibrary.SpreadSheet.Worksheet worksheet = new ExcelLibrary.SpreadSheet.Worksheet("First Sheet"); worksheet.Cells[0, 1] = new Cell((short)1); worksheet.Cells[2, 0] = new Cell(9999999); worksheet.Cells[3, 3] = new Cell((decimal)3.45); worksheet.Cells[2, 2] = new Cell("Text string"); worksheet.Cells[2, 4] = new Cell("Second string"); worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00"); //worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY-MM-DD"); worksheet.Cells.ColumnWidth[0, 1] = 3000; workbook.Worksheets.Add(worksheet); workbook.Save(file); }
public Worksheet EnteteSVRLigne1(Worksheet worksheet) { worksheet.Cells[0, 0] = new Cell("Report date"); worksheet.Cells[0, 1] = new Cell("Pay cycle"); worksheet.Cells[0, 2] = new Cell("Country code"); worksheet.Cells[0, 3] = new Cell("Company name"); worksheet.Cells[0, 4] = new Cell("Entity ID"); worksheet.Cells[0, 5] = new Cell("Entity name"); worksheet.Cells[0, 6] = new Cell("Currency"); worksheet.Cells[0, 7] = new Cell("GL account"); worksheet.Cells[0, 8] = new Cell("GL description"); worksheet.Cells[0, 9] = new Cell("Cost center code"); worksheet.Cells[0, 10] = new Cell("Cost center description"); worksheet.Cells[0, 11] = new Cell("Amount debit"); worksheet.Cells[0, 12] = new Cell("Amount credit"); return worksheet; }
public static void ExportXLSX(List<IParticipant> participants, List<string> formFields) { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=participants-" + participants[0].EventPage.ID + ".xls"); HttpContext.Current.Response.Charset = Encoding.UTF8.WebName; HttpContext.Current.Response.ContentEncoding = Encoding.UTF8; HttpContext.Current.Response.BinaryWrite(Encoding.UTF8.GetPreamble()); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.Clear(); HttpContext.Current.Response.BufferOutput = true; Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Participants"); if(formFields != null) for(int i = 0; i < formFields.Count; i++) worksheet.Cells[0, i]= new Cell(formFields[i]); else { string[] headers = AttendRegistrationEngine.GetFormData(participants[0]).AllKeys; for (int i = 0; i < headers.Length; i++) { worksheet.Cells[0, i] = new Cell(headers[i]); } } for (int i = 0; i < participants.Count; i++) { AddParticipantToWorksheet(worksheet, i+1, participants[i]); } workbook.Worksheets.Add(worksheet); MemoryStream ms = new MemoryStream(); workbook.SaveToStream(ms); ms.WriteTo(HttpContext.Current.Response.OutputStream); HttpContext.Current.Response.End(); }
private bool StreamXL(string strPath) { bool blSuccess = false; Workbook xlWB = Workbook.Load(strPath); for (int j = 0; j < xlWB.Worksheets.Count; j++) { ExcelLibrary.SpreadSheet.Worksheet xlSheet = xlWB.Worksheets[j]; string strName = xlSheet.Name; strName = strName.Replace("'", "''"); bool blVerify = VerifySpreadSheet(strName); if (blVerify == true) { TraverseSpreadsheet(xlSheet); } } return(blSuccess); }
public static void Main() { List<Student> students = GetInput(); List<Student> onlineStudentsSortedByResult = students .Where(student => student.StudentType == "Online") .OrderByDescending(student => student.CalculateResult()) .ToList(); // creating new workbook and sheet const string pathToOutputFile = "../../output/outputFile.xls"; Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Online Students"); // adding all the students for (int i = 0; i < onlineStudentsSortedByResult.Count; i++) { worksheet.Cells[i, 0] = new Cell(onlineStudentsSortedByResult[i].ID); worksheet.Cells[i, 1] = new Cell(onlineStudentsSortedByResult[i].FirstName); worksheet.Cells[i, 2] = new Cell(onlineStudentsSortedByResult[i].LastName); worksheet.Cells[i, 3] = new Cell(onlineStudentsSortedByResult[i].Email); worksheet.Cells[i, 4] = new Cell(onlineStudentsSortedByResult[i].Gender); worksheet.Cells[i, 5] = new Cell(onlineStudentsSortedByResult[i].StudentType); worksheet.Cells[i, 6] = new Cell(onlineStudentsSortedByResult[i].ExamResult); worksheet.Cells[i, 7] = new Cell(onlineStudentsSortedByResult[i].HomeworkSent); worksheet.Cells[i, 8] = new Cell(onlineStudentsSortedByResult[i].HomeworkEvaluated); worksheet.Cells[i, 9] = new Cell(onlineStudentsSortedByResult[i].TeamworkScore); worksheet.Cells[i, 10] = new Cell(onlineStudentsSortedByResult[i].AttendacesCount); worksheet.Cells[i, 11] = new Cell(onlineStudentsSortedByResult[i].Bonus); worksheet.Cells[i, 12] = new Cell(onlineStudentsSortedByResult[i].CalculateResult()); } // saving the workbook workbook.Worksheets.Add(worksheet); workbook.Save(pathToOutputFile); }
static void Main(string[] args) { var underTest = new Workbook(); var sheet = new Worksheet("Sheet 1"); var styleA = new CellFormat(); styleA.SetBackgroundColor(ExcelColor.Red); styleA.Border.DiagonalUp = true; styleA.Border.DiagonalDown = true; styleA.Border.DiagonalStyle = CellBorderStyle.Thin; var styleB = new CellFormat { Pattern = { Style = PatternStyle.LightDown, ForegroundColor = ExcelColor.Blue } }; var styleC = new CellFormat(); styleC.SetBackgroundColor(ExcelColor.Silver); styleC.Border = CellBorder.MediumBox; styleC.Font.Bold = true; for (var i = 0; i < 100; i++) { var cellA = new Cell("Abcde"); var cellB = new Cell(1234); var cellC = new Cell(string.Format("This is row {0:000}", i)); if (i%2 == 0) { cellA.CellFormat = styleA; cellB.CellFormat = styleB; cellC.CellFormat = styleC; } else { cellB.CellFormat.TextControl.RotationStyle = RotationStyle.CounterClockwise; cellB.CellFormat.TextControl.TextRotation = 45; cellC.VerticalAlignment = VerticalAlignStyle.Centered; cellC.CellFormat.Font.Name = "Times New Roman"; cellC.CellFormat.Font.Family = FontFamilyType.Roman; cellC.CellFormat.Font.Height = 240; } sheet.Cells[i, 0] = cellA; sheet.Cells[i, 1] = cellB; sheet.Cells[i, 2] = cellC; sheet.Cells.ColumnWidth[2] = 256 * 15; } underTest.Worksheets.Add(sheet); var filename = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory), "test.xls"); if (File.Exists(filename)) { File.Delete(filename); } underTest.Save(filename); }