Exporting to Excel 2003
 

Our business has an application that we use for business planning purposes.
One of its functions is to export the numbers in the grid to an Excel
spreadsheet. I think what happens behind the scene is that the gris is saved
in an XML file, which is then loaded into Excel. Anyway, this has always
worked correctly with Excel 2000. Since an upgrade to 2003, this is failing
at certain times. It is failing specifically when there is some text in the
grid. For example, a percentage might show as "NaN" in some cases. Excel
tries to open the grid and returns an error. The message box says "Problems
came up during load: The file cannot be opened because of errors." It seems
to me that Excel is trying to put text into a number field and doesn't know
what to do with it. I'm wondering if there is some setting in Excel 2003
that can be changed to allow this.

Thanks!

Exporting to Excel 2003
 

Excel doesn't really distinguish between text and number "fields" like a
database. It is just as happy putting numbers anywhere as it is putting text
any where.

What are exporting from? It may also be a good idea to supply the XML code,
if available.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jennifer" wrote:

Our business has an application that we use for business planning purposes.
One of its functions is to export the numbers in the grid to an Excel
spreadsheet. I think what happens behind the scene is that the gris is saved
in an XML file, which is then loaded into Excel. Anyway, this has always
worked correctly with Excel 2000. Since an upgrade to 2003, this is failing
at certain times. It is failing specifically when there is some text in the
grid. For example, a percentage might show as "NaN" in some cases. Excel
tries to open the grid and returns an error. The message box says "Problems
came up during load: The file cannot be opened because of errors." It seems
to me that Excel is trying to put text into a number field and doesn't know
what to do with it. I'm wondering if there is some setting in Excel 2003
that can be changed to allow this.

Thanks!