Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // How i call the method
- object value = null;
- bool fixWorked = false;
- Thread t = new Thread(() => value = LoadChartTemplate());
- t.SetApartmentState(ApartmentState.STA);
- Start();
- Join();
- // Reading thread return
- fixWorked = (bool)value;
- // My Method
- private static bool LoadChartTemplate ()
- {
- Application excelApp = null;
- Workbook workbook = null;
- Microsoft.Office.Interop.Excel.Worksheet worksheet = null;
- try
- {
- excelApp = new Microsoft.Office.Interop.Excel.Application();
- workbook = excelApp.Workbooks.Open (config.DiretorioRelatorio);
- worksheet = workbook.Sheets[Consts.RECOVERED_SHEET];
- string template = @"C:\Projetos\Marcello Lins\TIM\Relatorios_Cobranca\TimRelatorioCampEscritaXPagamento\ReportLIB\ReportPath\TimChartTemplate.crtx";
- ChartObject charts = worksheet.ChartObjects (0);
- charts.Chart.ApplyChartTemplate (config.DiretorioRelatorio);
- return true;
- }
- catch (Exception ex)
- {
- Console.WriteLine (ex.Message);
- return false;
- }
- finally
- {
- workbook.Save ();
- workbook.Close();
- excelApp.Quit ();
- ReleaseObject (worksheet);
- ReleaseObject (workbook);
- ReleaseObject (excelApp);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment