public bool ReplaceSymbol(string data) { try { Factory.GetWorkbook(@data); } catch (Exception ex) { MessageBox.Show("Не знайдено шаблон документа!\n" + ex.Message, "Увага", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } var Workbook = Factory.GetWorkbook(@data); var Worksheet = Workbook.Worksheets[0]; var Сells = Worksheet.Cells; IRange cells = Worksheet.Cells; cells.Replace("а", "a", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("А", "A", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("і", "i", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("І", "I", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("Р", "P", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("р", "p", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("с", "c", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("С", "C", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("к", "k", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("К", "K", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("Н", "H", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("х", "x", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("е", "e", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("Е", "E", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("Х", "X", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("В", "B", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("а", "a", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("А", "A", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("о", "o", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("О", "O", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("м", "m", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("М", "M", LookAt.Part, SearchOrder.ByRows, true); cells.Replace("Т", "T", LookAt.Part, SearchOrder.ByRows, true); try { Workbook.Save(); } catch (System.IO.IOException) { MessageBox.Show("Документ уже открыто!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (System.ComponentModel.Win32Exception) { MessageBox.Show("Не найдено пакет программ Microsoft Excel!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning); } return(true); }