All Questions
8
questions
2
votes
1
answer
203
views
VB.net SQL match against Excel data to datagridview
I am importing an Excel sheet where the first column will contain product numbers. I match those numbers to my SQL database and display the product number and description of the matching products to a ...
- 23
2
votes
0
answers
69
views
Updating Excel sheet with information from a DataTable
Basically, I'm trying to update an excel sheet using a DataTable (The columns structure between the two are not the same) with respect to the following rules:
...
- 215
2
votes
0
answers
48
views
Creating an Excel sheet and appending namings for a matrix
I'm working on some VB.Net code to generate data sheets for giving user rights on a per folder level. I came up with this code but it's very slow and I feel like it could be improved.
...
- 217
2
votes
0
answers
131
views
Multithreaded download of images from a spreadsheet
I've been wanting to go async with my HTTP calls but all the methods I tried have not worked, so I resolved to implement this as a task and then improve upon it.
This is what I've come up with so far....
- 75
1
vote
1
answer
114
views
Private method to validate Excel header
I am new to unit testing and I am unsure how to design classes that use third party libraries, so that I can easily test them. The example I'll use is with EPPlus-...
- 148
6
votes
1
answer
6k
views
Paste from Excel to DataGridView
I have this code that helps me to paste data from an Excel file to a Datagridview:
...
- 63
4
votes
2
answers
3k
views
Excel sheet code is taking too much time
I have an Excel sheet with lot of rows with data. I am separating it into 2 sheets with some condition satisfies.
This is taking too much time. How can I improve the speed? Please suggest any ...
- 41
7
votes
2
answers
394
views
Optimizing this Excel automation
The createReport method takes around 30 seconds to execute and I was wondering how I could optimize it. I'm using the ...
- 211