Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 10, 2013 12:54 PM by ilclaudio
Jan 07, 2013 09:10 PM|LINK
I have huge Excel files containing personal cards (informations about an individual) in the same sheet.
I can identify the beginning of each card using a certain string .
Now, how can I split this cards using VB.NET 2010?
Should I use queries?
Thank you very much
Jan 08, 2013 01:33 AM|LINK
Personally speaking, I think it is more easier to copy worksheet or cells than split. if you get the cell range, why not use copy the cells in a new sheet or a new workbook sheet. You can see below code:
Copy Excel Worksheet within Excel Workbook
Copy Excel Worksheets between Excel Workbooks
Dim newsheet As Worksheet = CType(worksheet.Clone(worksheet.Parent),Worksheet)
Copy Excel cells
I use a .NET Excel application:
Jan 10, 2013 12:54 PM|LINK
Thank you Pandalin