Writing a range that has less rows than original data


I am reading a datatable from one file and writing it to another. There may be times were the new data has less rows than the original data on the spreadsheet. How would I accommodate for this? I’m assuming the first step would be to obtain a row count for both data sets. Would the next step be to use an if workflow?

Hi @jenn.cruz,

When you write a DataTable to a spreadsheet, you typically specify the top left starting cell as the StartingCell for Classic Write Range activities or Destination (using the + Excel menu) for Modern Write DataTable to Excel activities. By specifying the starting cell only, there is no need to specify the dimensions of the destination within Excel.

Here is an example


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.