Skip to main content
  • EN

Hi,

I'm trying to automate a process where FME reads in an Excel sheet in a specific format, but i need to split the Sheet into two parts (as they are completely different structures) and treat as two different datasets effectively. Is there a way in the Excel sheet reader to effectively duplicate a sheet in order to choose the different cell ranges that i require?

If the spreadsheet contains two different tables like this, you can just split the data flow from the Excel reader into two streams and write the two tables into different datasets separately.

This screenshot illustrates the basic concept. Depending on the actual structure of the source spreadsheet, probably you should consider some additional processes.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.