I have created a bar chart in an excel file report using the MSOffice2k_x tagset. The problem is that two files are created, one is the excel file which has a link to the second file which is a png file. The excel file links to the png and shows the image when you open it, but it isn't actually embedded in the excel file. I'd like to be able to send the output into excel instead of a png (or any other type file). Is it not possible to do this?
What I eventually hope to end up with is going to be several report files with multiple tabs and graphs, so copy pasting each image in each file or emailing dozens of pngs to end users is not really an option. (And of course they want excel and not a PDF.) I tried just using 'file=' on in my code instead of 'file=' and 'path=', and that did create one file, but the graph was super tiny (1 cm by 1 cm) and I couldn't made it any larger.
For help with MSOFFICE2K_X destination output, you may want to work with Tech Support. It was my understanding that all HTML-based output (ODS HTML, ODS MSOFFICE2K, ODS MSOFFICE2K_X) were using graphics by rendering the IMG tag that ODS puts in the HTML result file. This means that the PNG (or whatever format) image is external to the HTML file and is NOT embedded in Excel when Excel renders the file. The only destinations that truly embed images are PDF and RTF destinations.
I cannot figure out what you mean by FILE= versus FILE= and PATH=. If you examine the HTML, using Notepad, you can find out how PATH= changes the file location used in the IMG tag. Again, Tech Support can look at all your code and your data and help you figure out what is happening.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.