Question

How to write excel to google sheet template ?

  • 23 March 2021
  • 1 reply
  • 0 views

Badge +5

Hi all,

I need write excel (from 2nd rows) to google sheet template (write from 3rd row).

Could you tell me how to do it? Thank you


1 reply

Userlevel 1
Badge +10

Hi @hoa_le​ - When adding the Excel Reader to your FME workspace, click on the and the Parameter button. In the following Excel Parameters window, you'll have options to specify which row you'd like to read from:

For writing to a specific row in your Google Sheet, after adding the Google Sheet Writer to your workspace, open up the Writer Feature Type Parameters. You'll find parameters that will allow you to control where in your sheet you'd like to start writing:

I hope this helps!

Reply