I tell you my problem:
I am trying to give values to different cells of a spreadsheet Google
from Java
. Currently what I do is instantiate an object of the class CellEntry
to which I indicate the text and the specific cell and then I insert it into the WorksheetEntry
.
With this I know that you are entering a specific value, but it falls short, I need to find a way to style the cell, that is, background color, bold text...
I have found that CellEntry
the content can be set 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
one introduced was the following:
<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 several cells can be concatenated and treated as if they were only one?
Thanks in advance.
Greetings.
After almost a year, and when I have been able to take time to resume the project, I have managed to achieve my goal with version 4 of the API. For the next one, let him know that here is the solution https://developers.google.com/sheets/samples/formatting?hl=es-419