RE: Formatting an EXCEL Worksheet Generated From The 400 -- MIDRANGE-L

For the x:str stuff to work you also need:

<HTML xmlns:x="urn:schemas-microsoft-com:office:excel">

At the top 

(And obviously </HTML> at the end.)

But I don't know how far back that will work in office versions. Works fine
in 2003 <G>

-Walden


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: John Brandt Sr. [mailto:pgmr@xxxxxxxxxxxxxxx] 
Sent: Tuesday, February 10, 2004 1:18 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Formatting an EXCEL Worksheet Generated From The 400

Try this:
<table border="1">
  <tr>
      <td><b>Product Id</b></td>
      <td><b>Description</b></td>
      <td><b>On Hand</b></td>
   </tr>
   <tr>
      <td align="left"> WIDGET-A</td>
      <td align="left">A Widget</td>
      <td>0</td>
   </tr>
   <tr>
      <td align="left">WIDGET-B</td>
      <td align="left">B Widget</td>
      <td x:str="'00225">00255</td>
   </tr>
</table>

John Brandt
iStudio400.com


-----Original Message-----
From: Scott Mildenberger [mailto:scottmildenberger@xxxxxxxxx]
Sent: Tuesday, February 10, 2004 11:53 AM
To: Midrange Systems Technical Discussion
Subject: RE: Formatting an EXCEL Worksheet Generated From The 400


This doesn't solve the original problem if I read things
correctly.  If the value of a character field is 00255 Excel
will still interpret this as a number and lose the leading
zeros.  I checked this by using the html below and changing B
Widget's value to 00255.  Am I missing something?

Scott Mildenberger
--- Reggie Acosta <racosta@xxxxxxxxxxxxxxx> wrote:
> Recently, an associate, Ricky Thompson, gave me this tip. 
> He said, MS Excel will open a text file, formatted as an HTML 
> table, without any intervention if the file has a .xls
> extension. 
> Try it. Paste the HTML below into notepad and save it with the
> 
> .xls extension then open it in Excel.
> 
> You'll just need to create a the file with HTML table tags
> instead 
> of a CSV file. I'll leave that as an exercise for the reader.
> :)
> 
> <table border="1">
> <tr><td><b>Product
> Id</b></td><td><b>Description</b></td><td><b>On
> Hand</b></td><td></tr>
> <tr><td align="left">WIDGET-A</td><td align="left">A
> Widget</td><td>0</td></tr>
> <tr><td align="left">WIDGET-B</td><td align="left">B
> Widget</td><td>255</td></tr>
> </table>
> 



__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/04
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.580 / Virus Database: 367 - Release Date: 2/6/04
 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.