Cell off grid error after generating Excel spreadsheet as XML

G

Gary Varga

Hi,

I have generated Excel Spreadsheets using the XML Spreadsheet Reference for
definitions and compared my generated XML with Excel generated XML and they
are almost identical and usually work.

It appears to not work when there is a larger amount of data. The difference
between the two generated formats is that I omit the optional Table
attributes ss:ExpandedColumnCount, ss:ExpandedRowCount x:FullColumns and
x:FullRows.

I get the following error repeated multiple times in the log when Excel
attempts to load the generated XML:

XML Spreadsheet Warning in Table
REASON: Cell off grid
ACTION: Ignoring Tag
FILE: C:\Documents and Settings\Administrator\Local Settings\Temporary
Internet Files\OLKF04\AllSitesReport.xls
GROUP: Row
TAG: Cell

(Please note that it is the client's standard developer setup to develop in
a VM logged on as Administrator).

I tried to search for a solution but all I got was a Maori translation for
"Cell of grid"!!!
 
D

David_in_Leeds

Gary Varga said:
Hi,

I have generated Excel Spreadsheets using the XML Spreadsheet Reference for
definitions and compared my generated XML with Excel generated XML and they
are almost identical and usually work.

It appears to not work when there is a larger amount of data. The difference
between the two generated formats is that I omit the optional Table
attributes ss:ExpandedColumnCount, ss:ExpandedRowCount x:FullColumns and
x:FullRows.

I get the following error repeated multiple times in the log when Excel
attempts to load the generated XML:

XML Spreadsheet Warning in Table
REASON: Cell off grid
ACTION: Ignoring Tag
FILE: C:\Documents and Settings\Administrator\Local Settings\Temporary
Internet Files\OLKF04\AllSitesReport.xls
GROUP: Row
TAG: Cell

(Please note that it is the client's standard developer setup to develop in
a VM logged on as Administrator).

I tried to search for a solution but all I got was a Maori translation for
"Cell of grid"!!!
 
D

David_in_Leeds

The problem is probably because you have exceeded the maximum number of rows
that Excel can handle i.e. 65536

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top