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);
}
