Google Sheet API V4(Java) append Date in cells

by

To provide an example of what Sam’s answer means, if you just want to create a date value using AppendCellsRequest, you can create the cell like this:

CellData cell = new CellData();
cell.setUserEnteredValue(new ExtendedValue().setNumberValue(42198.0));
cell.setUserEnteredFormat(
    new CellFormat().setNumberFormat(new NumberFormat().setType("DATE")));

Here 42198 is the number of days between December 30th 1899 and July 13th 2015.

More Related Contents:

  1. Create Spreadsheet using Google Spreadsheet API in Google drive in Java
  2. split US phone number in java? [closed]
  3. Meaning of some operator in java [closed]
  4. Q. If you compile and execute an application with the following code in its main() method: Why ” s” is created two objects [duplicate]
  5. How do I tell Maven to use the latest version of a dependency?
  6. What are the reasons why Map.get(Object key) is not (fully) generic
  7. Java Hashmap: How to get key from value?
  8. Convert java.util.Date to what “java.time” type?
  9. What’s the difference between primitive and reference types?
  10. Custom button not working on mac (ButtonUI)
  11. Installed Java 7 on Mac OS X but Terminal is still using version 6
  12. Text-mouseover popups over a Swing JTextArea?
  13. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  14. TimeZone problem in Java
  15. AndroidRuntime error: Parcel: unable to marshal value
  16. How does Java 8′ new default interface model works (incl. diamond, multiple inheritance, and precedence)?
  17. How to Serialize a list in java?
  18. ThreadLocal & Memory Leak
  19. Memory barriers and coding style over a Java VM
  20. Hibernate use of PostgreSQL sequence does not affect sequence table
  21. Java check if two rectangles overlap at any point
  22. Encourage the JVM to GC rather than grow the heap?
  23. Is there anyway to exclude artifacts inherited from a parent POM?
  24. JFreeChart – Problem in creating moving chart
  25. Java – How to hook into the Copy and Paste menu on the Mac OS
  26. Unable to use Intellij with a generated sources folder
  27. Android – set TextView TextStyle programmatically?
  28. why autoimport only java.lang package?
  29. How to convert a Java String to an ASCII byte array?
  30. Breaking down RSA/ECB/OAEPWithSHA-256AndMGF1Padding

Leave a Comment