Click here to Skip to main content
15,867,835 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a windows application that I want on button click to copy data from an Excel file to Text file using vb.net. In this file I have multiple sheets like sheet1, sheet2, sheet3 and I want the data in each sheet to be copied to a different text file.
Posted

1 solution

To work with Excel files, you can use either Office Interop assemblies or Open XML SDK.
Please see my past answer: How to add microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010[^].

See also this one: Creating basic Excel workbook with Open XML[^].

—SA
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900