tag. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More...
i have spent 5 hrs on it still could n't make it work..sucks oh well... Join them; it only takes a minute: Sign up Error : Exporting excel through XSLT up vote 1 down vote favorite 1 i'm exporting excel file through xml and xslt and Those error messages might give you some clue as to what it doesn't like. my review here Attached Images excel2000.jpg (40.6 KB, 503 views) Reply With Quote 8 May 2008,1:05 AM #40 DamienValentine View Profile View Forum Posts Private Message Ext User Join Date Apr 2008 Posts 18
You'll have to change your directory structure to however you have things set-up. thank you soooo much!!! Edit : see complete XML here xml xslt export-to-excel share|improve this question edited Aug 22 '12 at 12:40 asked Aug 22 '12 at 12:09 Mayank Pathak 2,42532251 We really
Registration is fast, simple and absolutely free .
RPG Code: Have tried the following SQL: stmt+= ' as enddte,timestamp_iso(hst.qchstts) as qchstts'; stmt+= ' as enddte,hst.qchstts'; col(1).sqlName = 'qchstts'; col(1).heading = 'Date/Time'; col(1).styleID = 'tStamp'; col(1).colWidth = 100; . . Posts: 3,073 Thanks: 1 Thanked 38 Times in 37 Posts I do get the error on opening in Excel, however the actual XML is correct as far as your transform goes. The time now is 9:59 AM. Posts: 290 Thanks: 24 Thanked 0 Times in 0 Posts XML to EXCEL ATTRIBUTE NOT WORKING Note: I am using MSXML 4 and aspx.
Why didn’t Japan attack the West Coast of the United States during World War II? One other question - When I open this in Excel, make a change, and then save it, the namespace prefix is removed just about everywhere. The problem is, that the value for ExpandedRowCount is correct with 27, but the ExpandedColumnCount should be 8 and not 50, for only 8 columns and 27 rows are used to get redirected here Reply With Quote 5 May 2008,3:10 AM #38 DamienValentine View Profile View Forum Posts Private Message Ext User Join Date Apr 2008 Posts 18 Vote Rating 0 0 I
View our list of code downloads. If I hide some columns and rows manually and save as .XML again, the original line was changed by Ecel to this Table ss:ExpandedColumnCount="50″ ss:ExpandedRowCount="27″ x:FullColumns="1″ x:FullRows="1″ ss:StyleID="Default" ss:DefaultColumnWidth="5″ ss:DefaultRowHeight="15″ and PE-IT09-07-2012, 09:01 AMValence Version 3.1 is the version I am using. Reply With Quote 7 May 2008,5:01 PM #39 radtad View Profile View Forum Posts Private Message Sencha User Join Date Jan 2008 Location Los Angeles Posts 149 Vote Rating 1
The problem is, I want to create an Excel sheet, only showing the used lines and columns, all other lines and columns shold be marked as hidden. Welcome to the p2p.wrox.com Forums. Register now while it's still free! Thanks Animal!!
To start viewing messages, select the forum that you want to visit from the selection below. Helped me too. The time now is 01:59 PM. BRandle09-06-2012, 08:14 PMThe style of the spreadsheet cell can be mm/dd/yy hh:mm AP/PM but a dateTime value must be in the format YYYY-MM-DDTHH.MM.SS.000 From your sample above there is a dash
How can I set the Expanded[Row|Column]Count to the correct Values? Sometimes line is divided into two separate blocks and second block is placed as a new line. Noah Senior Web Developer NBA.com Reply With Quote 2 May 2008,11:08 AM #33 Animal View Profile View Forum Posts Private Message Sencha - Ext JS Dev Team Join Date Mar 2007 Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.
Thank you. First, I get a count of how many columns I need to span Then