i need to separate a Excel sheet then save it with a name from the inside of the sheet

[Bleck]

Hello
I need to create a work flow, but I have no clue where to start, so I need to separate an Excel sheet in specific points and save it, and each one that is saved needs to have a specific name that is inside the document

(basically, I have a bunch of documents in one excel, each document having 10 rows, I need to separate them and then add the name according to a bunch of parameters that are in each document)
any ideas on nodes I could use for that, the main points that are killing me are the separation and the naming
thank you for your time

[bruno29a]

Hi @Bleck , I’m not sure I follow what you want to do.

What do you mean by “separation”? Are you trying to save excel sheets as individual excel files (or csv files, or text files may be) and saving the files with filename as the sheet name?

[mlauber71]

@Bleck you could try something like this. Identify a row in excel and then split the data. You will have to modify it.

Loop on the basis of single Excel sheet data

OK it was slightly more complicated than I initially thought. But I hope it does work now: give each line a unique ID to identify them later identify the ‘heads’ of the tables (“FORMNAME”) like you already did use moving aggregate to give the heads unique numbers bring these numbers back to the data fill the intermediate (empty) cells with the head’s number use a group loop on the blocks identified by the head numbers extract the first line as column names make sure empty columns that would ju…

Or you could provide us with an example that represents your challenge.