/// <summary> /// Находит текст в документе и заменяет его, если найдено. ВНИМАНИЕ! К искомой строке добавляются квадратные скобки [] /// </summary> /// <param name="ws">Лист Excel</param> /// <param name="findStr">Искомый текст</param> /// <param name="replaceStr">Заменяющий текст</param> public static void FindAndReplaceText(this Excel.ExcelWorksheet ws, string findStr, string replaceStr) { string str = string.Format("[{0}]", findStr); int rowIndex, columnIndex; if (ws.Cells.FindText(str, true, true, out rowIndex, out columnIndex)) { ws.Cells[rowIndex, columnIndex].Value = replaceStr; } }
public void ExportFillProvisalRegister(IList <Customer> customers, GemBox.Spreadsheet.ExcelWorksheet sheet, ref int stt) { var activeRow = 1; foreach (var customer in customers) { sheet.Cells[activeRow, 0].Value = stt.ToString(); stt++; customer.Fullname = customer.Fullname ?? ""; sheet.Cells[activeRow, 1].Value = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(customer.Fullname.ToLower()); var birthday = ""; try { birthday = customer.Birthday.Value.ToString("dd/MM/yyyy"); } catch (Exception) { } sheet.Cells[activeRow, 2].Value = birthday; sheet.Cells[activeRow, 3].Value = "D"; var isMale = false; try { isMale = customer.IsMale.Value; } catch (Exception) { } if (isMale) { sheet.Cells[activeRow, 4].Value = "M"; } else { sheet.Cells[activeRow, 4].Value = "F"; } var maquoctich = ""; try { maquoctich = customer.Nationality.AbbreviationCode; } catch (Exception) { } sheet.Cells[activeRow, 5].Value = maquoctich; sheet.Cells[activeRow, 6].Value = customer.Passport; sheet.Cells[activeRow, 7].Value = ((BookingRoom)customer.BookingRooms[0]).Room != null ? ((BookingRoom)customer.BookingRooms[0]).Room.Name : ""; sheet.Cells[activeRow, 8].Value = ((BookingRoom)customer.BookingRooms[0]).Book.StartDate.ToString("dd/MM/yyyy"); sheet.Cells[activeRow, 9].Value = ((BookingRoom)customer.BookingRooms[0]).Book.EndDate.ToString("dd/MM/yyyy"); sheet.Cells[activeRow, 10].Value = ((BookingRoom)customer.BookingRooms[0]).Book.EndDate.ToString("dd/MM/yyyy"); sheet.Cells[activeRow, 10].Value = customer.NguyenQuan; activeRow++; } }