public void TestDoubleValue() { //put cell names in vars... var excelFile = ExcelFile.Open(path); IWorksheet worksheet = excelFile.OpenWorksheet(sheetName); var cellLowerCase = worksheet.GetCell("c3"); Assert.NotNull(cellLowerCase); var doubleValueCell = worksheet.GetCell("A4"); Assert.NotNull(doubleValueCell); doubleValueCell.DoubleValue = doubleValue; var stringValueCell = worksheet.GetCell("A5"); Assert.NotNull(stringValueCell); stringValueCell.StringValue = stringValue; var fakeStringValueCell = worksheet.GetCell("A6"); Assert.NotNull(fakeStringValueCell); fakeStringValueCell.StringValue = fakeStringValue; var charNumberValueCell = worksheet.GetCell("A7"); Assert.NotNull(charNumberValueCell); charNumberValueCell.DoubleValue = charNumber; excelFile.Save(); excelFile.Close(); }
public void TestWriteNullValueCell() { var excelFile = ExcelFile.Open(path); IWorksheet worksheet = excelFile.OpenWorksheet(sheetName); var cellName = "D19"; worksheet.GetCell(cellName).StringValue = null; excelFile.Save(); Assert.Null(worksheet.GetCell(cellName).StringValue); }
private void AddTitle(IWorksheet worksheet) { _rowIndex++; worksheet.GetCell(_rowIndex, 1).Value = _title; var range = worksheet.GetCellRange(_rowIndex, 1, _rowIndex, 2); range.Style.Font.Bold = true; range.Style.Font.Size = 16; // datum / User worksheet.GetCell(_rowIndex, 4).Value = string.Format("{0:G}", DateTime.Now); worksheet.GetCell(_rowIndex, 5).Value = ApplicationContext.User.Identity.Name; // leer Zeile _rowIndex++; }
private void AddParams(IWorksheet worksheet) { var startRow = _rowIndex + 1; foreach (var parameter in _parameters) { _rowIndex++; worksheet.GetCell(_rowIndex, 1).Value = parameter.Key; worksheet.GetCell(_rowIndex, 2).Value = parameter.Value; } var range = worksheet.GetCellRange(startRow, 1, _rowIndex, 1); range.Style.Font.Bold = true; // leer Zeile _rowIndex++; }
public void TestWriteStringAtCell() { var cellName = "D18"; var cellValue = "Peteca"; var excelFile = ExcelFile.Open(path); IWorksheet worksheet = excelFile.OpenWorksheet(sheetName); worksheet.GetCell(cellName).StringValue = cellValue; //excelFile.Save(); //excelFile.Close(); //excelFile = ExcelFile.Open(path); //worksheet = excelFile.OpenWorksheet(sheetName); Assert.Equal(cellValue, worksheet.GetCell(cellName).StringValue); excelFile.Close(); }
private void AddHeadings(IWorksheet worksheet) { _rowIndex++; for (int c = 0; c < _numOfCols; c++) { worksheet.GetCell(_rowIndex, c + 1).Value = _gridView.VisibleColumns[c].Caption; } var range = worksheet.GetCellRange(_rowIndex, 1, _rowIndex, _numOfCols); range.Style.Fill.PatternType = EFillStyle.Solid; range.Style.Fill.BackgroundColor = Color.LightGray; }
private void button1_Click(object sender, EventArgs e) { ExcelFile file = ExcelFile.Open(@"D:\Book1.xlsx"); IWorksheet sheet2 = file.OpenWorksheet("asasda"); IWorksheet sheet1 = file.OpenWorksheet("Sheet1"); var cell = sheet1.GetCell("A4"); //IWorksheet sheet1 = file.OpenWorksheet("Sheet2"); //Column a = sheet1.CreateColumnBetween(8, 8); //Column column = sheet1.GetColumn("F"); //double realPosition = sheet1.GetColumnPosition(column.ColumnIndex); //Row row = sheet1.GetRow(12); //double rowRealPosition = sheet1.GetRowPosition(row.Index); //column.Width = 4.57; /* * //Numbers * Cell h1 = sheet1.GetCell("H1"); //Cell in use. * h1.Value = "40210"; * Cell c1 = sheet1.GetCell("C1"); * c1.Value = "3443"; * * //Text * Cell b1 = sheet1.GetCell("B1"); * b1.Value = "Atwood Falcon"; //Existing text - index = 7; * Cell a3 = sheet1.GetCell("A3"); * a3.Value = "New Text for A3"; //new Text */ /*var shape = sheet1.Drawings.DrawShape(sheet1.GetColumn("D"), sheet1.GetRow(4), 0, 0, 40, 80); * shape.Text = "Shape1"; * shape.ForeColor = Color.Black; * shape.MarginLeft = 10; * shape.MarginRight = 10; * shape.MarginTop = 10; * shape.MarginBottom = 10; * shape.Text = "12345";*/ file.Save(); file.Close(); }
// in this context a cell is treated as empty if there is now key defined private bool IsEmptyRow(int row) { return(mySheet.IsEmptyCell(mySheet.GetCell("A" + row))); }