/// <summary> /// Create XLS file from ifc/xbim files /// </summary> /// <param name="parameters">Params</param> private void GenerateCOBieFile(Params parameters) { string outputFile = Path.ChangeExtension(parameters.ModelFile, ".xls"); Stopwatch timer = new Stopwatch(); timer.Start(); COBieBuilder builder = GenerateCOBieWorkBook(parameters); timer.Stop(); LogBackground(String.Format("Time to generate COBie data = {0} seconds", timer.Elapsed.TotalSeconds.ToString("F3"))); // Export LogBackground(String.Format("Formatting as {1} using {0} template...", Path.GetFileName(parameters.TemplateFile), parameters.IsXLSX ? "XLSX" : "XLS")); COBieXLSXSerialiser serialiser = new COBieXLSXSerialiser(outputFile, parameters.TemplateFile); serialiser.Excludes = UserFilters; serialiser.IsXlsx = parameters.IsXLSX; builder.Export(serialiser); LogBackground(String.Format("Export Complete: {0}", outputFile)); Process.Start(serialiser.FileName); LogBackground("Finished COBie Generation"); }
/// <summary> /// Performs the export /// </summary> /// <returns>True on success, false on error.</returns> private bool ExportCoBie() { if (!Directory.Exists(TxtFolderName.Text)) { try { Directory.CreateDirectory(TxtFolderName.Text); } catch (Exception) { MessageBox.Show("Error creating directory. Select a different location."); return(false); } } var fName = Model.FileName; if (string.IsNullOrEmpty(fName)) { fName = "Unnamed"; } var f = new FileInfo(Path.ChangeExtension(fName, ".xls")); var outputFile = Path.Combine(TxtFolderName.Text, f.Name); // configure settings for exporter var ass = System.Reflection.Assembly.GetAssembly(GetType()); if (_parentWindow == null) { Log.LogError("attempt to locate DiskLess assembly without a valid IXbimXplorerPluginMasterWindow."); return(false); } var assemblyFile = _parentWindow.GetAssemblyLocation(ass); var pluginDir = new FileInfo(assemblyFile).Directory; if (pluginDir == null) { Log.LogError("Failed to determine plugin folder under IXbimXplorerPluginMasterWindow."); return(false); } var templateFileName = Path.Combine( pluginDir.FullName, CoBieTemplate); var context = new COBieContext { TemplateFileName = templateFileName, Model = Model, Exclude = UserFilters }; // setting culture for thread; the current one will be restored later. CultureInfo exisitingCultureInfo = null; try { var ci = new CultureInfo("en-GB"); exisitingCultureInfo = Thread.CurrentThread.CurrentUICulture; Thread.CurrentThread.CurrentUICulture = ci; } catch (Exception ex) { Log.LogError(0, ex, "CurrentUICulture could not be set to en-GB."); } // actual export code var builder = new COBieBuilder(context); var serialiser = new COBieXLSSerialiser(outputFile, context.TemplateFileName) { Excludes = UserFilters }; builder.Export(serialiser); // restoring culture for thread; try { if (exisitingCultureInfo != null) { Thread.CurrentThread.CurrentUICulture = exisitingCultureInfo; } } catch (Exception ex) { Log.LogError(0, ex, "CurrentUICulture could not restored."); } if (ChkOpenExcel.IsChecked.HasValue && ChkOpenExcel.IsChecked.Value) { Process.Start(outputFile); } return(true); }
/// <summary> /// Performs the export /// </summary> /// <returns>True on success, false on error.</returns> private bool ExportCoBie() { if (!Directory.Exists(TxtFolderName.Text)) { try { Directory.CreateDirectory(TxtFolderName.Text); } catch (Exception) { MessageBox.Show("Error creating directory. Select a different location."); return(false); } } var f = new FileInfo(Path.ChangeExtension(Model.FileName, ".xls")); var outputFile = Path.Combine(TxtFolderName.Text, f.Name); var context = new COBieContext { TemplateFileName = CoBieTemplate, Model = Model, Exclude = UserFilters }; // setting culture for thread; the current one will be restored later. CultureInfo exisitingCultureInfo = null; try { var ci = new CultureInfo("en-GB"); exisitingCultureInfo = Thread.CurrentThread.CurrentUICulture; Thread.CurrentThread.CurrentUICulture = ci; } catch (Exception ex) { Log.Error("CurrentUICulture could not be set to en-GB.", ex); } // actual export code var builder = new COBieBuilder(context); var serialiser = new COBieXLSSerialiser(outputFile, context.TemplateFileName) { Excludes = UserFilters }; builder.Export(serialiser); // restoring culture for thread; try { if (exisitingCultureInfo != null) { Thread.CurrentThread.CurrentUICulture = exisitingCultureInfo; } } catch (Exception ex) { Log.Error("CurrentUICulture could not restored.", ex); } if (ChkOpenExcel.IsChecked.HasValue && ChkOpenExcel.IsChecked.Value) { Process.Start(outputFile); } return(true); }