ansaurus

Question

Answer 1

+1 A:

Did you try quoting? i.e. "firstfield","second field","00032","etc"

sfuqua 2010-06-12 22:36:13

Answer 2

+1 A:

You might want to take a look into generating HTML instead. Using specific CSS information and additional attributes, you may be able to encode just enough information on the data that Excel does not mangle with it.

The basic idea is to tag your table data with a specific css class, and have that css class define, e.g., a number format:

<html>
 <head>
  <style>
   .myStyle { mso-number-format:"\@" }
  </style>
 </head>
 <body>
  <table>
   <tr>
    <td class="myStyle">000345</td>
   </tr>
  </table>
 </body>
</html>

Save such a file as .xls, and it opens in Excel. Excel will complain about html in a xls file, but open it nevertheless.

You can find a download for the documentation for this on MSDN:

Microsoft Office HTML and XML Reference

Arne 2010-06-15 20:05:58

This is a great idea... I wish I'd thought of it sooner. I ended up finishing the problem with quotes though, but will definitely keep this in mind for next time

baron 2010-06-17 05:13:40

ansaurus

tags:

views:

answers:

Using excel import wizard through code?

related questions