xsvarrapydaybzx
New Member
I want to create a graph in Excel with the spreadsheet reference.\[code\]@model IEnumerable<ARTex.Core.Models.Reservation>@{ Layout = null; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment; filename= Reservaties - " + DateTime.Now.ToString("dd/MM/yyyy") + ".xls");} <?xml version="1.0" encoding="utf-16"?><ss:Workbook xmlns:ss="urn:schemas-microsoft-com
ffice:spreadsheet"><ss:Styles> <!--style reservation header--> <ss:Style ss:ID="1"> <ss:Font ss:Bold="1" ss:Size="11" ss:Color="White"/> <ss:Interior ss:Color='Black' ss
attern='Solid'/> </ss:Style> <!--style group/individual header--> <ss:Style ss:ID="2"> <ss:Font ss:Bold="1" ss:Size="11"/> <ss:Interior ss:Color='#D9D9D9' ssattern='Solid'/> </ss:Style> <!--style group/individual/reservation body--> <ss:Style ss:ID="3"> <ss:Interior ssattern='Solid' /> <ss:Alignment ss:WrapText="1" ss:Vertical="Top"/> </ss:Style> <ss:Style ss:ID="4"> <ss:Interior ssattern='Solid'/> </ss:Style></ss:Styles>@{Html.RenderPartial("_ExcelWorksheet", Model.Where(x => !x.Deleted), new ViewDataDictionary { { "sheetName", "Reservations" } }); Html.RenderPartial("_ExcelWorksheet", Model.Where(x => x.Deleted), new ViewDataDictionary { { "sheetName", "Deleted Reservations" } }); Html.RenderPartial("_ExcelGraph", Model,new ViewDataDictionary{ {"sheetname", "Graph" }});}}</ss:Workbook>\[/code\]this is my main .cshtml page and I want to create a graph with the Partial view page _ExcelGraph. I'm just trying to show the some basic output.Code _ExcelGraph\[code\]@{ var myChart = new Chart(width: 600, height: 400) .AddTitle("Chart Title") .AddSeries( name: "Employee", xValue: new[] { "Peter", "Andrew", "Julie", "Mary", "Dave" }, yValues: new[] { "2", "6", "4", "5", "3" }) .Write(); }\[/code\]This keeps giving me an image and I can't seem to figure out how to place this image in a worksheet or how I can properly show it as a worksheet.Thanks in advance.EditRead somewhere that this ain't possible with XML spreadsheet reference 2003 ?
ffice:spreadsheet"><ss:Styles> <!--style reservation header--> <ss:Style ss:ID="1"> <ss:Font ss:Bold="1" ss:Size="11" ss:Color="White"/> <ss:Interior ss:Color='Black' ssattern='Solid'/> </ss:Style> <!--style group/individual header--> <ss:Style ss:ID="2"> <ss:Font ss:Bold="1" ss:Size="11"/> <ss:Interior ss:Color='#D9D9D9' ssattern='Solid'/> </ss:Style> <!--style group/individual/reservation body--> <ss:Style ss:ID="3"> <ss:Interior ssattern='Solid' /> <ss:Alignment ss:WrapText="1" ss:Vertical="Top"/> </ss:Style> <ss:Style ss:ID="4"> <ss:Interior ssattern='Solid'/> </ss:Style></ss:Styles>@{Html.RenderPartial("_ExcelWorksheet", Model.Where(x => !x.Deleted), new ViewDataDictionary { { "sheetName", "Reservations" } }); Html.RenderPartial("_ExcelWorksheet", Model.Where(x => x.Deleted), new ViewDataDictionary { { "sheetName", "Deleted Reservations" } }); Html.RenderPartial("_ExcelGraph", Model,new ViewDataDictionary{ {"sheetname", "Graph" }});}}</ss:Workbook>\[/code\]this is my main .cshtml page and I want to create a graph with the Partial view page _ExcelGraph. I'm just trying to show the some basic output.Code _ExcelGraph\[code\]@{ var myChart = new Chart(width: 600, height: 400) .AddTitle("Chart Title") .AddSeries( name: "Employee", xValue: new[] { "Peter", "Andrew", "Julie", "Mary", "Dave" }, yValues: new[] { "2", "6", "4", "5", "3" }) .Write(); }\[/code\]This keeps giving me an image and I can't seem to figure out how to place this image in a worksheet or how I can properly show it as a worksheet.Thanks in advance.EditRead somewhere that this ain't possible with XML spreadsheet reference 2003 ?