Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XML
|
XML General XML discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XML section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 23rd, 2006, 10:21 AM
Registered User
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Convert an Excel worksheet to xml

I have a spreadsheet created in Excel. It has fields and values that have been laid out using the columns and rows. I want to export the layout of the fields and values into an xsl that i can use to produce a pdf file.

Since i want to be able to include images and the like in the sheet, i can't use straight up csv or xml because the linked information is filtered out. I am currently looking at saving the sheet as xml/html, and then extracting the layout information, but its pretty ugly. Is there anything out there that can accomplish what im trying to do?

 
Old November 23rd, 2006, 10:46 AM
Friend of Wrox
 
Join Date: Jul 2006
Posts: 430
Thanks: 28
Thanked 5 Times in 5 Posts
Send a message via Yahoo to bonekrusher
Default

I am not sure what you mean by "filtered out" - If you save the excel sheet to xml, the link is an attribute of the cell and can be processed to a pdf with xsl-fo.

I created a simple spreadsheet with a cell that contained www.yahoo.com

this is what it looks like in XML

Code:
<Cell ss:StyleID="s21" ss:HRef="http://www.yahoo.com/"><Data ss:Type="String">www.yahoo.com</Data></Cell>





Similar Threads
Thread Thread Starter Forum Replies Last Post
Reflecting changes in Excel Worksheet...???? hunk1985 General .NET 0 September 12th, 2007 06:29 AM
How to continue to next new excel worksheet christine_wmw Classic ASP Basics 0 January 24th, 2007 02:54 AM
Writing to an Excel Worksheet in VB6 David Robinson Pro VB 6 1 August 27th, 2005 04:29 PM
DYNAMIC EXCEL WORKSHEET NAME?? tbaquero Classic ASP Professional 2 October 5th, 2004 08:30 AM
Opening excel worksheet in c# GanpatDSouza C# 1 January 23rd, 2004 03:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.