I working on c# 5 app create more than excel files xlsx
but I face Issue I cannot compress these files to one file as zip archive .
meaning if result of code below of three files as abc.xlsx and autod.xlsx and mog.xlsx as examples
then create all theses file to one file as zip archive with...
Currently, I am fetching data from particular sheet where it matched a "Key" value - But now I want to access data from all sheets where it matches "Key" value
In my excel - I have two sheets: LogInUserData and Sheet2
Now in LogInUserData
Hi All. I am working on a project where I need to carry out below steps.
1. Import data from Excel and display using datagridview
2. Create local database in the application - Windows .Net form application
3. Convert the loaded data into SQL format (SQL readable format)
4. Store the data in...