Solved

Importing XML graph from Excel to SQL

Posted on 2011-02-24
1
456 Views
Last Modified: 2013-11-05
We receive Excel sheets containing worksheets with graphs. We want to import the graphs into a SQL server database in a way we can reuse the graphs. For example in a report having the user selecting the graph from the SQL server database. We want to do this in a way we can reformat the graph (only letter type/style and colors).  So we don’t want to store the actual data and we don’t want to reproduce the graph using the report tool itself. Our idea is to save the graph using the XML format. But for us it is unclear at the moment if it is possible to store the Excel graph object using XML in a way we can reproduce the graph using SQL server and reporting services. We are using Excel 2007/2010, SQL server 2008 R2 (including reporting services). Maybe there are other options out there we can use? Please advise
0
Comment
Question by:Netwerkbeheer_AZL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 34970527
I believe you have two options:

1. import data and XML from excel into SQL where you could use XML data type then retrieve it in your app by using your own custom code or into EXCEL again
2. import EXCEL data into SQL and use SSRS to (re)build the reports/graphs
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question