Categories > OpenTBS with XLSX >

Errors on exporting to EXCEL

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Marcelo
Date: 2010-05-18
Time: 17:14

Errors on exporting to EXCEL

Hi!

I'm looking through the Excel examples, but I have an error when I open the file, something like "...Problems on TABLE... ... This file can't be open..."

(My Excel is portuguese-br)

This only happens with blocks, if I just pass, for example, a [var.name], it works!

I don't know, but that Excel-XML, does have some parameter for max rows number?
By: Skrol29
Date: 2010-05-18
Time: 17:51

Re: Errors on exporting to EXCEL

Hi Marcelo,

Are you talking about the in line example of the Excel plugin ?
( http://www.tinybutstrong.com/plugins/excel/demo_main.htm )
By: Marcelo
Date: 2010-05-18
Time: 19:23

Re: Errors on exporting to EXCEL

Sorry, I didn't explained correctly...

I tried that example, and it worked.
Then I created my spreadsheet on Excel, and set the values to TBS Blocks ([blk.field]), and it didn't worked, seems like that table have a rows limit, because when I try with only on var, instead of a block, it shows...


I'm using Excel 2003.
By: Skrol29
Date: 2010-05-19
Time: 10:33

Re: Errors on exporting to EXCEL

This plugin assumes that you've saved the spreadsheet in the XML format. Otherwise this plugin cannot deal with the Excel file.
By: Marcelo
Date: 2010-05-19
Time: 13:51

Re: Errors on exporting to EXCEL

Hi Skrol,

I've saved in format XML all times, but everytime it gave me errors when opening the XLS generated by TBS.

My solution was use your Excel template, adding the fields I need.

My problem is over now, but I don't know what happened. I think is something related with the XML format ( nodes and atributes ) of my spreadsheet, created on Excel 2003.