Reading data from excel & segregate it in different excels according to groups

Get Help & Discuss
1

Hi,

I want to read data from excel sheet where 1 single sheet is containing consolidated data of multiple groups, separated by 1 empty row.

I want to segregate group data in different excels according to groups.

How to achieve it in Process Studio?

Please guide on this.

Attaching sample excel having same format.SampleExcelInput.xlsx (9.9 KB)

2

Is there an answer to this problem ?
I have similar task to be done, my excel contains three sections, I want to read and process each of the three sections separately.
A sample of my excel is attached(refer Sheet MR)
MR_SR.xlsx (20.9 KB)

3

@NipunA if the location at the sheet is always the same I think you can achieve this by using VBScript excel commands where you can set the range to get values from.

4

but how do I assign the values of a range to a variable, that I can use in further steps of my Workflow.

for e.g.
in the ‘Execute VB Script’, I write
projNum = objExcel.ActiveWorkbook.Sheets(1).Range(“C2”)

now how can i use projNum in the next step (Web Set Value) in my workflow ?