Eric White's Blog

Ok I watched the video and so it seems a bit complicated to drill down into the values area for the chart and the cached values, its do-able but my follow up question would be: can the chart values be attached to content controls that are named and you find those controls and change them?

In my case my chart is at the end of the document so i could take my doc template that is used for all the other data, draw out my horizontal bar chart with maybe values of 1, but somehow associate the values to content controls. The names of the 3 series’ will always be the same just the data and it is a 0-100% kind of chart. In the jquery chart i had to add another series with the other part of the bar to fill in to 100% so 100 – first series = 2nd series, or if first series > 100 then first series = 100

But thats easy. I have been trying without luck to put a chart in a word.docx then open it with the sdk tool and get the code to duplicate it; embed that code in my method, it runs but the resulting docx file is “corrupted” and wont open.

I was able to do this with table embedding, not sure why its not working.

But is the content control link to parameters possible?

thanks

thats impressive that you did all of that. I started watching the videos, at #1 – 5 then realized you said 11 – 13. I heard c# added some new features like this, interesting. I started in the 70s and have seen functional, alot of assembler, then interfaces and controllers, cpu/mem (hw/sw). i learned Java but didnt use it much, mostly visual studio or some other ui’s. really liked cpu design and next address concepts and internal microcode.

when coming into .net the delegate was the most difficult thing. didnt have to use them too much. i came from old C, so c# is just fun. But now expanding to web programming, slowly getting used to it. will keep looking at the videos, they’re very well done.

If you want to have me try to do small modules at a time to duplicate the openxml for javascript, I will try if you let me know just what to do.

In this project its a final report, the user would not change the chart, although if that helps reduce complexity or not, am not sure.

thought it was going to be easy to put a chart onto the word docx. but now if we made the javascript version happen, would i be able for instance to use the dhtmlx chart app in jquery and generate and drop it into the openxml doc? if i can help create the charting code let me know

will finish the videos and try again,

the video you have there https://www.youtube.com/watch?v=60w-yPDSQD0
shows the wrong URL, missing the ‘e’ it says sourcforge instead of sourceforge. it takes you to some dark domain

is there something thats supposed to be added in to visual studio 2015 to make it know about openxml power tools?

in searching I also found the detail that some questions would move to stack overflow? Really hope NOT, Id say thats not good, ask a question there and get flamed, reviled and down voted and called stupid and every name in the book. they have traffic but the stack overflow community SUCKS. Ive done this pushing 40 years, was in the IEEE and other groups, couple years ago hit by a car on my bicycle and have struggled to get my energy and abilities back, have challenges to write it their way apparently. Getting ridiculed as an idiot by stack overflow I take as an insult, I know what professional engineering and team work in many successful groups is. What stack overflow has is hacker level types who dont.

Code Project, MSDN and asp.net have forums with professional people, my 2 cents is use them instead

Im trying to implement the basic code to access the chart, but get stuck

referencing the video https://www.youtube.com/watch?v=xOJ_AgXgL-M at about the 6:21 mark,

 using (Stream strr = epp.GetStream())
                    using (MemoryStream memst = new MemoryStream())
                    {
                        CopyStream(strr, memst);
                        using (SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.Open(memst, true))
                        {

CopyStream, oddly has a red underline. am trying to copy this line by line from the video, is there code from that video available?