yes but split work sheet splitting the one excel file into 2 excel files,but i want in one excl file 2 sheetsStill one more option for u
In the MS Excel Vbo, we have split worksheet option. Hope this answers ur quesiton.
Can u give logic for Calculate rows and round no.of rows? i mean screen shots of thoseAnother easier approach is as below.
You still need to make amendments for scenarios like 1 row in excel, 0 rows in excel, etc.
To do that simply add a Decision and Calc stage to adjust the SplitTotalRows depending on the Total Rows returned.
Make use of the Copy Paste Worksheet Range.
Copy Header and then Data to the corresponding sheets.
Hi, everything works but im getting following errorCan u give logic for Calculate rows and round no.of rows? i mean screen shots of those
Got It Bro...thankyouAnother easier approach is as below.
You still need to make amendments for scenarios like 1 row in excel, 0 rows in excel, etc.
To do that simply add a Decision and Calc stage to adjust the SplitTotalRows depending on the Total Rows returned.
Make use of the Copy Paste Worksheet Range.
Copy Header and then Data to the corresponding sheets.