excel-sql

  1. A

    Answered How to compress multi Excel files to zip Archive ?

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

    Need help when dealing with Excel Complex Data in MSTest

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

    Data import from Excel Files

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