Fill / give value cell Google SpreadSheet


I tell you my problem:

I'm trying to give values to the different cells of a spreadsheet of Google from Java . Currently what I do is instantiate an object of the class CellEntry to which I indicate the text and the concrete cell and then insert it into WorksheetEntry .

With this I already know that it introduces a concrete value, but it falls short, I need to find the way to give a style to the cell, that is, background color, bold text ...

I have found that the CellEntry can be set to the content with a TextConstruct , which has a static method to insert code HTML and that I have tried, but unfortunately it has given me the following error:


Exception in thread "main" java.lang.UnsupportedOperationException: Field is server-generated.

The HTML entered has been as follows:

<div><a href=\"http://whoa!\">whoa</a></div>

Do you know what I'm doing wrong? Can you think of another way to do what I want?

And another question, do you know if you can concatenate several cells and treat them as if they were only one?

Thanks in advance.


asked by Miguel García 11.07.2016 в 19:54

1 answer


After almost a year, and when I was able to take time to resume the project, I managed to achieve my goal with version 4 of the API. For the next, know that here is the solution link

answered by 03.08.2018 / 21:55