Solved

Importing XML graph from Excel to SQL

Posted on 2011-02-24
1
455 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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Incremental load example 2 57
passing parameter in sql procedure 9 68
Using this function 4 43
SQL- GROUP BY 4 26
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

697 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