excel-sql

Hi Scenario - I need to send some 150 reports . At present my old team mate created c# code and created 150 exe with same code. So in each report folder it have 1sub folder with SQL script another 1cofig file and and exe. Now it came to me to simplify due to dependency issue. Now my approach is...

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 Key Email Password RememberMe LogInSuccessfully...

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...