Re: How to Create a Bar Graph / 3D Pie Chart in PowerPoint using .NET OpenXML API > View Original Message Hi, thanks for quick reply and also thanks for this wonderful post. Here is my code where I am calling Excel Tools: var dt = new System.Data.DataTable(); dt.Columns.Add(categoryTitle); foreach (string st in seriesTitles) { dt.Columns.Add(st, typeof(int)); } foreach (string key in dict.Keys) { var dr = dt.NewRow(); dr[0] = key; int[] arr = dict[key]; for (int i = 1; i <= arr.Length; i++) dr[i] = arr[i - 1]; dt.Rows.Add(dr); } string tempCsv = Path.Combine(workingTempFolder, Guid.NewGuid().ToString() + ".xlsx"); // get random file name if (File.Exists(tempCsv)) File.Delete(tempCsv); ExcelTools.CreatePackage(tempCsv, dt, true); using (Stream data = new MemoryStream(File.ReadAllBytes(tempCsv))) { embeddedPackagePart1.FeedData(data); data.Close(); } if (File.Exists(tempCsv)) File.Delete(tempCsv); // remove our file we created
Created By: Guest 1/5/2017 5:00:21 AM
|
|