Hello,
Can someone help me how to make these steps inside my code?
Without using Microsoft excel library, maybe some other way other library free or better solution.
What i want to do is:
I have the textbox that shows folder location.
Inside the folder i have specific 5 files with fixed text that i want to be checked does they exists.
When press button Check Files to check does they exists and display in Datagridview1 the results.
In datagridview1 i have 2 columns
First column will add the default File names from the files that are fixed in the code. What files it searches.
Second column is to check is the sheet names inside the files the same name. Sheet names are fixed. To detect does it has only 1 sheet name inside the excel with the fixed text and if it does display in Datagridview1 column2 rows the names of the files. If it has additional sheets created inside the excel will give error message in field.
