I have code like this:

                int colCount = worksheet.getColCount();
                if(colCount < COLS_REQUIRED){
                    worksheet.setColCount(COLS_REQUIRED);
                    worksheet.update();
                }

And if I have data in the spreadsheet already, the last column with
data in always gets moved to the last column in the new column count.

For example, lets say the sheet looks like this to start:

| Date | Name |

And I setColCount(10)

Then the sheet will end up like this:

| Date | _ | _ | _ | .... | Name |


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Google Docs Data APIs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to