Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 459
  • Last Modified:

Importing XML graph from Excel to SQL

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
Netwerkbeheer_AZL
Asked:
Netwerkbeheer_AZL
1 Solution
 
lcohanDatabase AnalystCommented:
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now