Loading

Excel to multiple excel

Sujay Anand

I have excel file with list of some companies in sheet1. And same companies in sheet2. How to split the data as companies wise for each excel. And sheet2 data to be also in that output excel.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sujay Anand7y ago
I am not asking like that. I have excel with multiple sheet as diwali,pongal and christmas. For each company I need seprate excel with multiple sheet as diwali , pongal and christmas.
0
Leon D7y ago
You can use Spire.XLS to achieve this.

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Document-Operation/How-to-Split-One-Excel-Worksheet-to-Several-Excel-Documents-by-a-Custom-Range-of-Rows.html
0