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.
Greetings.