diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs index 0e66171..2557ca1 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs @@ -192,16 +192,6 @@ { GeneratePivotTables(workbookPart, worksheetPart, worksheet, context); } - - - //DrawingsPart drawingsPart = worksheetPart.AddNewPart("rId1"); - //GenerateDrawingsPartContent(drawingsPart, worksheet); - - //foreach (var chart in worksheet.Charts) - //{ - // ChartPart chartPart = drawingsPart.AddNewPart("rId1"); - // GenerateChartPartContent(chartPart, (XLChart)chart); - //} } GenerateCalculationChainPartContent(workbookPart, context); diff --git a/ClosedXML/ClosedXML/ClosedXML/PathHelper.cs b/ClosedXML/ClosedXML/ClosedXML/PathHelper.cs index 696e074..83cbb4c 100644 --- a/ClosedXML/ClosedXML/ClosedXML/PathHelper.cs +++ b/ClosedXML/ClosedXML/ClosedXML/PathHelper.cs @@ -232,17 +232,6 @@ return path; } - public static void OpenFileFolder(string filePath) - { - string cmdLine = string.Format("/select,\"{0}\"", filePath); - Process.Start(@"explorer.exe", cmdLine); - } - - public static void OpenFile(string filePath) - { - Process.Start(filePath); - } - [Flags] public enum PathTypes { diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs index 6cc170c..95ff2ff 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs @@ -16,13 +16,20 @@ private static void Main(string[] args) { - var wb = new XLWorkbook(@"c:\temp\ColorBook.xlsx"); - var ws = wb.Worksheet("Sheet1"); - var fontColor = ws.Cell("C9").Style.Font.FontColor; - Console.WriteLine("The result for cell is " + fontColor.Color.ToString()); - wb.SaveAs(@"c:\temp\saved.xlsx"); + var wbSource = new XLWorkbook(@"c:\temp\filesource.xlsm"); + var wbTarget = new XLWorkbook(); + + foreach (var ws in wbSource.Worksheets) + { + wbTarget.AddWorksheet(ws); + ws.Range("").CreateTable().ShowAutoFilter = false; + } + + + wbTarget.SaveAs(@"c:\temp\target_saved.xlsm"); + wbSource.SaveAs(@"c:\temp\source_saved.xlsm"); Console.WriteLine("Done"); - Console.ReadLine(); + //Console.ReadLine(); } } }